ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 18163 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535205 | 535205 | 2020-09-15 | Vanderburgh | Indiana | 18163 | 3090 | 24 |
531970 | 531970 | 2020-09-14 | Vanderburgh | Indiana | 18163 | 3058 | 24 |
528733 | 528733 | 2020-09-13 | Vanderburgh | Indiana | 18163 | 3030 | 24 |
525497 | 525497 | 2020-09-12 | Vanderburgh | Indiana | 18163 | 2984 | 24 |
522261 | 522261 | 2020-09-11 | Vanderburgh | Indiana | 18163 | 2935 | 23 |
519024 | 519024 | 2020-09-10 | Vanderburgh | Indiana | 18163 | 2879 | 23 |
515789 | 515789 | 2020-09-09 | Vanderburgh | Indiana | 18163 | 2816 | 23 |
512556 | 512556 | 2020-09-08 | Vanderburgh | Indiana | 18163 | 2809 | 23 |
509323 | 509323 | 2020-09-07 | Vanderburgh | Indiana | 18163 | 2780 | 23 |
506091 | 506091 | 2020-09-06 | Vanderburgh | Indiana | 18163 | 2756 | 23 |
502857 | 502857 | 2020-09-05 | Vanderburgh | Indiana | 18163 | 2725 | 23 |
499623 | 499623 | 2020-09-04 | Vanderburgh | Indiana | 18163 | 2690 | 21 |
496390 | 496390 | 2020-09-03 | Vanderburgh | Indiana | 18163 | 2652 | 19 |
493156 | 493156 | 2020-09-02 | Vanderburgh | Indiana | 18163 | 2624 | 19 |
489923 | 489923 | 2020-09-01 | Vanderburgh | Indiana | 18163 | 2609 | 19 |
486690 | 486690 | 2020-08-31 | Vanderburgh | Indiana | 18163 | 2591 | 19 |
483455 | 483455 | 2020-08-30 | Vanderburgh | Indiana | 18163 | 2563 | 19 |
480221 | 480221 | 2020-08-29 | Vanderburgh | Indiana | 18163 | 2531 | 19 |
476988 | 476988 | 2020-08-28 | Vanderburgh | Indiana | 18163 | 2498 | 19 |
473755 | 473755 | 2020-08-27 | Vanderburgh | Indiana | 18163 | 2455 | 18 |
470523 | 470523 | 2020-08-26 | Vanderburgh | Indiana | 18163 | 2420 | 18 |
467294 | 467294 | 2020-08-25 | Vanderburgh | Indiana | 18163 | 2385 | 17 |
464065 | 464065 | 2020-08-24 | Vanderburgh | Indiana | 18163 | 2364 | 17 |
460836 | 460836 | 2020-08-23 | Vanderburgh | Indiana | 18163 | 2334 | 17 |
457609 | 457609 | 2020-08-22 | Vanderburgh | Indiana | 18163 | 2320 | 17 |
454381 | 454381 | 2020-08-21 | Vanderburgh | Indiana | 18163 | 2293 | 17 |
451153 | 451153 | 2020-08-20 | Vanderburgh | Indiana | 18163 | 2255 | 17 |
447925 | 447925 | 2020-08-19 | Vanderburgh | Indiana | 18163 | 2243 | 17 |
444698 | 444698 | 2020-08-18 | Vanderburgh | Indiana | 18163 | 2225 | 16 |
441472 | 441472 | 2020-08-17 | Vanderburgh | Indiana | 18163 | 2203 | 15 |
438246 | 438246 | 2020-08-16 | Vanderburgh | Indiana | 18163 | 2184 | 15 |
435020 | 435020 | 2020-08-15 | Vanderburgh | Indiana | 18163 | 2152 | 15 |
431795 | 431795 | 2020-08-14 | Vanderburgh | Indiana | 18163 | 2125 | 15 |
428567 | 428567 | 2020-08-13 | Vanderburgh | Indiana | 18163 | 2085 | 15 |
425343 | 425343 | 2020-08-12 | Vanderburgh | Indiana | 18163 | 2056 | 13 |
422122 | 422122 | 2020-08-11 | Vanderburgh | Indiana | 18163 | 2025 | 13 |
418899 | 418899 | 2020-08-10 | Vanderburgh | Indiana | 18163 | 2000 | 13 |
415678 | 415678 | 2020-08-09 | Vanderburgh | Indiana | 18163 | 1966 | 13 |
412458 | 412458 | 2020-08-08 | Vanderburgh | Indiana | 18163 | 1925 | 13 |
409239 | 409239 | 2020-08-07 | Vanderburgh | Indiana | 18163 | 1891 | 13 |
406019 | 406019 | 2020-08-06 | Vanderburgh | Indiana | 18163 | 1845 | 13 |
402801 | 402801 | 2020-08-05 | Vanderburgh | Indiana | 18163 | 1803 | 13 |
399585 | 399585 | 2020-08-04 | Vanderburgh | Indiana | 18163 | 1766 | 12 |
396369 | 396369 | 2020-08-03 | Vanderburgh | Indiana | 18163 | 1729 | 12 |
393153 | 393153 | 2020-08-02 | Vanderburgh | Indiana | 18163 | 1703 | 12 |
389936 | 389936 | 2020-08-01 | Vanderburgh | Indiana | 18163 | 1682 | 12 |
386719 | 386719 | 2020-07-31 | Vanderburgh | Indiana | 18163 | 1624 | 10 |
383501 | 383501 | 2020-07-30 | Vanderburgh | Indiana | 18163 | 1582 | 8 |
380284 | 380284 | 2020-07-29 | Vanderburgh | Indiana | 18163 | 1532 | 8 |
377067 | 377067 | 2020-07-28 | Vanderburgh | Indiana | 18163 | 1503 | 8 |
373852 | 373852 | 2020-07-27 | Vanderburgh | Indiana | 18163 | 1461 | 7 |
370640 | 370640 | 2020-07-26 | Vanderburgh | Indiana | 18163 | 1436 | 7 |
367430 | 367430 | 2020-07-25 | Vanderburgh | Indiana | 18163 | 1397 | 7 |
364223 | 364223 | 2020-07-24 | Vanderburgh | Indiana | 18163 | 1344 | 7 |
361016 | 361016 | 2020-07-23 | Vanderburgh | Indiana | 18163 | 1292 | 7 |
357811 | 357811 | 2020-07-22 | Vanderburgh | Indiana | 18163 | 1239 | 6 |
354609 | 354609 | 2020-07-21 | Vanderburgh | Indiana | 18163 | 1194 | 6 |
351407 | 351407 | 2020-07-20 | Vanderburgh | Indiana | 18163 | 1156 | 6 |
348207 | 348207 | 2020-07-19 | Vanderburgh | Indiana | 18163 | 1117 | 6 |
345006 | 345006 | 2020-07-18 | Vanderburgh | Indiana | 18163 | 1061 | 6 |
341806 | 341806 | 2020-07-17 | Vanderburgh | Indiana | 18163 | 1013 | 6 |
338610 | 338610 | 2020-07-16 | Vanderburgh | Indiana | 18163 | 966 | 6 |
335414 | 335414 | 2020-07-15 | Vanderburgh | Indiana | 18163 | 908 | 6 |
332221 | 332221 | 2020-07-14 | Vanderburgh | Indiana | 18163 | 861 | 6 |
329034 | 329034 | 2020-07-13 | Vanderburgh | Indiana | 18163 | 804 | 6 |
325848 | 325848 | 2020-07-12 | Vanderburgh | Indiana | 18163 | 771 | 6 |
322667 | 322667 | 2020-07-11 | Vanderburgh | Indiana | 18163 | 730 | 6 |
319488 | 319488 | 2020-07-10 | Vanderburgh | Indiana | 18163 | 684 | 6 |
316315 | 316315 | 2020-07-09 | Vanderburgh | Indiana | 18163 | 632 | 6 |
313141 | 313141 | 2020-07-08 | Vanderburgh | Indiana | 18163 | 590 | 6 |
309971 | 309971 | 2020-07-07 | Vanderburgh | Indiana | 18163 | 573 | 6 |
306803 | 306803 | 2020-07-06 | Vanderburgh | Indiana | 18163 | 551 | 6 |
303638 | 303638 | 2020-07-05 | Vanderburgh | Indiana | 18163 | 525 | 6 |
300474 | 300474 | 2020-07-04 | Vanderburgh | Indiana | 18163 | 505 | 6 |
297312 | 297312 | 2020-07-03 | Vanderburgh | Indiana | 18163 | 483 | 6 |
294154 | 294154 | 2020-07-02 | Vanderburgh | Indiana | 18163 | 460 | 6 |
291000 | 291000 | 2020-07-01 | Vanderburgh | Indiana | 18163 | 433 | 6 |
287850 | 287850 | 2020-06-30 | Vanderburgh | Indiana | 18163 | 416 | 6 |
284701 | 284701 | 2020-06-29 | Vanderburgh | Indiana | 18163 | 410 | 6 |
281556 | 281556 | 2020-06-28 | Vanderburgh | Indiana | 18163 | 403 | 6 |
278408 | 278408 | 2020-06-27 | Vanderburgh | Indiana | 18163 | 391 | 6 |
275260 | 275260 | 2020-06-26 | Vanderburgh | Indiana | 18163 | 379 | 6 |
272118 | 272118 | 2020-06-25 | Vanderburgh | Indiana | 18163 | 372 | 6 |
268981 | 268981 | 2020-06-24 | Vanderburgh | Indiana | 18163 | 362 | 6 |
265851 | 265851 | 2020-06-23 | Vanderburgh | Indiana | 18163 | 350 | 6 |
262723 | 262723 | 2020-06-22 | Vanderburgh | Indiana | 18163 | 346 | 6 |
259596 | 259596 | 2020-06-21 | Vanderburgh | Indiana | 18163 | 345 | 6 |
256470 | 256470 | 2020-06-20 | Vanderburgh | Indiana | 18163 | 344 | 6 |
253350 | 253350 | 2020-06-19 | Vanderburgh | Indiana | 18163 | 340 | 6 |
250235 | 250235 | 2020-06-18 | Vanderburgh | Indiana | 18163 | 339 | 5 |
247123 | 247123 | 2020-06-17 | Vanderburgh | Indiana | 18163 | 338 | 5 |
244010 | 244010 | 2020-06-16 | Vanderburgh | Indiana | 18163 | 332 | 5 |
240899 | 240899 | 2020-06-15 | Vanderburgh | Indiana | 18163 | 333 | 5 |
237791 | 237791 | 2020-06-14 | Vanderburgh | Indiana | 18163 | 329 | 5 |
234684 | 234684 | 2020-06-13 | Vanderburgh | Indiana | 18163 | 326 | 4 |
231578 | 231578 | 2020-06-12 | Vanderburgh | Indiana | 18163 | 324 | 4 |
228475 | 228475 | 2020-06-11 | Vanderburgh | Indiana | 18163 | 319 | 4 |
225373 | 225373 | 2020-06-10 | Vanderburgh | Indiana | 18163 | 316 | 4 |
222278 | 222278 | 2020-06-09 | Vanderburgh | Indiana | 18163 | 311 | 4 |
219183 | 219183 | 2020-06-08 | Vanderburgh | Indiana | 18163 | 306 | 4 |
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);