ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 29069 and state = "Missouri" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5638 | 5638 | 2020-03-20 | Dunklin | Missouri | 29069 | 1 | 0 |
6626 | 6626 | 2020-03-21 | Dunklin | Missouri | 29069 | 1 | 0 |
7715 | 7715 | 2020-03-22 | Dunklin | Missouri | 29069 | 1 | 0 |
8903 | 8903 | 2020-03-23 | Dunklin | Missouri | 29069 | 1 | 0 |
10202 | 10202 | 2020-03-24 | Dunklin | Missouri | 29069 | 1 | 0 |
11624 | 11624 | 2020-03-25 | Dunklin | Missouri | 29069 | 1 | 0 |
13222 | 13222 | 2020-03-26 | Dunklin | Missouri | 29069 | 2 | 0 |
14947 | 14947 | 2020-03-27 | Dunklin | Missouri | 29069 | 3 | 0 |
16771 | 16771 | 2020-03-28 | Dunklin | Missouri | 29069 | 3 | 0 |
18693 | 18693 | 2020-03-29 | Dunklin | Missouri | 29069 | 3 | 0 |
20719 | 20719 | 2020-03-30 | Dunklin | Missouri | 29069 | 6 | 0 |
22837 | 22837 | 2020-03-31 | Dunklin | Missouri | 29069 | 5 | 0 |
25024 | 25024 | 2020-04-01 | Dunklin | Missouri | 29069 | 5 | 0 |
27279 | 27279 | 2020-04-02 | Dunklin | Missouri | 29069 | 6 | 0 |
29599 | 29599 | 2020-04-03 | Dunklin | Missouri | 29069 | 7 | 0 |
31979 | 31979 | 2020-04-04 | Dunklin | Missouri | 29069 | 7 | 0 |
34407 | 34407 | 2020-04-05 | Dunklin | Missouri | 29069 | 7 | 0 |
36870 | 36870 | 2020-04-06 | Dunklin | Missouri | 29069 | 8 | 0 |
39382 | 39382 | 2020-04-07 | Dunklin | Missouri | 29069 | 8 | 0 |
41936 | 41936 | 2020-04-08 | Dunklin | Missouri | 29069 | 9 | 0 |
44513 | 44513 | 2020-04-09 | Dunklin | Missouri | 29069 | 10 | 0 |
47122 | 47122 | 2020-04-10 | Dunklin | Missouri | 29069 | 12 | 0 |
49769 | 49769 | 2020-04-11 | Dunklin | Missouri | 29069 | 13 | 0 |
52442 | 52442 | 2020-04-12 | Dunklin | Missouri | 29069 | 14 | 0 |
55124 | 55124 | 2020-04-13 | Dunklin | Missouri | 29069 | 16 | 0 |
57822 | 57822 | 2020-04-14 | Dunklin | Missouri | 29069 | 16 | 0 |
60534 | 60534 | 2020-04-15 | Dunklin | Missouri | 29069 | 18 | 1 |
63256 | 63256 | 2020-04-16 | Dunklin | Missouri | 29069 | 18 | 1 |
65996 | 65996 | 2020-04-17 | Dunklin | Missouri | 29069 | 18 | 2 |
68748 | 68748 | 2020-04-18 | Dunklin | Missouri | 29069 | 19 | 2 |
71515 | 71515 | 2020-04-19 | Dunklin | Missouri | 29069 | 19 | 2 |
74288 | 74288 | 2020-04-20 | Dunklin | Missouri | 29069 | 19 | 2 |
77069 | 77069 | 2020-04-21 | Dunklin | Missouri | 29069 | 18 | 2 |
79855 | 79855 | 2020-04-22 | Dunklin | Missouri | 29069 | 19 | 2 |
82651 | 82651 | 2020-04-23 | Dunklin | Missouri | 29069 | 19 | 2 |
85455 | 85455 | 2020-04-24 | Dunklin | Missouri | 29069 | 19 | 2 |
88265 | 88265 | 2020-04-25 | Dunklin | Missouri | 29069 | 19 | 2 |
91081 | 91081 | 2020-04-26 | Dunklin | Missouri | 29069 | 20 | 2 |
93902 | 93902 | 2020-04-27 | Dunklin | Missouri | 29069 | 20 | 2 |
96738 | 96738 | 2020-04-28 | Dunklin | Missouri | 29069 | 20 | 2 |
99584 | 99584 | 2020-04-29 | Dunklin | Missouri | 29069 | 20 | 2 |
102436 | 102436 | 2020-04-30 | Dunklin | Missouri | 29069 | 20 | 2 |
105297 | 105297 | 2020-05-01 | Dunklin | Missouri | 29069 | 21 | 2 |
108162 | 108162 | 2020-05-02 | Dunklin | Missouri | 29069 | 22 | 2 |
111033 | 111033 | 2020-05-03 | Dunklin | Missouri | 29069 | 23 | 2 |
113912 | 113912 | 2020-05-04 | Dunklin | Missouri | 29069 | 23 | 2 |
116794 | 116794 | 2020-05-05 | Dunklin | Missouri | 29069 | 24 | 2 |
119754 | 119754 | 2020-05-06 | Dunklin | Missouri | 29069 | 23 | 2 |
122728 | 122728 | 2020-05-07 | Dunklin | Missouri | 29069 | 23 | 2 |
125710 | 125710 | 2020-05-08 | Dunklin | Missouri | 29069 | 24 | 2 |
128697 | 128697 | 2020-05-09 | Dunklin | Missouri | 29069 | 24 | 2 |
131687 | 131687 | 2020-05-10 | Dunklin | Missouri | 29069 | 24 | 2 |
134678 | 134678 | 2020-05-11 | Dunklin | Missouri | 29069 | 24 | 2 |
137668 | 137668 | 2020-05-12 | Dunklin | Missouri | 29069 | 24 | 2 |
140662 | 140662 | 2020-05-13 | Dunklin | Missouri | 29069 | 24 | 2 |
143657 | 143657 | 2020-05-14 | Dunklin | Missouri | 29069 | 24 | 2 |
146658 | 146658 | 2020-05-15 | Dunklin | Missouri | 29069 | 24 | 2 |
149663 | 149663 | 2020-05-16 | Dunklin | Missouri | 29069 | 25 | 2 |
152674 | 152674 | 2020-05-17 | Dunklin | Missouri | 29069 | 25 | 2 |
155688 | 155688 | 2020-05-18 | Dunklin | Missouri | 29069 | 26 | 2 |
158706 | 158706 | 2020-05-19 | Dunklin | Missouri | 29069 | 26 | 2 |
161732 | 161732 | 2020-05-20 | Dunklin | Missouri | 29069 | 26 | 2 |
164761 | 164761 | 2020-05-21 | Dunklin | Missouri | 29069 | 25 | 2 |
167797 | 167797 | 2020-05-22 | Dunklin | Missouri | 29069 | 25 | 2 |
170835 | 170835 | 2020-05-23 | Dunklin | Missouri | 29069 | 28 | 2 |
173877 | 173877 | 2020-05-24 | Dunklin | Missouri | 29069 | 28 | 2 |
176920 | 176920 | 2020-05-25 | Dunklin | Missouri | 29069 | 30 | 2 |
179964 | 179964 | 2020-05-26 | Dunklin | Missouri | 29069 | 30 | 2 |
183010 | 183010 | 2020-05-27 | Dunklin | Missouri | 29069 | 31 | 2 |
186066 | 186066 | 2020-05-28 | Dunklin | Missouri | 29069 | 32 | 2 |
189124 | 189124 | 2020-05-29 | Dunklin | Missouri | 29069 | 33 | 2 |
192188 | 192188 | 2020-05-30 | Dunklin | Missouri | 29069 | 38 | 2 |
195257 | 195257 | 2020-05-31 | Dunklin | Missouri | 29069 | 38 | 2 |
198328 | 198328 | 2020-06-01 | Dunklin | Missouri | 29069 | 45 | 2 |
201401 | 201401 | 2020-06-02 | Dunklin | Missouri | 29069 | 45 | 2 |
204478 | 204478 | 2020-06-03 | Dunklin | Missouri | 29069 | 44 | 2 |
207559 | 207559 | 2020-06-04 | Dunklin | Missouri | 29069 | 44 | 2 |
210640 | 210640 | 2020-06-05 | Dunklin | Missouri | 29069 | 48 | 2 |
213724 | 213724 | 2020-06-06 | Dunklin | Missouri | 29069 | 48 | 2 |
216812 | 216812 | 2020-06-07 | Dunklin | Missouri | 29069 | 49 | 2 |
219904 | 219904 | 2020-06-08 | Dunklin | Missouri | 29069 | 49 | 2 |
222999 | 222999 | 2020-06-09 | Dunklin | Missouri | 29069 | 48 | 2 |
226097 | 226097 | 2020-06-10 | Dunklin | Missouri | 29069 | 51 | 3 |
229200 | 229200 | 2020-06-11 | Dunklin | Missouri | 29069 | 54 | 3 |
232304 | 232304 | 2020-06-12 | Dunklin | Missouri | 29069 | 54 | 3 |
235410 | 235410 | 2020-06-13 | Dunklin | Missouri | 29069 | 55 | 3 |
238517 | 238517 | 2020-06-14 | Dunklin | Missouri | 29069 | 55 | 3 |
241627 | 241627 | 2020-06-15 | Dunklin | Missouri | 29069 | 61 | 3 |
244738 | 244738 | 2020-06-16 | Dunklin | Missouri | 29069 | 64 | 3 |
247851 | 247851 | 2020-06-17 | Dunklin | Missouri | 29069 | 64 | 3 |
250964 | 250964 | 2020-06-18 | Dunklin | Missouri | 29069 | 65 | 3 |
254079 | 254079 | 2020-06-19 | Dunklin | Missouri | 29069 | 66 | 3 |
257199 | 257199 | 2020-06-20 | Dunklin | Missouri | 29069 | 79 | 3 |
260325 | 260325 | 2020-06-21 | Dunklin | Missouri | 29069 | 79 | 3 |
263453 | 263453 | 2020-06-22 | Dunklin | Missouri | 29069 | 79 | 3 |
266579 | 266579 | 2020-06-23 | Dunklin | Missouri | 29069 | 81 | 3 |
269712 | 269712 | 2020-06-24 | Dunklin | Missouri | 29069 | 82 | 3 |
272850 | 272850 | 2020-06-25 | Dunklin | Missouri | 29069 | 84 | 3 |
275993 | 275993 | 2020-06-26 | Dunklin | Missouri | 29069 | 92 | 3 |
279141 | 279141 | 2020-06-27 | Dunklin | Missouri | 29069 | 92 | 3 |
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);