ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,419 rows where county = "Prairie" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
28531 | 28531 | 2020-04-03 | Prairie | Arkansas | 5117 | 1 | 0 |
30889 | 30889 | 2020-04-04 | Prairie | Arkansas | 5117 | 1 | 0 |
33294 | 33294 | 2020-04-05 | Prairie | Arkansas | 5117 | 2 | 0 |
35738 | 35738 | 2020-04-06 | Prairie | Arkansas | 5117 | 2 | 0 |
38227 | 38227 | 2020-04-07 | Prairie | Arkansas | 5117 | 2 | 0 |
40771 | 40771 | 2020-04-08 | Prairie | Arkansas | 5117 | 2 | 0 |
43343 | 43343 | 2020-04-09 | Prairie | Arkansas | 5117 | 2 | 0 |
45943 | 45943 | 2020-04-10 | Prairie | Arkansas | 5117 | 2 | 0 |
48573 | 48573 | 2020-04-11 | Prairie | Arkansas | 5117 | 2 | 0 |
51235 | 51235 | 2020-04-12 | Prairie | Arkansas | 5117 | 2 | 0 |
53914 | 53914 | 2020-04-13 | Prairie | Arkansas | 5117 | 2 | 0 |
56606 | 56606 | 2020-04-14 | Prairie | Arkansas | 5117 | 2 | 0 |
59314 | 59314 | 2020-04-15 | Prairie | Arkansas | 5117 | 2 | 0 |
62033 | 62033 | 2020-04-16 | Prairie | Arkansas | 5117 | 2 | 0 |
64766 | 64766 | 2020-04-17 | Prairie | Arkansas | 5117 | 2 | 0 |
67514 | 67514 | 2020-04-18 | Prairie | Arkansas | 5117 | 2 | 0 |
70276 | 70276 | 2020-04-19 | Prairie | Arkansas | 5117 | 2 | 0 |
73045 | 73045 | 2020-04-20 | Prairie | Arkansas | 5117 | 2 | 0 |
75821 | 75821 | 2020-04-21 | Prairie | Arkansas | 5117 | 2 | 0 |
78605 | 78605 | 2020-04-22 | Prairie | Arkansas | 5117 | 2 | 0 |
81399 | 81399 | 2020-04-23 | Prairie | Arkansas | 5117 | 2 | 0 |
84199 | 84199 | 2020-04-24 | Prairie | Arkansas | 5117 | 2 | 0 |
87007 | 87007 | 2020-04-25 | Prairie | Arkansas | 5117 | 2 | 0 |
89824 | 89824 | 2020-04-26 | Prairie | Arkansas | 5117 | 2 | 0 |
92642 | 92642 | 2020-04-27 | Prairie | Arkansas | 5117 | 2 | 0 |
95473 | 95473 | 2020-04-28 | Prairie | Arkansas | 5117 | 2 | 0 |
98318 | 98318 | 2020-04-29 | Prairie | Arkansas | 5117 | 2 | 0 |
101168 | 101168 | 2020-04-30 | Prairie | Arkansas | 5117 | 2 | 0 |
104023 | 104023 | 2020-05-01 | Prairie | Arkansas | 5117 | 2 | 0 |
106888 | 106888 | 2020-05-02 | Prairie | Arkansas | 5117 | 2 | 0 |
109757 | 109757 | 2020-05-03 | Prairie | Arkansas | 5117 | 2 | 0 |
112632 | 112632 | 2020-05-04 | Prairie | Arkansas | 5117 | 2 | 0 |
115515 | 115515 | 2020-05-05 | Prairie | Arkansas | 5117 | 2 | 0 |
118474 | 118474 | 2020-05-06 | Prairie | Arkansas | 5117 | 2 | 0 |
121441 | 121441 | 2020-05-07 | Prairie | Arkansas | 5117 | 2 | 0 |
124421 | 124421 | 2020-05-08 | Prairie | Arkansas | 5117 | 2 | 0 |
127406 | 127406 | 2020-05-09 | Prairie | Arkansas | 5117 | 2 | 0 |
130396 | 130396 | 2020-05-10 | Prairie | Arkansas | 5117 | 2 | 0 |
133386 | 133386 | 2020-05-11 | Prairie | Arkansas | 5117 | 2 | 0 |
136376 | 136376 | 2020-05-12 | Prairie | Arkansas | 5117 | 2 | 0 |
139367 | 139367 | 2020-05-13 | Prairie | Arkansas | 5117 | 2 | 0 |
142363 | 142363 | 2020-05-14 | Prairie | Arkansas | 5117 | 2 | 0 |
145362 | 145362 | 2020-05-15 | Prairie | Arkansas | 5117 | 2 | 0 |
148366 | 148366 | 2020-05-16 | Prairie | Arkansas | 5117 | 2 | 0 |
151375 | 151375 | 2020-05-17 | Prairie | Arkansas | 5117 | 2 | 0 |
154387 | 154387 | 2020-05-18 | Prairie | Arkansas | 5117 | 2 | 0 |
157403 | 157403 | 2020-05-19 | Prairie | Arkansas | 5117 | 2 | 0 |
160429 | 160429 | 2020-05-20 | Prairie | Arkansas | 5117 | 2 | 0 |
163457 | 163457 | 2020-05-21 | Prairie | Arkansas | 5117 | 2 | 0 |
166489 | 166489 | 2020-05-22 | Prairie | Arkansas | 5117 | 2 | 0 |
169525 | 169525 | 2020-05-23 | Prairie | Arkansas | 5117 | 2 | 0 |
172566 | 172566 | 2020-05-24 | Prairie | Arkansas | 5117 | 2 | 0 |
175610 | 175610 | 2020-05-25 | Prairie | Arkansas | 5117 | 2 | 0 |
178654 | 178654 | 2020-05-26 | Prairie | Arkansas | 5117 | 2 | 0 |
181698 | 181698 | 2020-05-27 | Prairie | Arkansas | 5117 | 2 | 0 |
184752 | 184752 | 2020-05-28 | Prairie | Arkansas | 5117 | 2 | 0 |
187808 | 187808 | 2020-05-29 | Prairie | Arkansas | 5117 | 2 | 0 |
190873 | 190873 | 2020-05-30 | Prairie | Arkansas | 5117 | 2 | 0 |
193940 | 193940 | 2020-05-31 | Prairie | Arkansas | 5117 | 2 | 0 |
197010 | 197010 | 2020-06-01 | Prairie | Arkansas | 5117 | 2 | 0 |
200083 | 200083 | 2020-06-02 | Prairie | Arkansas | 5117 | 3 | 0 |
203159 | 203159 | 2020-06-03 | Prairie | Arkansas | 5117 | 3 | 0 |
206239 | 206239 | 2020-06-04 | Prairie | Arkansas | 5117 | 3 | 0 |
209320 | 209320 | 2020-06-05 | Prairie | Arkansas | 5117 | 3 | 0 |
212405 | 212405 | 2020-06-06 | Prairie | Arkansas | 5117 | 4 | 0 |
215492 | 215492 | 2020-06-07 | Prairie | Arkansas | 5117 | 5 | 0 |
218583 | 218583 | 2020-06-08 | Prairie | Arkansas | 5117 | 5 | 0 |
221678 | 221678 | 2020-06-09 | Prairie | Arkansas | 5117 | 5 | 0 |
224773 | 224773 | 2020-06-10 | Prairie | Arkansas | 5117 | 5 | 0 |
227875 | 227875 | 2020-06-11 | Prairie | Arkansas | 5117 | 5 | 0 |
230978 | 230978 | 2020-06-12 | Prairie | Arkansas | 5117 | 6 | 0 |
234084 | 234084 | 2020-06-13 | Prairie | Arkansas | 5117 | 7 | 0 |
237191 | 237191 | 2020-06-14 | Prairie | Arkansas | 5117 | 7 | 0 |
240299 | 240299 | 2020-06-15 | Prairie | Arkansas | 5117 | 7 | 0 |
243410 | 243410 | 2020-06-16 | Prairie | Arkansas | 5117 | 9 | 0 |
246523 | 246523 | 2020-06-17 | Prairie | Arkansas | 5117 | 12 | 0 |
249635 | 249635 | 2020-06-18 | Prairie | Arkansas | 5117 | 12 | 0 |
252750 | 252750 | 2020-06-19 | Prairie | Arkansas | 5117 | 12 | 0 |
255869 | 255869 | 2020-06-20 | Prairie | Arkansas | 5117 | 12 | 0 |
258996 | 258996 | 2020-06-21 | Prairie | Arkansas | 5117 | 13 | 0 |
262123 | 262123 | 2020-06-22 | Prairie | Arkansas | 5117 | 16 | 0 |
265251 | 265251 | 2020-06-23 | Prairie | Arkansas | 5117 | 16 | 0 |
268381 | 268381 | 2020-06-24 | Prairie | Arkansas | 5117 | 18 | 0 |
271516 | 271516 | 2020-06-25 | Prairie | Arkansas | 5117 | 19 | 0 |
274656 | 274656 | 2020-06-26 | Prairie | Arkansas | 5117 | 19 | 0 |
277804 | 277804 | 2020-06-27 | Prairie | Arkansas | 5117 | 20 | 0 |
280951 | 280951 | 2020-06-28 | Prairie | Arkansas | 5117 | 20 | 0 |
284097 | 284097 | 2020-06-29 | Prairie | Arkansas | 5117 | 20 | 0 |
287243 | 287243 | 2020-06-30 | Prairie | Arkansas | 5117 | 20 | 0 |
290394 | 290394 | 2020-07-01 | Prairie | Arkansas | 5117 | 21 | 0 |
293548 | 293548 | 2020-07-02 | Prairie | Arkansas | 5117 | 21 | 0 |
296704 | 296704 | 2020-07-03 | Prairie | Arkansas | 5117 | 21 | 0 |
299866 | 299866 | 2020-07-04 | Prairie | Arkansas | 5117 | 21 | 0 |
303030 | 303030 | 2020-07-05 | Prairie | Arkansas | 5117 | 22 | 0 |
306194 | 306194 | 2020-07-06 | Prairie | Arkansas | 5117 | 22 | 0 |
309362 | 309362 | 2020-07-07 | Prairie | Arkansas | 5117 | 22 | 0 |
312532 | 312532 | 2020-07-08 | Prairie | Arkansas | 5117 | 25 | 0 |
315707 | 315707 | 2020-07-09 | Prairie | Arkansas | 5117 | 26 | 0 |
318880 | 318880 | 2020-07-10 | Prairie | Arkansas | 5117 | 28 | 0 |
322059 | 322059 | 2020-07-11 | Prairie | Arkansas | 5117 | 28 | 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);