ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "St. Louis" and state = "Missouri" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
707 | 707 | 2020-03-07 | St. Louis | Missouri | 29189 | 1 | 0 |
811 | 811 | 2020-03-08 | St. Louis | Missouri | 29189 | 1 | 0 |
935 | 935 | 2020-03-09 | St. Louis | Missouri | 29189 | 1 | 0 |
1085 | 1085 | 2020-03-10 | St. Louis | Missouri | 29189 | 1 | 0 |
1267 | 1267 | 2020-03-11 | St. Louis | Missouri | 29189 | 1 | 0 |
1494 | 1494 | 2020-03-12 | St. Louis | Missouri | 29189 | 1 | 0 |
1782 | 1782 | 2020-03-13 | St. Louis | Missouri | 29189 | 2 | 0 |
2127 | 2127 | 2020-03-14 | St. Louis | Missouri | 29189 | 2 | 0 |
2534 | 2534 | 2020-03-15 | St. Louis | Missouri | 29189 | 2 | 0 |
2989 | 2989 | 2020-03-16 | St. Louis | Missouri | 29189 | 4 | 0 |
3499 | 3499 | 2020-03-17 | St. Louis | Missouri | 29189 | 5 | 0 |
4089 | 4089 | 2020-03-18 | St. Louis | Missouri | 29189 | 6 | 0 |
4808 | 4808 | 2020-03-19 | St. Louis | Missouri | 29189 | 10 | 0 |
5646 | 5646 | 2020-03-20 | St. Louis | Missouri | 29189 | 13 | 1 |
6636 | 6636 | 2020-03-21 | St. Louis | Missouri | 29189 | 22 | 1 |
7725 | 7725 | 2020-03-22 | St. Louis | Missouri | 29189 | 55 | 1 |
8917 | 8917 | 2020-03-23 | St. Louis | Missouri | 29189 | 68 | 1 |
10219 | 10219 | 2020-03-24 | St. Louis | Missouri | 29189 | 68 | 1 |
11648 | 11648 | 2020-03-25 | St. Louis | Missouri | 29189 | 129 | 1 |
13246 | 13246 | 2020-03-26 | St. Louis | Missouri | 29189 | 173 | 1 |
14974 | 14974 | 2020-03-27 | St. Louis | Missouri | 29189 | 247 | 2 |
16799 | 16799 | 2020-03-28 | St. Louis | Missouri | 29189 | 313 | 2 |
18721 | 18721 | 2020-03-29 | St. Louis | Missouri | 29189 | 336 | 2 |
20754 | 20754 | 2020-03-30 | St. Louis | Missouri | 29189 | 366 | 2 |
22873 | 22873 | 2020-03-31 | St. Louis | Missouri | 29189 | 492 | 3 |
25061 | 25061 | 2020-04-01 | St. Louis | Missouri | 29189 | 492 | 3 |
27318 | 27318 | 2020-04-02 | St. Louis | Missouri | 29189 | 712 | 6 |
29640 | 29640 | 2020-04-03 | St. Louis | Missouri | 29189 | 794 | 7 |
32021 | 32021 | 2020-04-04 | St. Louis | Missouri | 29189 | 864 | 11 |
34449 | 34449 | 2020-04-05 | St. Louis | Missouri | 29189 | 883 | 13 |
36915 | 36915 | 2020-04-06 | St. Louis | Missouri | 29189 | 1033 | 14 |
39431 | 39431 | 2020-04-07 | St. Louis | Missouri | 29189 | 1203 | 24 |
41985 | 41985 | 2020-04-08 | St. Louis | Missouri | 29189 | 1302 | 26 |
44563 | 44563 | 2020-04-09 | St. Louis | Missouri | 29189 | 1393 | 28 |
47172 | 47172 | 2020-04-10 | St. Louis | Missouri | 29189 | 1498 | 33 |
49820 | 49820 | 2020-04-11 | St. Louis | Missouri | 29189 | 1568 | 42 |
52493 | 52493 | 2020-04-12 | St. Louis | Missouri | 29189 | 1633 | 42 |
55175 | 55175 | 2020-04-13 | St. Louis | Missouri | 29189 | 1724 | 50 |
57873 | 57873 | 2020-04-14 | St. Louis | Missouri | 29189 | 1851 | 53 |
60587 | 60587 | 2020-04-15 | St. Louis | Missouri | 29189 | 1938 | 63 |
63309 | 63309 | 2020-04-16 | St. Louis | Missouri | 29189 | 2026 | 66 |
66049 | 66049 | 2020-04-17 | St. Louis | Missouri | 29189 | 2088 | 72 |
68803 | 68803 | 2020-04-18 | St. Louis | Missouri | 29189 | 2163 | 80 |
71570 | 71570 | 2020-04-19 | St. Louis | Missouri | 29189 | 2214 | 81 |
74343 | 74343 | 2020-04-20 | St. Louis | Missouri | 29189 | 2289 | 82 |
77124 | 77124 | 2020-04-21 | St. Louis | Missouri | 29189 | 2333 | 91 |
79911 | 79911 | 2020-04-22 | St. Louis | Missouri | 29189 | 2436 | 97 |
82707 | 82707 | 2020-04-23 | St. Louis | Missouri | 29189 | 2507 | 105 |
85511 | 85511 | 2020-04-24 | St. Louis | Missouri | 29189 | 2625 | 121 |
88321 | 88321 | 2020-04-25 | St. Louis | Missouri | 29189 | 2718 | 127 |
91137 | 91137 | 2020-04-26 | St. Louis | Missouri | 29189 | 2794 | 127 |
93958 | 93958 | 2020-04-27 | St. Louis | Missouri | 29189 | 2897 | 137 |
96794 | 96794 | 2020-04-28 | St. Louis | Missouri | 29189 | 2958 | 159 |
99640 | 99640 | 2020-04-29 | St. Louis | Missouri | 29189 | 3008 | 159 |
102492 | 102492 | 2020-04-30 | St. Louis | Missouri | 29189 | 3049 | 162 |
105353 | 105353 | 2020-05-01 | St. Louis | Missouri | 29189 | 3151 | 168 |
108218 | 108218 | 2020-05-02 | St. Louis | Missouri | 29189 | 3244 | 177 |
111090 | 111090 | 2020-05-03 | St. Louis | Missouri | 29189 | 3325 | 177 |
113969 | 113969 | 2020-05-04 | St. Louis | Missouri | 29189 | 3419 | 177 |
116851 | 116851 | 2020-05-05 | St. Louis | Missouri | 29189 | 3467 | 189 |
119811 | 119811 | 2020-05-06 | St. Louis | Missouri | 29189 | 3539 | 204 |
122785 | 122785 | 2020-05-07 | St. Louis | Missouri | 29189 | 3621 | 220 |
125767 | 125767 | 2020-05-08 | St. Louis | Missouri | 29189 | 3667 | 246 |
128755 | 128755 | 2020-05-09 | St. Louis | Missouri | 29189 | 3727 | 255 |
131745 | 131745 | 2020-05-10 | St. Louis | Missouri | 29189 | 3804 | 262 |
134736 | 134736 | 2020-05-11 | St. Louis | Missouri | 29189 | 3828 | 266 |
137726 | 137726 | 2020-05-12 | St. Louis | Missouri | 29189 | 3868 | 278 |
140720 | 140720 | 2020-05-13 | St. Louis | Missouri | 29189 | 4022 | 293 |
143715 | 143715 | 2020-05-14 | St. Louis | Missouri | 29189 | 4022 | 305 |
146716 | 146716 | 2020-05-15 | St. Louis | Missouri | 29189 | 4025 | 318 |
149722 | 149722 | 2020-05-16 | St. Louis | Missouri | 29189 | 4106 | 329 |
152733 | 152733 | 2020-05-17 | St. Louis | Missouri | 29189 | 4287 | 335 |
155747 | 155747 | 2020-05-18 | St. Louis | Missouri | 29189 | 4324 | 336 |
158765 | 158765 | 2020-05-19 | St. Louis | Missouri | 29189 | 4374 | 347 |
161791 | 161791 | 2020-05-20 | St. Louis | Missouri | 29189 | 4410 | 352 |
164820 | 164820 | 2020-05-21 | St. Louis | Missouri | 29189 | 4472 | 376 |
167856 | 167856 | 2020-05-22 | St. Louis | Missouri | 29189 | 4472 | 380 |
170895 | 170895 | 2020-05-23 | St. Louis | Missouri | 29189 | 4472 | 384 |
173937 | 173937 | 2020-05-24 | St. Louis | Missouri | 29189 | 4479 | 385 |
176980 | 176980 | 2020-05-25 | St. Louis | Missouri | 29189 | 4544 | 387 |
180024 | 180024 | 2020-05-26 | St. Louis | Missouri | 29189 | 4583 | 387 |
183072 | 183072 | 2020-05-27 | St. Louis | Missouri | 29189 | 4656 | 389 |
186128 | 186128 | 2020-05-28 | St. Louis | Missouri | 29189 | 4704 | 395 |
189186 | 189186 | 2020-05-29 | St. Louis | Missouri | 29189 | 4730 | 415 |
192250 | 192250 | 2020-05-30 | St. Louis | Missouri | 29189 | 4773 | 442 |
195320 | 195320 | 2020-05-31 | St. Louis | Missouri | 29189 | 4802 | 443 |
198391 | 198391 | 2020-06-01 | St. Louis | Missouri | 29189 | 4834 | 443 |
201464 | 201464 | 2020-06-02 | St. Louis | Missouri | 29189 | 4886 | 444 |
204541 | 204541 | 2020-06-03 | St. Louis | Missouri | 29189 | 4913 | 446 |
207622 | 207622 | 2020-06-04 | St. Louis | Missouri | 29189 | 4955 | 449 |
210703 | 210703 | 2020-06-05 | St. Louis | Missouri | 29189 | 5005 | 455 |
213787 | 213787 | 2020-06-06 | St. Louis | Missouri | 29189 | 5029 | 460 |
216876 | 216876 | 2020-06-07 | St. Louis | Missouri | 29189 | 5272 | 460 |
219968 | 219968 | 2020-06-08 | St. Louis | Missouri | 29189 | 5301 | 466 |
223063 | 223063 | 2020-06-09 | St. Louis | Missouri | 29189 | 5345 | 480 |
226162 | 226162 | 2020-06-10 | St. Louis | Missouri | 29189 | 5388 | 485 |
229265 | 229265 | 2020-06-11 | St. Louis | Missouri | 29189 | 5440 | 496 |
232369 | 232369 | 2020-06-12 | St. Louis | Missouri | 29189 | 5460 | 499 |
235475 | 235475 | 2020-06-13 | St. Louis | Missouri | 29189 | 5506 | 500 |
238582 | 238582 | 2020-06-14 | St. Louis | Missouri | 29189 | 5536 | 500 |
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);