ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "DeKalb" and state = "Missouri" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
25023 | 25023 | 2020-04-01 | DeKalb | Missouri | 29063 | 1 | 0 |
27278 | 27278 | 2020-04-02 | DeKalb | Missouri | 29063 | 1 | 0 |
29598 | 29598 | 2020-04-03 | DeKalb | Missouri | 29063 | 1 | 0 |
31978 | 31978 | 2020-04-04 | DeKalb | Missouri | 29063 | 1 | 0 |
34406 | 34406 | 2020-04-05 | DeKalb | Missouri | 29063 | 1 | 0 |
36869 | 36869 | 2020-04-06 | DeKalb | Missouri | 29063 | 1 | 0 |
39381 | 39381 | 2020-04-07 | DeKalb | Missouri | 29063 | 1 | 0 |
41935 | 41935 | 2020-04-08 | DeKalb | Missouri | 29063 | 2 | 0 |
44512 | 44512 | 2020-04-09 | DeKalb | Missouri | 29063 | 3 | 0 |
47121 | 47121 | 2020-04-10 | DeKalb | Missouri | 29063 | 3 | 0 |
49768 | 49768 | 2020-04-11 | DeKalb | Missouri | 29063 | 3 | 0 |
52441 | 52441 | 2020-04-12 | DeKalb | Missouri | 29063 | 3 | 0 |
55123 | 55123 | 2020-04-13 | DeKalb | Missouri | 29063 | 3 | 0 |
57821 | 57821 | 2020-04-14 | DeKalb | Missouri | 29063 | 3 | 0 |
60533 | 60533 | 2020-04-15 | DeKalb | Missouri | 29063 | 3 | 0 |
63255 | 63255 | 2020-04-16 | DeKalb | Missouri | 29063 | 3 | 0 |
65995 | 65995 | 2020-04-17 | DeKalb | Missouri | 29063 | 3 | 0 |
68747 | 68747 | 2020-04-18 | DeKalb | Missouri | 29063 | 3 | 0 |
71514 | 71514 | 2020-04-19 | DeKalb | Missouri | 29063 | 3 | 0 |
74287 | 74287 | 2020-04-20 | DeKalb | Missouri | 29063 | 3 | 0 |
77068 | 77068 | 2020-04-21 | DeKalb | Missouri | 29063 | 3 | 0 |
79854 | 79854 | 2020-04-22 | DeKalb | Missouri | 29063 | 3 | 0 |
82650 | 82650 | 2020-04-23 | DeKalb | Missouri | 29063 | 3 | 0 |
85454 | 85454 | 2020-04-24 | DeKalb | Missouri | 29063 | 3 | 0 |
88264 | 88264 | 2020-04-25 | DeKalb | Missouri | 29063 | 3 | 0 |
91080 | 91080 | 2020-04-26 | DeKalb | Missouri | 29063 | 3 | 0 |
93901 | 93901 | 2020-04-27 | DeKalb | Missouri | 29063 | 3 | 0 |
96737 | 96737 | 2020-04-28 | DeKalb | Missouri | 29063 | 3 | 0 |
99583 | 99583 | 2020-04-29 | DeKalb | Missouri | 29063 | 3 | 0 |
102435 | 102435 | 2020-04-30 | DeKalb | Missouri | 29063 | 3 | 0 |
105296 | 105296 | 2020-05-01 | DeKalb | Missouri | 29063 | 3 | 0 |
108161 | 108161 | 2020-05-02 | DeKalb | Missouri | 29063 | 3 | 0 |
111032 | 111032 | 2020-05-03 | DeKalb | Missouri | 29063 | 3 | 0 |
113911 | 113911 | 2020-05-04 | DeKalb | Missouri | 29063 | 3 | 0 |
116793 | 116793 | 2020-05-05 | DeKalb | Missouri | 29063 | 3 | 0 |
119753 | 119753 | 2020-05-06 | DeKalb | Missouri | 29063 | 3 | 0 |
122727 | 122727 | 2020-05-07 | DeKalb | Missouri | 29063 | 3 | 0 |
125709 | 125709 | 2020-05-08 | DeKalb | Missouri | 29063 | 4 | 0 |
128696 | 128696 | 2020-05-09 | DeKalb | Missouri | 29063 | 3 | 0 |
131686 | 131686 | 2020-05-10 | DeKalb | Missouri | 29063 | 3 | 0 |
134677 | 134677 | 2020-05-11 | DeKalb | Missouri | 29063 | 3 | 0 |
137667 | 137667 | 2020-05-12 | DeKalb | Missouri | 29063 | 4 | 0 |
140661 | 140661 | 2020-05-13 | DeKalb | Missouri | 29063 | 4 | 0 |
143656 | 143656 | 2020-05-14 | DeKalb | Missouri | 29063 | 4 | 0 |
146656 | 146656 | 2020-05-15 | DeKalb | Missouri | 29063 | 4 | 0 |
149661 | 149661 | 2020-05-16 | DeKalb | Missouri | 29063 | 4 | 0 |
152672 | 152672 | 2020-05-17 | DeKalb | Missouri | 29063 | 4 | 0 |
155686 | 155686 | 2020-05-18 | DeKalb | Missouri | 29063 | 4 | 0 |
158704 | 158704 | 2020-05-19 | DeKalb | Missouri | 29063 | 4 | 0 |
161730 | 161730 | 2020-05-20 | DeKalb | Missouri | 29063 | 5 | 0 |
164759 | 164759 | 2020-05-21 | DeKalb | Missouri | 29063 | 5 | 0 |
167795 | 167795 | 2020-05-22 | DeKalb | Missouri | 29063 | 5 | 0 |
170833 | 170833 | 2020-05-23 | DeKalb | Missouri | 29063 | 5 | 0 |
173875 | 173875 | 2020-05-24 | DeKalb | Missouri | 29063 | 5 | 0 |
176918 | 176918 | 2020-05-25 | DeKalb | Missouri | 29063 | 5 | 0 |
179962 | 179962 | 2020-05-26 | DeKalb | Missouri | 29063 | 6 | 0 |
183008 | 183008 | 2020-05-27 | DeKalb | Missouri | 29063 | 6 | 0 |
186064 | 186064 | 2020-05-28 | DeKalb | Missouri | 29063 | 6 | 0 |
189122 | 189122 | 2020-05-29 | DeKalb | Missouri | 29063 | 6 | 0 |
192186 | 192186 | 2020-05-30 | DeKalb | Missouri | 29063 | 6 | 0 |
195254 | 195254 | 2020-05-31 | DeKalb | Missouri | 29063 | 6 | 0 |
198325 | 198325 | 2020-06-01 | DeKalb | Missouri | 29063 | 6 | 0 |
201398 | 201398 | 2020-06-02 | DeKalb | Missouri | 29063 | 6 | 0 |
204475 | 204475 | 2020-06-03 | DeKalb | Missouri | 29063 | 6 | 0 |
207556 | 207556 | 2020-06-04 | DeKalb | Missouri | 29063 | 6 | 0 |
210637 | 210637 | 2020-06-05 | DeKalb | Missouri | 29063 | 6 | 0 |
213721 | 213721 | 2020-06-06 | DeKalb | Missouri | 29063 | 7 | 0 |
216809 | 216809 | 2020-06-07 | DeKalb | Missouri | 29063 | 7 | 0 |
219901 | 219901 | 2020-06-08 | DeKalb | Missouri | 29063 | 7 | 0 |
222996 | 222996 | 2020-06-09 | DeKalb | Missouri | 29063 | 6 | 0 |
226094 | 226094 | 2020-06-10 | DeKalb | Missouri | 29063 | 6 | 0 |
229197 | 229197 | 2020-06-11 | DeKalb | Missouri | 29063 | 6 | 0 |
232301 | 232301 | 2020-06-12 | DeKalb | Missouri | 29063 | 7 | 0 |
235407 | 235407 | 2020-06-13 | DeKalb | Missouri | 29063 | 8 | 0 |
238514 | 238514 | 2020-06-14 | DeKalb | Missouri | 29063 | 8 | 0 |
241624 | 241624 | 2020-06-15 | DeKalb | Missouri | 29063 | 9 | 0 |
244735 | 244735 | 2020-06-16 | DeKalb | Missouri | 29063 | 9 | 0 |
247848 | 247848 | 2020-06-17 | DeKalb | Missouri | 29063 | 9 | 0 |
250961 | 250961 | 2020-06-18 | DeKalb | Missouri | 29063 | 9 | 0 |
254076 | 254076 | 2020-06-19 | DeKalb | Missouri | 29063 | 10 | 0 |
257196 | 257196 | 2020-06-20 | DeKalb | Missouri | 29063 | 10 | 0 |
260322 | 260322 | 2020-06-21 | DeKalb | Missouri | 29063 | 10 | 0 |
263450 | 263450 | 2020-06-22 | DeKalb | Missouri | 29063 | 10 | 0 |
266576 | 266576 | 2020-06-23 | DeKalb | Missouri | 29063 | 10 | 0 |
269709 | 269709 | 2020-06-24 | DeKalb | Missouri | 29063 | 10 | 0 |
272847 | 272847 | 2020-06-25 | DeKalb | Missouri | 29063 | 10 | 0 |
275990 | 275990 | 2020-06-26 | DeKalb | Missouri | 29063 | 10 | 0 |
279138 | 279138 | 2020-06-27 | DeKalb | Missouri | 29063 | 11 | 0 |
282286 | 282286 | 2020-06-28 | DeKalb | Missouri | 29063 | 12 | 0 |
285431 | 285431 | 2020-06-29 | DeKalb | Missouri | 29063 | 12 | 0 |
288581 | 288581 | 2020-06-30 | DeKalb | Missouri | 29063 | 12 | 0 |
291732 | 291732 | 2020-07-01 | DeKalb | Missouri | 29063 | 13 | 0 |
294886 | 294886 | 2020-07-02 | DeKalb | Missouri | 29063 | 13 | 0 |
298044 | 298044 | 2020-07-03 | DeKalb | Missouri | 29063 | 14 | 0 |
301207 | 301207 | 2020-07-04 | DeKalb | Missouri | 29063 | 14 | 0 |
304371 | 304371 | 2020-07-05 | DeKalb | Missouri | 29063 | 14 | 0 |
307538 | 307538 | 2020-07-06 | DeKalb | Missouri | 29063 | 14 | 0 |
310706 | 310706 | 2020-07-07 | DeKalb | Missouri | 29063 | 15 | 0 |
313876 | 313876 | 2020-07-08 | DeKalb | Missouri | 29063 | 15 | 0 |
317050 | 317050 | 2020-07-09 | DeKalb | Missouri | 29063 | 15 | 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);