Earlier this week, [u/EricW\_CS](https://www.reddit.com/user/EricW_CS/) posted about his [US Supreme Court transcript dataset](https://github.com/EricWiener/supreme-court-cases). 

I took the liberty of importing it into [Dolt](https://github.com/liquidata-inc/dolt) which is a SQL database with Git Semantics. It's on DoltHub for everyone to use:

https://www.dolthub.com/repositories/Liquidata/us-supreme-court-cases

I did a little bit of cleaning in the process or importing it. It's a very cool dataset to run SQL on. Famous quote by Sandra Day O'Connor:

```
timsehn$ dolt sql -q "select * from transcripts where speaker='Sandra Day O\'Connor' and text like '%pornography%'"
+--------------------------------------------+-----------------------------------+----------------------------------------------------------------------+---------------------+----------+----------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| case_name                                  | title                             | link                                                                 | speaker             | start    | stop     | duration | text                                                                                                                                                                                                                                                                                  |
+--------------------------------------------+-----------------------------------+----------------------------------------------------------------------+---------------------+----------+----------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Ashcroft v. American Civil Liberties Union | Oral Argument - March 02, 2004    | https://apps.oyez.org/player/#/rehnquist10/oral_argument_audio/22093 | Sandra Day O'Connor | 136.198  | 154.982  | 18.78    | Mr. Olson, part of the problem is that the pornography laws that would apply to adult viewers don't seem to be enforced very well, the obscenity laws.                                                                                                                                |
| Ashcroft v. Free Speech Coalition          | Oral Argument - October 30, 2001  | https://apps.oyez.org/player/#/rehnquist10/oral_argument_audio/21372 | Sandra Day O'Connor | 483.178  | 492.276  | 9.1      | Mr. Clement, may I ask you a question again relating to the affirmative defenses or youthful adult pornography.                                                                                                                                                                       |
| Hunter v. Underwood                        | Oral Argument - February 26, 1985 | https://apps.oyez.org/player/#/burger8/oral_argument_audio/19281     | Sandra Day O'Connor | 1538.688 | 1559.452 | 20.76    | The Court of Appeals also indicated, I think in a footnote, that the statute was under-inclusive because sometimes that apparently it would be characterized at least by the Court of Appeals as crimes of moral turpitude are not included such as mailing pornography and so forth. |
| United States v. X-Citement Video, Inc.    | Oral Argument - October 05, 1994  | https://apps.oyez.org/player/#/rehnquist10/oral_argument_audio/20030 | Sandra Day O'Connor | 1643.659 | 1654.034 | 10.38    | Well, General Days, I thought we had already agreed that it doesn't require obscenity or pornography, but just a visual depiction of sexually explicit conduct.                                                                                                                       |
| Wal-Mart Stores Inc. v. Samara Bros. Inc.  | Oral Argument - January 19, 2000  | https://apps.oyez.org/player/#/rehnquist10/oral_argument_audio/20162 | Sandra Day O'Connor | 253.073  | 257.584  | 4.51     | It's... it's sort of like pornography: I know it when I see it.                                                                                                                                                                                                                       |
+--------------------------------------------+-----------------------------------+----------------------------------------------------------------------+---------------------+----------+----------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
```