ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 17027 and state = "Illinois" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
265681 | 265681 | 2020-06-23 | Clinton | Illinois | 17027 | 225 | 17 |
268811 | 268811 | 2020-06-24 | Clinton | Illinois | 17027 | 224 | 17 |
271948 | 271948 | 2020-06-25 | Clinton | Illinois | 17027 | 226 | 17 |
275090 | 275090 | 2020-06-26 | Clinton | Illinois | 17027 | 229 | 17 |
278238 | 278238 | 2020-06-27 | Clinton | Illinois | 17027 | 231 | 17 |
281386 | 281386 | 2020-06-28 | Clinton | Illinois | 17027 | 233 | 17 |
284531 | 284531 | 2020-06-29 | Clinton | Illinois | 17027 | 236 | 17 |
287680 | 287680 | 2020-06-30 | Clinton | Illinois | 17027 | 236 | 17 |
290830 | 290830 | 2020-07-01 | Clinton | Illinois | 17027 | 237 | 17 |
293984 | 293984 | 2020-07-02 | Clinton | Illinois | 17027 | 239 | 17 |
297141 | 297141 | 2020-07-03 | Clinton | Illinois | 17027 | 240 | 17 |
300303 | 300303 | 2020-07-04 | Clinton | Illinois | 17027 | 241 | 17 |
303467 | 303467 | 2020-07-05 | Clinton | Illinois | 17027 | 242 | 17 |
306632 | 306632 | 2020-07-06 | Clinton | Illinois | 17027 | 242 | 17 |
309800 | 309800 | 2020-07-07 | Clinton | Illinois | 17027 | 243 | 17 |
312970 | 312970 | 2020-07-08 | Clinton | Illinois | 17027 | 244 | 17 |
316144 | 316144 | 2020-07-09 | Clinton | Illinois | 17027 | 244 | 17 |
319317 | 319317 | 2020-07-10 | Clinton | Illinois | 17027 | 245 | 17 |
322496 | 322496 | 2020-07-11 | Clinton | Illinois | 17027 | 247 | 17 |
325677 | 325677 | 2020-07-12 | Clinton | Illinois | 17027 | 246 | 16 |
328863 | 328863 | 2020-07-13 | Clinton | Illinois | 17027 | 246 | 16 |
332050 | 332050 | 2020-07-14 | Clinton | Illinois | 17027 | 252 | 16 |
335243 | 335243 | 2020-07-15 | Clinton | Illinois | 17027 | 256 | 17 |
338439 | 338439 | 2020-07-16 | Clinton | Illinois | 17027 | 260 | 16 |
341635 | 341635 | 2020-07-17 | Clinton | Illinois | 17027 | 264 | 16 |
344835 | 344835 | 2020-07-18 | Clinton | Illinois | 17027 | 267 | 16 |
348036 | 348036 | 2020-07-19 | Clinton | Illinois | 17027 | 268 | 16 |
351236 | 351236 | 2020-07-20 | Clinton | Illinois | 17027 | 271 | 17 |
354438 | 354438 | 2020-07-21 | Clinton | Illinois | 17027 | 273 | 17 |
357640 | 357640 | 2020-07-22 | Clinton | Illinois | 17027 | 278 | 17 |
360845 | 360845 | 2020-07-23 | Clinton | Illinois | 17027 | 288 | 17 |
364052 | 364052 | 2020-07-24 | Clinton | Illinois | 17027 | 292 | 17 |
367259 | 367259 | 2020-07-25 | Clinton | Illinois | 17027 | 294 | 17 |
370469 | 370469 | 2020-07-26 | Clinton | Illinois | 17027 | 298 | 17 |
373681 | 373681 | 2020-07-27 | Clinton | Illinois | 17027 | 306 | 17 |
376896 | 376896 | 2020-07-28 | Clinton | Illinois | 17027 | 311 | 17 |
380113 | 380113 | 2020-07-29 | Clinton | Illinois | 17027 | 319 | 17 |
383330 | 383330 | 2020-07-30 | Clinton | Illinois | 17027 | 321 | 17 |
386548 | 386548 | 2020-07-31 | Clinton | Illinois | 17027 | 330 | 17 |
389765 | 389765 | 2020-08-01 | Clinton | Illinois | 17027 | 333 | 17 |
392982 | 392982 | 2020-08-02 | Clinton | Illinois | 17027 | 338 | 17 |
396198 | 396198 | 2020-08-03 | Clinton | Illinois | 17027 | 349 | 17 |
399414 | 399414 | 2020-08-04 | Clinton | Illinois | 17027 | 353 | 17 |
402630 | 402630 | 2020-08-05 | Clinton | Illinois | 17027 | 366 | 17 |
405848 | 405848 | 2020-08-06 | Clinton | Illinois | 17027 | 378 | 17 |
409068 | 409068 | 2020-08-07 | Clinton | Illinois | 17027 | 387 | 17 |
412287 | 412287 | 2020-08-08 | Clinton | Illinois | 17027 | 396 | 17 |
415507 | 415507 | 2020-08-09 | Clinton | Illinois | 17027 | 407 | 17 |
418728 | 418728 | 2020-08-10 | Clinton | Illinois | 17027 | 411 | 17 |
421951 | 421951 | 2020-08-11 | Clinton | Illinois | 17027 | 415 | 17 |
425172 | 425172 | 2020-08-12 | Clinton | Illinois | 17027 | 419 | 17 |
428396 | 428396 | 2020-08-13 | Clinton | Illinois | 17027 | 433 | 17 |
431624 | 431624 | 2020-08-14 | Clinton | Illinois | 17027 | 454 | 17 |
434849 | 434849 | 2020-08-15 | Clinton | Illinois | 17027 | 468 | 17 |
438075 | 438075 | 2020-08-16 | Clinton | Illinois | 17027 | 485 | 17 |
441301 | 441301 | 2020-08-17 | Clinton | Illinois | 17027 | 492 | 17 |
444527 | 444527 | 2020-08-18 | Clinton | Illinois | 17027 | 512 | 17 |
447754 | 447754 | 2020-08-19 | Clinton | Illinois | 17027 | 524 | 17 |
450982 | 450982 | 2020-08-20 | Clinton | Illinois | 17027 | 548 | 17 |
454210 | 454210 | 2020-08-21 | Clinton | Illinois | 17027 | 553 | 17 |
457438 | 457438 | 2020-08-22 | Clinton | Illinois | 17027 | 574 | 17 |
460665 | 460665 | 2020-08-23 | Clinton | Illinois | 17027 | 582 | 17 |
463894 | 463894 | 2020-08-24 | Clinton | Illinois | 17027 | 606 | 17 |
467123 | 467123 | 2020-08-25 | Clinton | Illinois | 17027 | 632 | 17 |
470352 | 470352 | 2020-08-26 | Clinton | Illinois | 17027 | 647 | 17 |
473584 | 473584 | 2020-08-27 | Clinton | Illinois | 17027 | 667 | 17 |
476817 | 476817 | 2020-08-28 | Clinton | Illinois | 17027 | 670 | 17 |
480050 | 480050 | 2020-08-29 | Clinton | Illinois | 17027 | 691 | 17 |
483284 | 483284 | 2020-08-30 | Clinton | Illinois | 17027 | 692 | 17 |
486519 | 486519 | 2020-08-31 | Clinton | Illinois | 17027 | 715 | 17 |
489752 | 489752 | 2020-09-01 | Clinton | Illinois | 17027 | 740 | 17 |
492985 | 492985 | 2020-09-02 | Clinton | Illinois | 17027 | 765 | 17 |
496219 | 496219 | 2020-09-03 | Clinton | Illinois | 17027 | 771 | 17 |
499452 | 499452 | 2020-09-04 | Clinton | Illinois | 17027 | 809 | 17 |
502686 | 502686 | 2020-09-05 | Clinton | Illinois | 17027 | 832 | 17 |
505920 | 505920 | 2020-09-06 | Clinton | Illinois | 17027 | 842 | 17 |
509152 | 509152 | 2020-09-07 | Clinton | Illinois | 17027 | 857 | 17 |
512385 | 512385 | 2020-09-08 | Clinton | Illinois | 17027 | 869 | 19 |
515618 | 515618 | 2020-09-09 | Clinton | Illinois | 17027 | 884 | 19 |
518853 | 518853 | 2020-09-10 | Clinton | Illinois | 17027 | 902 | 19 |
522090 | 522090 | 2020-09-11 | Clinton | Illinois | 17027 | 922 | 19 |
525326 | 525326 | 2020-09-12 | Clinton | Illinois | 17027 | 936 | 19 |
528562 | 528562 | 2020-09-13 | Clinton | Illinois | 17027 | 950 | 19 |
531799 | 531799 | 2020-09-14 | Clinton | Illinois | 17027 | 961 | 19 |
535034 | 535034 | 2020-09-15 | Clinton | Illinois | 17027 | 971 | 19 |
538270 | 538270 | 2020-09-16 | Clinton | Illinois | 17027 | 987 | 20 |
541507 | 541507 | 2020-09-17 | Clinton | Illinois | 17027 | 1004 | 20 |
544743 | 544743 | 2020-09-18 | Clinton | Illinois | 17027 | 1022 | 20 |
547981 | 547981 | 2020-09-19 | Clinton | Illinois | 17027 | 1051 | 20 |
551220 | 551220 | 2020-09-20 | Clinton | Illinois | 17027 | 1064 | 20 |
554459 | 554459 | 2020-09-21 | Clinton | Illinois | 17027 | 1071 | 20 |
557696 | 557696 | 2020-09-22 | Clinton | Illinois | 17027 | 1084 | 20 |
560932 | 560932 | 2020-09-23 | Clinton | Illinois | 17027 | 1088 | 20 |
564172 | 564172 | 2020-09-24 | Clinton | Illinois | 17027 | 1101 | 20 |
567412 | 567412 | 2020-09-25 | Clinton | Illinois | 17027 | 1129 | 20 |
570654 | 570654 | 2020-09-26 | Clinton | Illinois | 17027 | 1153 | 20 |
573897 | 573897 | 2020-09-27 | Clinton | Illinois | 17027 | 1169 | 20 |
577139 | 577139 | 2020-09-28 | Clinton | Illinois | 17027 | 1190 | 20 |
580380 | 580380 | 2020-09-29 | Clinton | Illinois | 17027 | 1203 | 21 |
583619 | 583619 | 2020-09-30 | Clinton | Illinois | 17027 | 1222 | 21 |
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);