ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Rock Island" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535101 | 535101 | 2020-09-15 | Rock Island | Illinois | 17161 | 2705 | 74 |
531866 | 531866 | 2020-09-14 | Rock Island | Illinois | 17161 | 2705 | 74 |
528629 | 528629 | 2020-09-13 | Rock Island | Illinois | 17161 | 2684 | 73 |
525393 | 525393 | 2020-09-12 | Rock Island | Illinois | 17161 | 2664 | 71 |
522157 | 522157 | 2020-09-11 | Rock Island | Illinois | 17161 | 2628 | 71 |
518920 | 518920 | 2020-09-10 | Rock Island | Illinois | 17161 | 2597 | 71 |
515685 | 515685 | 2020-09-09 | Rock Island | Illinois | 17161 | 2571 | 71 |
512452 | 512452 | 2020-09-08 | Rock Island | Illinois | 17161 | 2556 | 71 |
509219 | 509219 | 2020-09-07 | Rock Island | Illinois | 17161 | 2530 | 68 |
505987 | 505987 | 2020-09-06 | Rock Island | Illinois | 17161 | 2463 | 68 |
502753 | 502753 | 2020-09-05 | Rock Island | Illinois | 17161 | 2404 | 68 |
499519 | 499519 | 2020-09-04 | Rock Island | Illinois | 17161 | 2378 | 68 |
496286 | 496286 | 2020-09-03 | Rock Island | Illinois | 17161 | 2322 | 67 |
493052 | 493052 | 2020-09-02 | Rock Island | Illinois | 17161 | 2290 | 65 |
489819 | 489819 | 2020-09-01 | Rock Island | Illinois | 17161 | 2266 | 63 |
486586 | 486586 | 2020-08-31 | Rock Island | Illinois | 17161 | 2247 | 60 |
483351 | 483351 | 2020-08-30 | Rock Island | Illinois | 17161 | 2219 | 60 |
480117 | 480117 | 2020-08-29 | Rock Island | Illinois | 17161 | 2189 | 59 |
476884 | 476884 | 2020-08-28 | Rock Island | Illinois | 17161 | 2138 | 59 |
473651 | 473651 | 2020-08-27 | Rock Island | Illinois | 17161 | 2123 | 57 |
470419 | 470419 | 2020-08-26 | Rock Island | Illinois | 17161 | 2106 | 56 |
467190 | 467190 | 2020-08-25 | Rock Island | Illinois | 17161 | 2091 | 56 |
463961 | 463961 | 2020-08-24 | Rock Island | Illinois | 17161 | 2061 | 53 |
460732 | 460732 | 2020-08-23 | Rock Island | Illinois | 17161 | 2028 | 52 |
457505 | 457505 | 2020-08-22 | Rock Island | Illinois | 17161 | 2020 | 52 |
454277 | 454277 | 2020-08-21 | Rock Island | Illinois | 17161 | 1979 | 50 |
451049 | 451049 | 2020-08-20 | Rock Island | Illinois | 17161 | 1979 | 50 |
447821 | 447821 | 2020-08-19 | Rock Island | Illinois | 17161 | 1964 | 50 |
444594 | 444594 | 2020-08-18 | Rock Island | Illinois | 17161 | 1927 | 47 |
441368 | 441368 | 2020-08-17 | Rock Island | Illinois | 17161 | 1911 | 44 |
438142 | 438142 | 2020-08-16 | Rock Island | Illinois | 17161 | 1898 | 40 |
434916 | 434916 | 2020-08-15 | Rock Island | Illinois | 17161 | 1878 | 40 |
431691 | 431691 | 2020-08-14 | Rock Island | Illinois | 17161 | 1856 | 40 |
428463 | 428463 | 2020-08-13 | Rock Island | Illinois | 17161 | 1842 | 40 |
425239 | 425239 | 2020-08-12 | Rock Island | Illinois | 17161 | 1821 | 40 |
422018 | 422018 | 2020-08-11 | Rock Island | Illinois | 17161 | 1800 | 39 |
418795 | 418795 | 2020-08-10 | Rock Island | Illinois | 17161 | 1777 | 38 |
415574 | 415574 | 2020-08-09 | Rock Island | Illinois | 17161 | 1777 | 38 |
412354 | 412354 | 2020-08-08 | Rock Island | Illinois | 17161 | 1762 | 37 |
409135 | 409135 | 2020-08-07 | Rock Island | Illinois | 17161 | 1715 | 36 |
405915 | 405915 | 2020-08-06 | Rock Island | Illinois | 17161 | 1693 | 34 |
402697 | 402697 | 2020-08-05 | Rock Island | Illinois | 17161 | 1679 | 33 |
399481 | 399481 | 2020-08-04 | Rock Island | Illinois | 17161 | 1645 | 32 |
396265 | 396265 | 2020-08-03 | Rock Island | Illinois | 17161 | 1637 | 32 |
393049 | 393049 | 2020-08-02 | Rock Island | Illinois | 17161 | 1618 | 31 |
389832 | 389832 | 2020-08-01 | Rock Island | Illinois | 17161 | 1575 | 31 |
386615 | 386615 | 2020-07-31 | Rock Island | Illinois | 17161 | 1575 | 31 |
383397 | 383397 | 2020-07-30 | Rock Island | Illinois | 17161 | 1550 | 30 |
380180 | 380180 | 2020-07-29 | Rock Island | Illinois | 17161 | 1501 | 30 |
376963 | 376963 | 2020-07-28 | Rock Island | Illinois | 17161 | 1491 | 30 |
373748 | 373748 | 2020-07-27 | Rock Island | Illinois | 17161 | 1480 | 30 |
370536 | 370536 | 2020-07-26 | Rock Island | Illinois | 17161 | 1472 | 30 |
367326 | 367326 | 2020-07-25 | Rock Island | Illinois | 17161 | 1460 | 30 |
364119 | 364119 | 2020-07-24 | Rock Island | Illinois | 17161 | 1451 | 30 |
360912 | 360912 | 2020-07-23 | Rock Island | Illinois | 17161 | 1429 | 30 |
357707 | 357707 | 2020-07-22 | Rock Island | Illinois | 17161 | 1397 | 30 |
354505 | 354505 | 2020-07-21 | Rock Island | Illinois | 17161 | 1373 | 30 |
351303 | 351303 | 2020-07-20 | Rock Island | Illinois | 17161 | 1359 | 30 |
348103 | 348103 | 2020-07-19 | Rock Island | Illinois | 17161 | 1357 | 30 |
344902 | 344902 | 2020-07-18 | Rock Island | Illinois | 17161 | 1337 | 30 |
341702 | 341702 | 2020-07-17 | Rock Island | Illinois | 17161 | 1315 | 30 |
338506 | 338506 | 2020-07-16 | Rock Island | Illinois | 17161 | 1285 | 30 |
335310 | 335310 | 2020-07-15 | Rock Island | Illinois | 17161 | 1265 | 30 |
332117 | 332117 | 2020-07-14 | Rock Island | Illinois | 17161 | 1248 | 30 |
328930 | 328930 | 2020-07-13 | Rock Island | Illinois | 17161 | 1234 | 30 |
325744 | 325744 | 2020-07-12 | Rock Island | Illinois | 17161 | 1214 | 30 |
322563 | 322563 | 2020-07-11 | Rock Island | Illinois | 17161 | 1195 | 30 |
319384 | 319384 | 2020-07-10 | Rock Island | Illinois | 17161 | 1163 | 30 |
316211 | 316211 | 2020-07-09 | Rock Island | Illinois | 17161 | 1139 | 30 |
313037 | 313037 | 2020-07-08 | Rock Island | Illinois | 17161 | 1122 | 30 |
309867 | 309867 | 2020-07-07 | Rock Island | Illinois | 17161 | 1097 | 30 |
306699 | 306699 | 2020-07-06 | Rock Island | Illinois | 17161 | 1086 | 30 |
303534 | 303534 | 2020-07-05 | Rock Island | Illinois | 17161 | 1064 | 29 |
300370 | 300370 | 2020-07-04 | Rock Island | Illinois | 17161 | 1043 | 29 |
297208 | 297208 | 2020-07-03 | Rock Island | Illinois | 17161 | 1019 | 29 |
294051 | 294051 | 2020-07-02 | Rock Island | Illinois | 17161 | 995 | 29 |
290897 | 290897 | 2020-07-01 | Rock Island | Illinois | 17161 | 975 | 29 |
287747 | 287747 | 2020-06-30 | Rock Island | Illinois | 17161 | 947 | 29 |
284598 | 284598 | 2020-06-29 | Rock Island | Illinois | 17161 | 935 | 29 |
281453 | 281453 | 2020-06-28 | Rock Island | Illinois | 17161 | 924 | 28 |
278305 | 278305 | 2020-06-27 | Rock Island | Illinois | 17161 | 913 | 28 |
275157 | 275157 | 2020-06-26 | Rock Island | Illinois | 17161 | 861 | 28 |
272015 | 272015 | 2020-06-25 | Rock Island | Illinois | 17161 | 841 | 28 |
268878 | 268878 | 2020-06-24 | Rock Island | Illinois | 17161 | 833 | 28 |
265748 | 265748 | 2020-06-23 | Rock Island | Illinois | 17161 | 822 | 28 |
262620 | 262620 | 2020-06-22 | Rock Island | Illinois | 17161 | 812 | 28 |
259493 | 259493 | 2020-06-21 | Rock Island | Illinois | 17161 | 807 | 28 |
256367 | 256367 | 2020-06-20 | Rock Island | Illinois | 17161 | 796 | 28 |
253247 | 253247 | 2020-06-19 | Rock Island | Illinois | 17161 | 793 | 28 |
250132 | 250132 | 2020-06-18 | Rock Island | Illinois | 17161 | 791 | 28 |
247020 | 247020 | 2020-06-17 | Rock Island | Illinois | 17161 | 786 | 28 |
243907 | 243907 | 2020-06-16 | Rock Island | Illinois | 17161 | 783 | 28 |
240796 | 240796 | 2020-06-15 | Rock Island | Illinois | 17161 | 782 | 28 |
237688 | 237688 | 2020-06-14 | Rock Island | Illinois | 17161 | 779 | 28 |
234581 | 234581 | 2020-06-13 | Rock Island | Illinois | 17161 | 778 | 28 |
231475 | 231475 | 2020-06-12 | Rock Island | Illinois | 17161 | 770 | 28 |
228372 | 228372 | 2020-06-11 | Rock Island | Illinois | 17161 | 763 | 28 |
225270 | 225270 | 2020-06-10 | Rock Island | Illinois | 17161 | 753 | 28 |
222175 | 222175 | 2020-06-09 | Rock Island | Illinois | 17161 | 746 | 28 |
219080 | 219080 | 2020-06-08 | Rock Island | Illinois | 17161 | 746 | 28 |
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);