ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Clay", fips = 29047 and state = "Missouri" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
8900 | 8900 | 2020-03-23 | Clay | Missouri | 29047 | 3 | 0 |
10199 | 10199 | 2020-03-24 | Clay | Missouri | 29047 | 3 | 0 |
11620 | 11620 | 2020-03-25 | Clay | Missouri | 29047 | 5 | 0 |
13218 | 13218 | 2020-03-26 | Clay | Missouri | 29047 | 5 | 0 |
14943 | 14943 | 2020-03-27 | Clay | Missouri | 29047 | 9 | 0 |
16767 | 16767 | 2020-03-28 | Clay | Missouri | 29047 | 10 | 0 |
18689 | 18689 | 2020-03-29 | Clay | Missouri | 29047 | 11 | 0 |
20714 | 20714 | 2020-03-30 | Clay | Missouri | 29047 | 13 | 0 |
22832 | 22832 | 2020-03-31 | Clay | Missouri | 29047 | 16 | 0 |
25018 | 25018 | 2020-04-01 | Clay | Missouri | 29047 | 21 | 0 |
27273 | 27273 | 2020-04-02 | Clay | Missouri | 29047 | 23 | 0 |
29593 | 29593 | 2020-04-03 | Clay | Missouri | 29047 | 26 | 0 |
31973 | 31973 | 2020-04-04 | Clay | Missouri | 29047 | 32 | 0 |
34401 | 34401 | 2020-04-05 | Clay | Missouri | 29047 | 33 | 0 |
36864 | 36864 | 2020-04-06 | Clay | Missouri | 29047 | 37 | 1 |
39375 | 39375 | 2020-04-07 | Clay | Missouri | 29047 | 37 | 1 |
41929 | 41929 | 2020-04-08 | Clay | Missouri | 29047 | 37 | 1 |
44506 | 44506 | 2020-04-09 | Clay | Missouri | 29047 | 38 | 1 |
47115 | 47115 | 2020-04-10 | Clay | Missouri | 29047 | 40 | 1 |
49762 | 49762 | 2020-04-11 | Clay | Missouri | 29047 | 46 | 1 |
52435 | 52435 | 2020-04-12 | Clay | Missouri | 29047 | 48 | 1 |
55117 | 55117 | 2020-04-13 | Clay | Missouri | 29047 | 51 | 1 |
57815 | 57815 | 2020-04-14 | Clay | Missouri | 29047 | 51 | 1 |
60526 | 60526 | 2020-04-15 | Clay | Missouri | 29047 | 52 | 1 |
63248 | 63248 | 2020-04-16 | Clay | Missouri | 29047 | 52 | 1 |
65988 | 65988 | 2020-04-17 | Clay | Missouri | 29047 | 55 | 1 |
68740 | 68740 | 2020-04-18 | Clay | Missouri | 29047 | 56 | 1 |
71507 | 71507 | 2020-04-19 | Clay | Missouri | 29047 | 57 | 1 |
74280 | 74280 | 2020-04-20 | Clay | Missouri | 29047 | 59 | 1 |
77061 | 77061 | 2020-04-21 | Clay | Missouri | 29047 | 61 | 1 |
79847 | 79847 | 2020-04-22 | Clay | Missouri | 29047 | 61 | 1 |
82643 | 82643 | 2020-04-23 | Clay | Missouri | 29047 | 62 | 1 |
85447 | 85447 | 2020-04-24 | Clay | Missouri | 29047 | 63 | 1 |
88257 | 88257 | 2020-04-25 | Clay | Missouri | 29047 | 65 | 1 |
91073 | 91073 | 2020-04-26 | Clay | Missouri | 29047 | 67 | 1 |
93894 | 93894 | 2020-04-27 | Clay | Missouri | 29047 | 68 | 1 |
96730 | 96730 | 2020-04-28 | Clay | Missouri | 29047 | 69 | 1 |
99576 | 99576 | 2020-04-29 | Clay | Missouri | 29047 | 69 | 1 |
102428 | 102428 | 2020-04-30 | Clay | Missouri | 29047 | 70 | 1 |
105289 | 105289 | 2020-05-01 | Clay | Missouri | 29047 | 77 | 1 |
108154 | 108154 | 2020-05-02 | Clay | Missouri | 29047 | 77 | 1 |
111025 | 111025 | 2020-05-03 | Clay | Missouri | 29047 | 77 | 1 |
113904 | 113904 | 2020-05-04 | Clay | Missouri | 29047 | 81 | 1 |
116786 | 116786 | 2020-05-05 | Clay | Missouri | 29047 | 86 | 1 |
119746 | 119746 | 2020-05-06 | Clay | Missouri | 29047 | 88 | 1 |
122720 | 122720 | 2020-05-07 | Clay | Missouri | 29047 | 91 | 1 |
125702 | 125702 | 2020-05-08 | Clay | Missouri | 29047 | 96 | 1 |
128689 | 128689 | 2020-05-09 | Clay | Missouri | 29047 | 96 | 1 |
131679 | 131679 | 2020-05-10 | Clay | Missouri | 29047 | 96 | 1 |
134670 | 134670 | 2020-05-11 | Clay | Missouri | 29047 | 101 | 1 |
137660 | 137660 | 2020-05-12 | Clay | Missouri | 29047 | 102 | 1 |
140654 | 140654 | 2020-05-13 | Clay | Missouri | 29047 | 106 | 1 |
143649 | 143649 | 2020-05-14 | Clay | Missouri | 29047 | 111 | 1 |
146649 | 146649 | 2020-05-15 | Clay | Missouri | 29047 | 113 | 1 |
149654 | 149654 | 2020-05-16 | Clay | Missouri | 29047 | 116 | 1 |
152665 | 152665 | 2020-05-17 | Clay | Missouri | 29047 | 114 | 1 |
155679 | 155679 | 2020-05-18 | Clay | Missouri | 29047 | 120 | 1 |
158697 | 158697 | 2020-05-19 | Clay | Missouri | 29047 | 123 | 1 |
161723 | 161723 | 2020-05-20 | Clay | Missouri | 29047 | 125 | 1 |
164752 | 164752 | 2020-05-21 | Clay | Missouri | 29047 | 127 | 1 |
167788 | 167788 | 2020-05-22 | Clay | Missouri | 29047 | 133 | 1 |
170826 | 170826 | 2020-05-23 | Clay | Missouri | 29047 | 141 | 2 |
173868 | 173868 | 2020-05-24 | Clay | Missouri | 29047 | 149 | 2 |
176911 | 176911 | 2020-05-25 | Clay | Missouri | 29047 | 148 | 2 |
179955 | 179955 | 2020-05-26 | Clay | Missouri | 29047 | 152 | 2 |
183001 | 183001 | 2020-05-27 | Clay | Missouri | 29047 | 158 | 3 |
186057 | 186057 | 2020-05-28 | Clay | Missouri | 29047 | 162 | 3 |
189115 | 189115 | 2020-05-29 | Clay | Missouri | 29047 | 169 | 3 |
192179 | 192179 | 2020-05-30 | Clay | Missouri | 29047 | 171 | 3 |
195247 | 195247 | 2020-05-31 | Clay | Missouri | 29047 | 173 | 3 |
198318 | 198318 | 2020-06-01 | Clay | Missouri | 29047 | 179 | 3 |
201391 | 201391 | 2020-06-02 | Clay | Missouri | 29047 | 184 | 3 |
204468 | 204468 | 2020-06-03 | Clay | Missouri | 29047 | 189 | 3 |
207549 | 207549 | 2020-06-04 | Clay | Missouri | 29047 | 192 | 3 |
210630 | 210630 | 2020-06-05 | Clay | Missouri | 29047 | 228 | 3 |
219894 | 219894 | 2020-06-08 | Clay | Missouri | 29047 | 243 | 3 |
222989 | 222989 | 2020-06-09 | Clay | Missouri | 29047 | 255 | 3 |
226087 | 226087 | 2020-06-10 | Clay | Missouri | 29047 | 263 | 3 |
229190 | 229190 | 2020-06-11 | Clay | Missouri | 29047 | 291 | 3 |
232294 | 232294 | 2020-06-12 | Clay | Missouri | 29047 | 295 | 3 |
235400 | 235400 | 2020-06-13 | Clay | Missouri | 29047 | 295 | 3 |
238507 | 238507 | 2020-06-14 | Clay | Missouri | 29047 | 295 | 3 |
213714 | 213714 | 2020-06-06 | Clay | Missouri | 29047 | 228 | 4 |
216802 | 216802 | 2020-06-07 | Clay | Missouri | 29047 | 233 | 4 |
241616 | 241616 | 2020-06-15 | Clay | Missouri | 29047 | 298 | 6 |
244727 | 244727 | 2020-06-16 | Clay | Missouri | 29047 | 299 | 7 |
247840 | 247840 | 2020-06-17 | Clay | Missouri | 29047 | 305 | 8 |
250953 | 250953 | 2020-06-18 | Clay | Missouri | 29047 | 319 | 8 |
254068 | 254068 | 2020-06-19 | Clay | Missouri | 29047 | 334 | 9 |
257188 | 257188 | 2020-06-20 | Clay | Missouri | 29047 | 342 | 9 |
260314 | 260314 | 2020-06-21 | Clay | Missouri | 29047 | 342 | 9 |
263442 | 263442 | 2020-06-22 | Clay | Missouri | 29047 | 348 | 9 |
266568 | 266568 | 2020-06-23 | Clay | Missouri | 29047 | 367 | 9 |
269701 | 269701 | 2020-06-24 | Clay | Missouri | 29047 | 375 | 11 |
272839 | 272839 | 2020-06-25 | Clay | Missouri | 29047 | 386 | 11 |
275982 | 275982 | 2020-06-26 | Clay | Missouri | 29047 | 406 | 12 |
279130 | 279130 | 2020-06-27 | Clay | Missouri | 29047 | 414 | 12 |
282278 | 282278 | 2020-06-28 | Clay | Missouri | 29047 | 431 | 12 |
285423 | 285423 | 2020-06-29 | Clay | Missouri | 29047 | 443 | 14 |
288573 | 288573 | 2020-06-30 | Clay | Missouri | 29047 | 454 | 16 |
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);