ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 18001 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535124 | 535124 | 2020-09-15 | Adams | Indiana | 18001 | 224 | 4 |
531889 | 531889 | 2020-09-14 | Adams | Indiana | 18001 | 223 | 4 |
528652 | 528652 | 2020-09-13 | Adams | Indiana | 18001 | 221 | 4 |
525416 | 525416 | 2020-09-12 | Adams | Indiana | 18001 | 220 | 4 |
522180 | 522180 | 2020-09-11 | Adams | Indiana | 18001 | 212 | 4 |
518943 | 518943 | 2020-09-10 | Adams | Indiana | 18001 | 211 | 4 |
515708 | 515708 | 2020-09-09 | Adams | Indiana | 18001 | 210 | 4 |
512475 | 512475 | 2020-09-08 | Adams | Indiana | 18001 | 200 | 4 |
509242 | 509242 | 2020-09-07 | Adams | Indiana | 18001 | 196 | 4 |
506010 | 506010 | 2020-09-06 | Adams | Indiana | 18001 | 196 | 4 |
502776 | 502776 | 2020-09-05 | Adams | Indiana | 18001 | 195 | 4 |
499542 | 499542 | 2020-09-04 | Adams | Indiana | 18001 | 193 | 4 |
496309 | 496309 | 2020-09-03 | Adams | Indiana | 18001 | 193 | 3 |
493075 | 493075 | 2020-09-02 | Adams | Indiana | 18001 | 191 | 3 |
489842 | 489842 | 2020-09-01 | Adams | Indiana | 18001 | 191 | 3 |
486609 | 486609 | 2020-08-31 | Adams | Indiana | 18001 | 188 | 3 |
483374 | 483374 | 2020-08-30 | Adams | Indiana | 18001 | 185 | 3 |
480140 | 480140 | 2020-08-29 | Adams | Indiana | 18001 | 182 | 3 |
476907 | 476907 | 2020-08-28 | Adams | Indiana | 18001 | 178 | 3 |
473674 | 473674 | 2020-08-27 | Adams | Indiana | 18001 | 178 | 3 |
470442 | 470442 | 2020-08-26 | Adams | Indiana | 18001 | 165 | 3 |
467213 | 467213 | 2020-08-25 | Adams | Indiana | 18001 | 162 | 3 |
463984 | 463984 | 2020-08-24 | Adams | Indiana | 18001 | 160 | 3 |
460755 | 460755 | 2020-08-23 | Adams | Indiana | 18001 | 158 | 3 |
457528 | 457528 | 2020-08-22 | Adams | Indiana | 18001 | 157 | 3 |
454300 | 454300 | 2020-08-21 | Adams | Indiana | 18001 | 153 | 3 |
451072 | 451072 | 2020-08-20 | Adams | Indiana | 18001 | 149 | 3 |
447844 | 447844 | 2020-08-19 | Adams | Indiana | 18001 | 143 | 3 |
444617 | 444617 | 2020-08-18 | Adams | Indiana | 18001 | 142 | 3 |
441391 | 441391 | 2020-08-17 | Adams | Indiana | 18001 | 140 | 3 |
438165 | 438165 | 2020-08-16 | Adams | Indiana | 18001 | 136 | 3 |
434939 | 434939 | 2020-08-15 | Adams | Indiana | 18001 | 133 | 3 |
431714 | 431714 | 2020-08-14 | Adams | Indiana | 18001 | 125 | 3 |
428486 | 428486 | 2020-08-13 | Adams | Indiana | 18001 | 121 | 3 |
425262 | 425262 | 2020-08-12 | Adams | Indiana | 18001 | 118 | 3 |
422041 | 422041 | 2020-08-11 | Adams | Indiana | 18001 | 110 | 3 |
418818 | 418818 | 2020-08-10 | Adams | Indiana | 18001 | 103 | 3 |
415597 | 415597 | 2020-08-09 | Adams | Indiana | 18001 | 102 | 3 |
412377 | 412377 | 2020-08-08 | Adams | Indiana | 18001 | 97 | 3 |
409158 | 409158 | 2020-08-07 | Adams | Indiana | 18001 | 96 | 3 |
405938 | 405938 | 2020-08-06 | Adams | Indiana | 18001 | 90 | 3 |
402720 | 402720 | 2020-08-05 | Adams | Indiana | 18001 | 85 | 3 |
399504 | 399504 | 2020-08-04 | Adams | Indiana | 18001 | 83 | 3 |
396288 | 396288 | 2020-08-03 | Adams | Indiana | 18001 | 82 | 3 |
393072 | 393072 | 2020-08-02 | Adams | Indiana | 18001 | 82 | 3 |
389855 | 389855 | 2020-08-01 | Adams | Indiana | 18001 | 80 | 3 |
386638 | 386638 | 2020-07-31 | Adams | Indiana | 18001 | 75 | 3 |
383420 | 383420 | 2020-07-30 | Adams | Indiana | 18001 | 74 | 2 |
380203 | 380203 | 2020-07-29 | Adams | Indiana | 18001 | 74 | 2 |
376986 | 376986 | 2020-07-28 | Adams | Indiana | 18001 | 74 | 2 |
373771 | 373771 | 2020-07-27 | Adams | Indiana | 18001 | 72 | 2 |
370559 | 370559 | 2020-07-26 | Adams | Indiana | 18001 | 71 | 2 |
367349 | 367349 | 2020-07-25 | Adams | Indiana | 18001 | 70 | 2 |
364142 | 364142 | 2020-07-24 | Adams | Indiana | 18001 | 70 | 2 |
360935 | 360935 | 2020-07-23 | Adams | Indiana | 18001 | 67 | 2 |
357730 | 357730 | 2020-07-22 | Adams | Indiana | 18001 | 64 | 2 |
354528 | 354528 | 2020-07-21 | Adams | Indiana | 18001 | 59 | 2 |
351326 | 351326 | 2020-07-20 | Adams | Indiana | 18001 | 58 | 2 |
348126 | 348126 | 2020-07-19 | Adams | Indiana | 18001 | 58 | 2 |
344925 | 344925 | 2020-07-18 | Adams | Indiana | 18001 | 56 | 2 |
341725 | 341725 | 2020-07-17 | Adams | Indiana | 18001 | 55 | 2 |
338529 | 338529 | 2020-07-16 | Adams | Indiana | 18001 | 54 | 2 |
335333 | 335333 | 2020-07-15 | Adams | Indiana | 18001 | 53 | 2 |
332140 | 332140 | 2020-07-14 | Adams | Indiana | 18001 | 50 | 2 |
328953 | 328953 | 2020-07-13 | Adams | Indiana | 18001 | 50 | 2 |
325767 | 325767 | 2020-07-12 | Adams | Indiana | 18001 | 50 | 2 |
322586 | 322586 | 2020-07-11 | Adams | Indiana | 18001 | 50 | 2 |
319407 | 319407 | 2020-07-10 | Adams | Indiana | 18001 | 50 | 2 |
316234 | 316234 | 2020-07-09 | Adams | Indiana | 18001 | 50 | 2 |
313060 | 313060 | 2020-07-08 | Adams | Indiana | 18001 | 50 | 2 |
309890 | 309890 | 2020-07-07 | Adams | Indiana | 18001 | 51 | 2 |
306722 | 306722 | 2020-07-06 | Adams | Indiana | 18001 | 51 | 2 |
303557 | 303557 | 2020-07-05 | Adams | Indiana | 18001 | 51 | 2 |
300393 | 300393 | 2020-07-04 | Adams | Indiana | 18001 | 51 | 2 |
297231 | 297231 | 2020-07-03 | Adams | Indiana | 18001 | 49 | 2 |
294073 | 294073 | 2020-07-02 | Adams | Indiana | 18001 | 48 | 2 |
290919 | 290919 | 2020-07-01 | Adams | Indiana | 18001 | 46 | 2 |
287769 | 287769 | 2020-06-30 | Adams | Indiana | 18001 | 46 | 2 |
284620 | 284620 | 2020-06-29 | Adams | Indiana | 18001 | 46 | 2 |
281475 | 281475 | 2020-06-28 | Adams | Indiana | 18001 | 45 | 2 |
278327 | 278327 | 2020-06-27 | Adams | Indiana | 18001 | 44 | 2 |
275179 | 275179 | 2020-06-26 | Adams | Indiana | 18001 | 43 | 2 |
272037 | 272037 | 2020-06-25 | Adams | Indiana | 18001 | 40 | 2 |
268900 | 268900 | 2020-06-24 | Adams | Indiana | 18001 | 39 | 2 |
265770 | 265770 | 2020-06-23 | Adams | Indiana | 18001 | 37 | 2 |
262642 | 262642 | 2020-06-22 | Adams | Indiana | 18001 | 37 | 2 |
259515 | 259515 | 2020-06-21 | Adams | Indiana | 18001 | 37 | 2 |
256389 | 256389 | 2020-06-20 | Adams | Indiana | 18001 | 37 | 2 |
253269 | 253269 | 2020-06-19 | Adams | Indiana | 18001 | 29 | 2 |
250154 | 250154 | 2020-06-18 | Adams | Indiana | 18001 | 29 | 2 |
247042 | 247042 | 2020-06-17 | Adams | Indiana | 18001 | 29 | 2 |
243929 | 243929 | 2020-06-16 | Adams | Indiana | 18001 | 28 | 1 |
240818 | 240818 | 2020-06-15 | Adams | Indiana | 18001 | 27 | 1 |
237710 | 237710 | 2020-06-14 | Adams | Indiana | 18001 | 26 | 1 |
234603 | 234603 | 2020-06-13 | Adams | Indiana | 18001 | 25 | 1 |
231497 | 231497 | 2020-06-12 | Adams | Indiana | 18001 | 24 | 1 |
228394 | 228394 | 2020-06-11 | Adams | Indiana | 18001 | 24 | 1 |
225292 | 225292 | 2020-06-10 | Adams | Indiana | 18001 | 24 | 1 |
222197 | 222197 | 2020-06-09 | Adams | Indiana | 18001 | 23 | 1 |
219102 | 219102 | 2020-06-08 | Adams | Indiana | 18001 | 22 | 1 |
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);