ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 29005 and state = "Missouri" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
14929 | 14929 | 2020-03-27 | Atchison | Missouri | 29005 | 1 | 0 |
16753 | 16753 | 2020-03-28 | Atchison | Missouri | 29005 | 1 | 0 |
18675 | 18675 | 2020-03-29 | Atchison | Missouri | 29005 | 1 | 0 |
20699 | 20699 | 2020-03-30 | Atchison | Missouri | 29005 | 1 | 0 |
22817 | 22817 | 2020-03-31 | Atchison | Missouri | 29005 | 1 | 0 |
25001 | 25001 | 2020-04-01 | Atchison | Missouri | 29005 | 1 | 0 |
27256 | 27256 | 2020-04-02 | Atchison | Missouri | 29005 | 1 | 0 |
29575 | 29575 | 2020-04-03 | Atchison | Missouri | 29005 | 1 | 0 |
31955 | 31955 | 2020-04-04 | Atchison | Missouri | 29005 | 1 | 0 |
34383 | 34383 | 2020-04-05 | Atchison | Missouri | 29005 | 1 | 0 |
36846 | 36846 | 2020-04-06 | Atchison | Missouri | 29005 | 1 | 0 |
39357 | 39357 | 2020-04-07 | Atchison | Missouri | 29005 | 1 | 0 |
41911 | 41911 | 2020-04-08 | Atchison | Missouri | 29005 | 1 | 0 |
44488 | 44488 | 2020-04-09 | Atchison | Missouri | 29005 | 1 | 0 |
47097 | 47097 | 2020-04-10 | Atchison | Missouri | 29005 | 1 | 0 |
49744 | 49744 | 2020-04-11 | Atchison | Missouri | 29005 | 1 | 0 |
52417 | 52417 | 2020-04-12 | Atchison | Missouri | 29005 | 1 | 0 |
55099 | 55099 | 2020-04-13 | Atchison | Missouri | 29005 | 1 | 0 |
57797 | 57797 | 2020-04-14 | Atchison | Missouri | 29005 | 2 | 0 |
60508 | 60508 | 2020-04-15 | Atchison | Missouri | 29005 | 2 | 0 |
63230 | 63230 | 2020-04-16 | Atchison | Missouri | 29005 | 2 | 0 |
65970 | 65970 | 2020-04-17 | Atchison | Missouri | 29005 | 2 | 0 |
68722 | 68722 | 2020-04-18 | Atchison | Missouri | 29005 | 2 | 0 |
71488 | 71488 | 2020-04-19 | Atchison | Missouri | 29005 | 2 | 0 |
74261 | 74261 | 2020-04-20 | Atchison | Missouri | 29005 | 2 | 0 |
77042 | 77042 | 2020-04-21 | Atchison | Missouri | 29005 | 2 | 0 |
79827 | 79827 | 2020-04-22 | Atchison | Missouri | 29005 | 2 | 0 |
82623 | 82623 | 2020-04-23 | Atchison | Missouri | 29005 | 2 | 0 |
85427 | 85427 | 2020-04-24 | Atchison | Missouri | 29005 | 2 | 0 |
88237 | 88237 | 2020-04-25 | Atchison | Missouri | 29005 | 2 | 0 |
91053 | 91053 | 2020-04-26 | Atchison | Missouri | 29005 | 2 | 0 |
93874 | 93874 | 2020-04-27 | Atchison | Missouri | 29005 | 2 | 0 |
96710 | 96710 | 2020-04-28 | Atchison | Missouri | 29005 | 2 | 0 |
99556 | 99556 | 2020-04-29 | Atchison | Missouri | 29005 | 2 | 0 |
102408 | 102408 | 2020-04-30 | Atchison | Missouri | 29005 | 2 | 0 |
105269 | 105269 | 2020-05-01 | Atchison | Missouri | 29005 | 2 | 0 |
108134 | 108134 | 2020-05-02 | Atchison | Missouri | 29005 | 2 | 0 |
111005 | 111005 | 2020-05-03 | Atchison | Missouri | 29005 | 2 | 0 |
113884 | 113884 | 2020-05-04 | Atchison | Missouri | 29005 | 2 | 0 |
116766 | 116766 | 2020-05-05 | Atchison | Missouri | 29005 | 2 | 0 |
119726 | 119726 | 2020-05-06 | Atchison | Missouri | 29005 | 2 | 0 |
122700 | 122700 | 2020-05-07 | Atchison | Missouri | 29005 | 2 | 0 |
125682 | 125682 | 2020-05-08 | Atchison | Missouri | 29005 | 2 | 0 |
128669 | 128669 | 2020-05-09 | Atchison | Missouri | 29005 | 2 | 0 |
131659 | 131659 | 2020-05-10 | Atchison | Missouri | 29005 | 2 | 0 |
134650 | 134650 | 2020-05-11 | Atchison | Missouri | 29005 | 2 | 0 |
137640 | 137640 | 2020-05-12 | Atchison | Missouri | 29005 | 2 | 0 |
140634 | 140634 | 2020-05-13 | Atchison | Missouri | 29005 | 2 | 0 |
143629 | 143629 | 2020-05-14 | Atchison | Missouri | 29005 | 2 | 0 |
146629 | 146629 | 2020-05-15 | Atchison | Missouri | 29005 | 2 | 0 |
149634 | 149634 | 2020-05-16 | Atchison | Missouri | 29005 | 2 | 0 |
152645 | 152645 | 2020-05-17 | Atchison | Missouri | 29005 | 2 | 0 |
155659 | 155659 | 2020-05-18 | Atchison | Missouri | 29005 | 2 | 0 |
158677 | 158677 | 2020-05-19 | Atchison | Missouri | 29005 | 2 | 0 |
161703 | 161703 | 2020-05-20 | Atchison | Missouri | 29005 | 3 | 0 |
164732 | 164732 | 2020-05-21 | Atchison | Missouri | 29005 | 3 | 0 |
167768 | 167768 | 2020-05-22 | Atchison | Missouri | 29005 | 3 | 0 |
170806 | 170806 | 2020-05-23 | Atchison | Missouri | 29005 | 3 | 0 |
173848 | 173848 | 2020-05-24 | Atchison | Missouri | 29005 | 3 | 0 |
176891 | 176891 | 2020-05-25 | Atchison | Missouri | 29005 | 3 | 0 |
179935 | 179935 | 2020-05-26 | Atchison | Missouri | 29005 | 3 | 0 |
182981 | 182981 | 2020-05-27 | Atchison | Missouri | 29005 | 3 | 0 |
186037 | 186037 | 2020-05-28 | Atchison | Missouri | 29005 | 3 | 0 |
189095 | 189095 | 2020-05-29 | Atchison | Missouri | 29005 | 3 | 0 |
192159 | 192159 | 2020-05-30 | Atchison | Missouri | 29005 | 3 | 0 |
195227 | 195227 | 2020-05-31 | Atchison | Missouri | 29005 | 3 | 0 |
198298 | 198298 | 2020-06-01 | Atchison | Missouri | 29005 | 3 | 0 |
201371 | 201371 | 2020-06-02 | Atchison | Missouri | 29005 | 3 | 0 |
204448 | 204448 | 2020-06-03 | Atchison | Missouri | 29005 | 3 | 0 |
207529 | 207529 | 2020-06-04 | Atchison | Missouri | 29005 | 3 | 0 |
210610 | 210610 | 2020-06-05 | Atchison | Missouri | 29005 | 3 | 0 |
213694 | 213694 | 2020-06-06 | Atchison | Missouri | 29005 | 3 | 0 |
216782 | 216782 | 2020-06-07 | Atchison | Missouri | 29005 | 3 | 0 |
219874 | 219874 | 2020-06-08 | Atchison | Missouri | 29005 | 3 | 0 |
222969 | 222969 | 2020-06-09 | Atchison | Missouri | 29005 | 3 | 0 |
226067 | 226067 | 2020-06-10 | Atchison | Missouri | 29005 | 3 | 0 |
229169 | 229169 | 2020-06-11 | Atchison | Missouri | 29005 | 3 | 0 |
232273 | 232273 | 2020-06-12 | Atchison | Missouri | 29005 | 3 | 0 |
235379 | 235379 | 2020-06-13 | Atchison | Missouri | 29005 | 3 | 0 |
238486 | 238486 | 2020-06-14 | Atchison | Missouri | 29005 | 3 | 0 |
241595 | 241595 | 2020-06-15 | Atchison | Missouri | 29005 | 3 | 0 |
244706 | 244706 | 2020-06-16 | Atchison | Missouri | 29005 | 3 | 0 |
247819 | 247819 | 2020-06-17 | Atchison | Missouri | 29005 | 3 | 0 |
250932 | 250932 | 2020-06-18 | Atchison | Missouri | 29005 | 3 | 0 |
254047 | 254047 | 2020-06-19 | Atchison | Missouri | 29005 | 3 | 0 |
257167 | 257167 | 2020-06-20 | Atchison | Missouri | 29005 | 3 | 0 |
260293 | 260293 | 2020-06-21 | Atchison | Missouri | 29005 | 3 | 0 |
263421 | 263421 | 2020-06-22 | Atchison | Missouri | 29005 | 3 | 0 |
266547 | 266547 | 2020-06-23 | Atchison | Missouri | 29005 | 3 | 0 |
269680 | 269680 | 2020-06-24 | Atchison | Missouri | 29005 | 3 | 0 |
272818 | 272818 | 2020-06-25 | Atchison | Missouri | 29005 | 3 | 0 |
275961 | 275961 | 2020-06-26 | Atchison | Missouri | 29005 | 3 | 0 |
279109 | 279109 | 2020-06-27 | Atchison | Missouri | 29005 | 3 | 0 |
282257 | 282257 | 2020-06-28 | Atchison | Missouri | 29005 | 3 | 0 |
285402 | 285402 | 2020-06-29 | Atchison | Missouri | 29005 | 3 | 0 |
288552 | 288552 | 2020-06-30 | Atchison | Missouri | 29005 | 3 | 0 |
291703 | 291703 | 2020-07-01 | Atchison | Missouri | 29005 | 3 | 0 |
294857 | 294857 | 2020-07-02 | Atchison | Missouri | 29005 | 4 | 0 |
298015 | 298015 | 2020-07-03 | Atchison | Missouri | 29005 | 4 | 0 |
301178 | 301178 | 2020-07-04 | Atchison | Missouri | 29005 | 5 | 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);