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 state
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- …
state 1
- Missouri · 787 ✖
fips 1
- 29510 787
county 1
- St. Louis city · 787 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4090 | 4090 | 2020-03-18 | St. Louis city | Missouri | 29510 | 1 | 0 |
4809 | 4809 | 2020-03-19 | St. Louis city | Missouri | 29510 | 5 | 0 |
5647 | 5647 | 2020-03-20 | St. Louis city | Missouri | 29510 | 6 | 0 |
6637 | 6637 | 2020-03-21 | St. Louis city | Missouri | 29510 | 10 | 0 |
7726 | 7726 | 2020-03-22 | St. Louis city | Missouri | 29510 | 14 | 0 |
8918 | 8918 | 2020-03-23 | St. Louis city | Missouri | 29510 | 15 | 1 |
10220 | 10220 | 2020-03-24 | St. Louis city | Missouri | 29510 | 15 | 1 |
11649 | 11649 | 2020-03-25 | St. Louis city | Missouri | 29510 | 53 | 1 |
13247 | 13247 | 2020-03-26 | St. Louis city | Missouri | 29510 | 69 | 1 |
14975 | 14975 | 2020-03-27 | St. Louis city | Missouri | 29510 | 72 | 1 |
16800 | 16800 | 2020-03-28 | St. Louis city | Missouri | 29510 | 93 | 1 |
18722 | 18722 | 2020-03-29 | St. Louis city | Missouri | 29510 | 97 | 1 |
20755 | 20755 | 2020-03-30 | St. Louis city | Missouri | 29510 | 102 | 1 |
22874 | 22874 | 2020-03-31 | St. Louis city | Missouri | 29510 | 136 | 1 |
25062 | 25062 | 2020-04-01 | St. Louis city | Missouri | 29510 | 136 | 1 |
27319 | 27319 | 2020-04-02 | St. Louis city | Missouri | 29510 | 216 | 1 |
29641 | 29641 | 2020-04-03 | St. Louis city | Missouri | 29510 | 275 | 5 |
32022 | 32022 | 2020-04-04 | St. Louis city | Missouri | 29510 | 287 | 6 |
34450 | 34450 | 2020-04-05 | St. Louis city | Missouri | 29510 | 298 | 8 |
36916 | 36916 | 2020-04-06 | St. Louis city | Missouri | 29510 | 357 | 8 |
39432 | 39432 | 2020-04-07 | St. Louis city | Missouri | 29510 | 399 | 12 |
41986 | 41986 | 2020-04-08 | St. Louis city | Missouri | 29510 | 444 | 12 |
44564 | 44564 | 2020-04-09 | St. Louis city | Missouri | 29510 | 498 | 13 |
47173 | 47173 | 2020-04-10 | St. Louis city | Missouri | 29510 | 536 | 17 |
49821 | 49821 | 2020-04-11 | St. Louis city | Missouri | 29510 | 585 | 17 |
52494 | 52494 | 2020-04-12 | St. Louis city | Missouri | 29510 | 614 | 17 |
55176 | 55176 | 2020-04-13 | St. Louis city | Missouri | 29510 | 639 | 24 |
57874 | 57874 | 2020-04-14 | St. Louis city | Missouri | 29510 | 695 | 26 |
60588 | 60588 | 2020-04-15 | St. Louis city | Missouri | 29510 | 700 | 27 |
63310 | 63310 | 2020-04-16 | St. Louis city | Missouri | 29510 | 706 | 27 |
66050 | 66050 | 2020-04-17 | St. Louis city | Missouri | 29510 | 711 | 30 |
68804 | 68804 | 2020-04-18 | St. Louis city | Missouri | 29510 | 808 | 30 |
71571 | 71571 | 2020-04-19 | St. Louis city | Missouri | 29510 | 831 | 30 |
74344 | 74344 | 2020-04-20 | St. Louis city | Missouri | 29510 | 859 | 30 |
77125 | 77125 | 2020-04-21 | St. Louis city | Missouri | 29510 | 877 | 40 |
79912 | 79912 | 2020-04-22 | St. Louis city | Missouri | 29510 | 893 | 45 |
82708 | 82708 | 2020-04-23 | St. Louis city | Missouri | 29510 | 909 | 46 |
85512 | 85512 | 2020-04-24 | St. Louis city | Missouri | 29510 | 950 | 48 |
88322 | 88322 | 2020-04-25 | St. Louis city | Missouri | 29510 | 985 | 50 |
91138 | 91138 | 2020-04-26 | St. Louis city | Missouri | 29510 | 1007 | 50 |
93959 | 93959 | 2020-04-27 | St. Louis city | Missouri | 29510 | 1027 | 54 |
96795 | 96795 | 2020-04-28 | St. Louis city | Missouri | 29510 | 1054 | 55 |
99641 | 99641 | 2020-04-29 | St. Louis city | Missouri | 29510 | 1067 | 60 |
102493 | 102493 | 2020-04-30 | St. Louis city | Missouri | 29510 | 1077 | 60 |
105354 | 105354 | 2020-05-01 | St. Louis city | Missouri | 29510 | 1105 | 64 |
108219 | 108219 | 2020-05-02 | St. Louis city | Missouri | 29510 | 1186 | 65 |
111091 | 111091 | 2020-05-03 | St. Louis city | Missouri | 29510 | 1304 | 70 |
113970 | 113970 | 2020-05-04 | St. Louis city | Missouri | 29510 | 1304 | 71 |
116852 | 116852 | 2020-05-05 | St. Louis city | Missouri | 29510 | 1315 | 78 |
119812 | 119812 | 2020-05-06 | St. Louis city | Missouri | 29510 | 1384 | 82 |
122786 | 122786 | 2020-05-07 | St. Louis city | Missouri | 29510 | 1450 | 83 |
125768 | 125768 | 2020-05-08 | St. Louis city | Missouri | 29510 | 1474 | 85 |
128756 | 128756 | 2020-05-09 | St. Louis city | Missouri | 29510 | 1484 | 86 |
131746 | 131746 | 2020-05-10 | St. Louis city | Missouri | 29510 | 1513 | 88 |
134737 | 134737 | 2020-05-11 | St. Louis city | Missouri | 29510 | 1526 | 90 |
137727 | 137727 | 2020-05-12 | St. Louis city | Missouri | 29510 | 1549 | 91 |
140721 | 140721 | 2020-05-13 | St. Louis city | Missouri | 29510 | 1571 | 95 |
143716 | 143716 | 2020-05-14 | St. Louis city | Missouri | 29510 | 1596 | 95 |
146717 | 146717 | 2020-05-15 | St. Louis city | Missouri | 29510 | 1602 | 95 |
149723 | 149723 | 2020-05-16 | St. Louis city | Missouri | 29510 | 1631 | 96 |
152734 | 152734 | 2020-05-17 | St. Louis city | Missouri | 29510 | 1654 | 97 |
155748 | 155748 | 2020-05-18 | St. Louis city | Missouri | 29510 | 1682 | 100 |
158766 | 158766 | 2020-05-19 | St. Louis city | Missouri | 29510 | 1705 | 108 |
161792 | 161792 | 2020-05-20 | St. Louis city | Missouri | 29510 | 1717 | 109 |
164821 | 164821 | 2020-05-21 | St. Louis city | Missouri | 29510 | 1744 | 109 |
167857 | 167857 | 2020-05-22 | St. Louis city | Missouri | 29510 | 1763 | 110 |
170896 | 170896 | 2020-05-23 | St. Louis city | Missouri | 29510 | 1789 | 110 |
173938 | 173938 | 2020-05-24 | St. Louis city | Missouri | 29510 | 1815 | 112 |
176981 | 176981 | 2020-05-25 | St. Louis city | Missouri | 29510 | 1849 | 112 |
180025 | 180025 | 2020-05-26 | St. Louis city | Missouri | 29510 | 1867 | 116 |
183073 | 183073 | 2020-05-27 | St. Louis city | Missouri | 29510 | 1884 | 117 |
186129 | 186129 | 2020-05-28 | St. Louis city | Missouri | 29510 | 1906 | 118 |
189187 | 189187 | 2020-05-29 | St. Louis city | Missouri | 29510 | 1916 | 118 |
192251 | 192251 | 2020-05-30 | St. Louis city | Missouri | 29510 | 1930 | 130 |
195321 | 195321 | 2020-05-31 | St. Louis city | Missouri | 29510 | 1955 | 130 |
198392 | 198392 | 2020-06-01 | St. Louis city | Missouri | 29510 | 1974 | 130 |
201465 | 201465 | 2020-06-02 | St. Louis city | Missouri | 29510 | 1990 | 131 |
204542 | 204542 | 2020-06-03 | St. Louis city | Missouri | 29510 | 2006 | 132 |
207623 | 207623 | 2020-06-04 | St. Louis city | Missouri | 29510 | 2034 | 132 |
210704 | 210704 | 2020-06-05 | St. Louis city | Missouri | 29510 | 2053 | 134 |
213788 | 213788 | 2020-06-06 | St. Louis city | Missouri | 29510 | 2068 | 135 |
216877 | 216877 | 2020-06-07 | St. Louis city | Missouri | 29510 | 2071 | 135 |
219969 | 219969 | 2020-06-08 | St. Louis city | Missouri | 29510 | 2071 | 135 |
223064 | 223064 | 2020-06-09 | St. Louis city | Missouri | 29510 | 2132 | 139 |
226163 | 226163 | 2020-06-10 | St. Louis city | Missouri | 29510 | 2145 | 139 |
229266 | 229266 | 2020-06-11 | St. Louis city | Missouri | 29510 | 2162 | 139 |
232370 | 232370 | 2020-06-12 | St. Louis city | Missouri | 29510 | 2179 | 141 |
235476 | 235476 | 2020-06-13 | St. Louis city | Missouri | 29510 | 2195 | 141 |
238583 | 238583 | 2020-06-14 | St. Louis city | Missouri | 29510 | 2206 | 141 |
241693 | 241693 | 2020-06-15 | St. Louis city | Missouri | 29510 | 2219 | 141 |
244804 | 244804 | 2020-06-16 | St. Louis city | Missouri | 29510 | 2219 | 141 |
247917 | 247917 | 2020-06-17 | St. Louis city | Missouri | 29510 | 2234 | 142 |
251030 | 251030 | 2020-06-18 | St. Louis city | Missouri | 29510 | 2292 | 148 |
254145 | 254145 | 2020-06-19 | St. Louis city | Missouri | 29510 | 2319 | 154 |
257266 | 257266 | 2020-06-20 | St. Louis city | Missouri | 29510 | 2319 | 154 |
260392 | 260392 | 2020-06-21 | St. Louis city | Missouri | 29510 | 2319 | 154 |
263520 | 263520 | 2020-06-22 | St. Louis city | Missouri | 29510 | 2319 | 154 |
266646 | 266646 | 2020-06-23 | St. Louis city | Missouri | 29510 | 2319 | 154 |
269779 | 269779 | 2020-06-24 | St. Louis city | Missouri | 29510 | 2319 | 154 |
272918 | 272918 | 2020-06-25 | St. Louis city | Missouri | 29510 | 2310 | 155 |
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);