ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "St. Louis city" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
79912 | 79912 | 2020-04-22 | St. Louis city | Missouri | 29510 | 893 | 45 |
77125 | 77125 | 2020-04-21 | St. Louis city | Missouri | 29510 | 877 | 40 |
74344 | 74344 | 2020-04-20 | St. Louis city | Missouri | 29510 | 859 | 30 |
71571 | 71571 | 2020-04-19 | St. Louis city | Missouri | 29510 | 831 | 30 |
68804 | 68804 | 2020-04-18 | St. Louis city | Missouri | 29510 | 808 | 30 |
66050 | 66050 | 2020-04-17 | St. Louis city | Missouri | 29510 | 711 | 30 |
63310 | 63310 | 2020-04-16 | St. Louis city | Missouri | 29510 | 706 | 27 |
60588 | 60588 | 2020-04-15 | St. Louis city | Missouri | 29510 | 700 | 27 |
57874 | 57874 | 2020-04-14 | St. Louis city | Missouri | 29510 | 695 | 26 |
55176 | 55176 | 2020-04-13 | St. Louis city | Missouri | 29510 | 639 | 24 |
52494 | 52494 | 2020-04-12 | St. Louis city | Missouri | 29510 | 614 | 17 |
49821 | 49821 | 2020-04-11 | St. Louis city | Missouri | 29510 | 585 | 17 |
47173 | 47173 | 2020-04-10 | St. Louis city | Missouri | 29510 | 536 | 17 |
44564 | 44564 | 2020-04-09 | St. Louis city | Missouri | 29510 | 498 | 13 |
41986 | 41986 | 2020-04-08 | St. Louis city | Missouri | 29510 | 444 | 12 |
39432 | 39432 | 2020-04-07 | St. Louis city | Missouri | 29510 | 399 | 12 |
36916 | 36916 | 2020-04-06 | St. Louis city | Missouri | 29510 | 357 | 8 |
34450 | 34450 | 2020-04-05 | St. Louis city | Missouri | 29510 | 298 | 8 |
32022 | 32022 | 2020-04-04 | St. Louis city | Missouri | 29510 | 287 | 6 |
29641 | 29641 | 2020-04-03 | St. Louis city | Missouri | 29510 | 275 | 5 |
27319 | 27319 | 2020-04-02 | St. Louis city | Missouri | 29510 | 216 | 1 |
25062 | 25062 | 2020-04-01 | St. Louis city | Missouri | 29510 | 136 | 1 |
22874 | 22874 | 2020-03-31 | St. Louis city | Missouri | 29510 | 136 | 1 |
20755 | 20755 | 2020-03-30 | St. Louis city | Missouri | 29510 | 102 | 1 |
18722 | 18722 | 2020-03-29 | St. Louis city | Missouri | 29510 | 97 | 1 |
16800 | 16800 | 2020-03-28 | St. Louis city | Missouri | 29510 | 93 | 1 |
14975 | 14975 | 2020-03-27 | St. Louis city | Missouri | 29510 | 72 | 1 |
13247 | 13247 | 2020-03-26 | St. Louis city | Missouri | 29510 | 69 | 1 |
11649 | 11649 | 2020-03-25 | St. Louis city | Missouri | 29510 | 53 | 1 |
10220 | 10220 | 2020-03-24 | St. Louis city | Missouri | 29510 | 15 | 1 |
8918 | 8918 | 2020-03-23 | St. Louis city | Missouri | 29510 | 15 | 1 |
7726 | 7726 | 2020-03-22 | St. Louis city | Missouri | 29510 | 14 | 0 |
6637 | 6637 | 2020-03-21 | St. Louis city | Missouri | 29510 | 10 | 0 |
5647 | 5647 | 2020-03-20 | St. Louis city | Missouri | 29510 | 6 | 0 |
4809 | 4809 | 2020-03-19 | St. Louis city | Missouri | 29510 | 5 | 0 |
4090 | 4090 | 2020-03-18 | St. Louis city | Missouri | 29510 | 1 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);