ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Rock Island" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
287747 | 287747 | 2020-06-30 | Rock Island | Illinois | 17161 | 947 | 29 |
290897 | 290897 | 2020-07-01 | Rock Island | Illinois | 17161 | 975 | 29 |
294051 | 294051 | 2020-07-02 | Rock Island | Illinois | 17161 | 995 | 29 |
297208 | 297208 | 2020-07-03 | Rock Island | Illinois | 17161 | 1019 | 29 |
300370 | 300370 | 2020-07-04 | Rock Island | Illinois | 17161 | 1043 | 29 |
303534 | 303534 | 2020-07-05 | Rock Island | Illinois | 17161 | 1064 | 29 |
306699 | 306699 | 2020-07-06 | Rock Island | Illinois | 17161 | 1086 | 30 |
309867 | 309867 | 2020-07-07 | Rock Island | Illinois | 17161 | 1097 | 30 |
313037 | 313037 | 2020-07-08 | Rock Island | Illinois | 17161 | 1122 | 30 |
316211 | 316211 | 2020-07-09 | Rock Island | Illinois | 17161 | 1139 | 30 |
319384 | 319384 | 2020-07-10 | Rock Island | Illinois | 17161 | 1163 | 30 |
322563 | 322563 | 2020-07-11 | Rock Island | Illinois | 17161 | 1195 | 30 |
325744 | 325744 | 2020-07-12 | Rock Island | Illinois | 17161 | 1214 | 30 |
328930 | 328930 | 2020-07-13 | Rock Island | Illinois | 17161 | 1234 | 30 |
332117 | 332117 | 2020-07-14 | Rock Island | Illinois | 17161 | 1248 | 30 |
335310 | 335310 | 2020-07-15 | Rock Island | Illinois | 17161 | 1265 | 30 |
338506 | 338506 | 2020-07-16 | Rock Island | Illinois | 17161 | 1285 | 30 |
341702 | 341702 | 2020-07-17 | Rock Island | Illinois | 17161 | 1315 | 30 |
344902 | 344902 | 2020-07-18 | Rock Island | Illinois | 17161 | 1337 | 30 |
348103 | 348103 | 2020-07-19 | Rock Island | Illinois | 17161 | 1357 | 30 |
351303 | 351303 | 2020-07-20 | Rock Island | Illinois | 17161 | 1359 | 30 |
354505 | 354505 | 2020-07-21 | Rock Island | Illinois | 17161 | 1373 | 30 |
357707 | 357707 | 2020-07-22 | Rock Island | Illinois | 17161 | 1397 | 30 |
360912 | 360912 | 2020-07-23 | Rock Island | Illinois | 17161 | 1429 | 30 |
364119 | 364119 | 2020-07-24 | Rock Island | Illinois | 17161 | 1451 | 30 |
367326 | 367326 | 2020-07-25 | Rock Island | Illinois | 17161 | 1460 | 30 |
370536 | 370536 | 2020-07-26 | Rock Island | Illinois | 17161 | 1472 | 30 |
373748 | 373748 | 2020-07-27 | Rock Island | Illinois | 17161 | 1480 | 30 |
376963 | 376963 | 2020-07-28 | Rock Island | Illinois | 17161 | 1491 | 30 |
380180 | 380180 | 2020-07-29 | Rock Island | Illinois | 17161 | 1501 | 30 |
383397 | 383397 | 2020-07-30 | Rock Island | Illinois | 17161 | 1550 | 30 |
386615 | 386615 | 2020-07-31 | Rock Island | Illinois | 17161 | 1575 | 31 |
389832 | 389832 | 2020-08-01 | Rock Island | Illinois | 17161 | 1575 | 31 |
393049 | 393049 | 2020-08-02 | Rock Island | Illinois | 17161 | 1618 | 31 |
396265 | 396265 | 2020-08-03 | Rock Island | Illinois | 17161 | 1637 | 32 |
399481 | 399481 | 2020-08-04 | Rock Island | Illinois | 17161 | 1645 | 32 |
402697 | 402697 | 2020-08-05 | Rock Island | Illinois | 17161 | 1679 | 33 |
405915 | 405915 | 2020-08-06 | Rock Island | Illinois | 17161 | 1693 | 34 |
409135 | 409135 | 2020-08-07 | Rock Island | Illinois | 17161 | 1715 | 36 |
412354 | 412354 | 2020-08-08 | Rock Island | Illinois | 17161 | 1762 | 37 |
415574 | 415574 | 2020-08-09 | Rock Island | Illinois | 17161 | 1777 | 38 |
418795 | 418795 | 2020-08-10 | Rock Island | Illinois | 17161 | 1777 | 38 |
422018 | 422018 | 2020-08-11 | Rock Island | Illinois | 17161 | 1800 | 39 |
425239 | 425239 | 2020-08-12 | Rock Island | Illinois | 17161 | 1821 | 40 |
428463 | 428463 | 2020-08-13 | Rock Island | Illinois | 17161 | 1842 | 40 |
431691 | 431691 | 2020-08-14 | Rock Island | Illinois | 17161 | 1856 | 40 |
434916 | 434916 | 2020-08-15 | Rock Island | Illinois | 17161 | 1878 | 40 |
438142 | 438142 | 2020-08-16 | Rock Island | Illinois | 17161 | 1898 | 40 |
441368 | 441368 | 2020-08-17 | Rock Island | Illinois | 17161 | 1911 | 44 |
444594 | 444594 | 2020-08-18 | Rock Island | Illinois | 17161 | 1927 | 47 |
447821 | 447821 | 2020-08-19 | Rock Island | Illinois | 17161 | 1964 | 50 |
451049 | 451049 | 2020-08-20 | Rock Island | Illinois | 17161 | 1979 | 50 |
454277 | 454277 | 2020-08-21 | Rock Island | Illinois | 17161 | 1979 | 50 |
457505 | 457505 | 2020-08-22 | Rock Island | Illinois | 17161 | 2020 | 52 |
460732 | 460732 | 2020-08-23 | Rock Island | Illinois | 17161 | 2028 | 52 |
463961 | 463961 | 2020-08-24 | Rock Island | Illinois | 17161 | 2061 | 53 |
467190 | 467190 | 2020-08-25 | Rock Island | Illinois | 17161 | 2091 | 56 |
470419 | 470419 | 2020-08-26 | Rock Island | Illinois | 17161 | 2106 | 56 |
473651 | 473651 | 2020-08-27 | Rock Island | Illinois | 17161 | 2123 | 57 |
476884 | 476884 | 2020-08-28 | Rock Island | Illinois | 17161 | 2138 | 59 |
480117 | 480117 | 2020-08-29 | Rock Island | Illinois | 17161 | 2189 | 59 |
483351 | 483351 | 2020-08-30 | Rock Island | Illinois | 17161 | 2219 | 60 |
486586 | 486586 | 2020-08-31 | Rock Island | Illinois | 17161 | 2247 | 60 |
489819 | 489819 | 2020-09-01 | Rock Island | Illinois | 17161 | 2266 | 63 |
493052 | 493052 | 2020-09-02 | Rock Island | Illinois | 17161 | 2290 | 65 |
496286 | 496286 | 2020-09-03 | Rock Island | Illinois | 17161 | 2322 | 67 |
499519 | 499519 | 2020-09-04 | Rock Island | Illinois | 17161 | 2378 | 68 |
502753 | 502753 | 2020-09-05 | Rock Island | Illinois | 17161 | 2404 | 68 |
505987 | 505987 | 2020-09-06 | Rock Island | Illinois | 17161 | 2463 | 68 |
509219 | 509219 | 2020-09-07 | Rock Island | Illinois | 17161 | 2530 | 68 |
512452 | 512452 | 2020-09-08 | Rock Island | Illinois | 17161 | 2556 | 71 |
515685 | 515685 | 2020-09-09 | Rock Island | Illinois | 17161 | 2571 | 71 |
518920 | 518920 | 2020-09-10 | Rock Island | Illinois | 17161 | 2597 | 71 |
522157 | 522157 | 2020-09-11 | Rock Island | Illinois | 17161 | 2628 | 71 |
525393 | 525393 | 2020-09-12 | Rock Island | Illinois | 17161 | 2664 | 71 |
528629 | 528629 | 2020-09-13 | Rock Island | Illinois | 17161 | 2684 | 73 |
531866 | 531866 | 2020-09-14 | Rock Island | Illinois | 17161 | 2705 | 74 |
535101 | 535101 | 2020-09-15 | Rock Island | Illinois | 17161 | 2705 | 74 |
538337 | 538337 | 2020-09-16 | Rock Island | Illinois | 17161 | 2749 | 74 |
541574 | 541574 | 2020-09-17 | Rock Island | Illinois | 17161 | 2789 | 74 |
544810 | 544810 | 2020-09-18 | Rock Island | Illinois | 17161 | 2833 | 75 |
548048 | 548048 | 2020-09-19 | Rock Island | Illinois | 17161 | 2867 | 75 |
551287 | 551287 | 2020-09-20 | Rock Island | Illinois | 17161 | 2885 | 75 |
554526 | 554526 | 2020-09-21 | Rock Island | Illinois | 17161 | 2908 | 79 |
557763 | 557763 | 2020-09-22 | Rock Island | Illinois | 17161 | 2921 | 79 |
560999 | 560999 | 2020-09-23 | Rock Island | Illinois | 17161 | 2945 | 82 |
564239 | 564239 | 2020-09-24 | Rock Island | Illinois | 17161 | 2971 | 82 |
567479 | 567479 | 2020-09-25 | Rock Island | Illinois | 17161 | 3004 | 82 |
570721 | 570721 | 2020-09-26 | Rock Island | Illinois | 17161 | 3036 | 83 |
573964 | 573964 | 2020-09-27 | Rock Island | Illinois | 17161 | 3064 | 83 |
577206 | 577206 | 2020-09-28 | Rock Island | Illinois | 17161 | 3092 | 83 |
580447 | 580447 | 2020-09-29 | Rock Island | Illinois | 17161 | 3124 | 85 |
583686 | 583686 | 2020-09-30 | Rock Island | Illinois | 17161 | 3157 | 85 |
586926 | 586926 | 2020-10-01 | Rock Island | Illinois | 17161 | 3197 | 85 |
590167 | 590167 | 2020-10-02 | Rock Island | Illinois | 17161 | 3223 | 85 |
593408 | 593408 | 2020-10-03 | Rock Island | Illinois | 17161 | 3253 | 85 |
596650 | 596650 | 2020-10-04 | Rock Island | Illinois | 17161 | 3274 | 85 |
599892 | 599892 | 2020-10-05 | Rock Island | Illinois | 17161 | 3298 | 86 |
603135 | 603135 | 2020-10-06 | Rock Island | Illinois | 17161 | 3320 | 87 |
606377 | 606377 | 2020-10-07 | Rock Island | Illinois | 17161 | 3344 | 87 |
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);