ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Jackson" and fips = 17077 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535059 | 535059 | 2020-09-15 | Jackson | Illinois | 17077 | 1169 | 24 |
531824 | 531824 | 2020-09-14 | Jackson | Illinois | 17077 | 1159 | 24 |
528587 | 528587 | 2020-09-13 | Jackson | Illinois | 17077 | 1144 | 24 |
525351 | 525351 | 2020-09-12 | Jackson | Illinois | 17077 | 1135 | 24 |
522115 | 522115 | 2020-09-11 | Jackson | Illinois | 17077 | 1120 | 24 |
518878 | 518878 | 2020-09-10 | Jackson | Illinois | 17077 | 1103 | 25 |
515643 | 515643 | 2020-09-09 | Jackson | Illinois | 17077 | 1086 | 24 |
512410 | 512410 | 2020-09-08 | Jackson | Illinois | 17077 | 1072 | 23 |
509177 | 509177 | 2020-09-07 | Jackson | Illinois | 17077 | 1067 | 22 |
505945 | 505945 | 2020-09-06 | Jackson | Illinois | 17077 | 1061 | 22 |
502711 | 502711 | 2020-09-05 | Jackson | Illinois | 17077 | 1043 | 22 |
499477 | 499477 | 2020-09-04 | Jackson | Illinois | 17077 | 1021 | 22 |
496244 | 496244 | 2020-09-03 | Jackson | Illinois | 17077 | 984 | 22 |
493010 | 493010 | 2020-09-02 | Jackson | Illinois | 17077 | 973 | 22 |
489777 | 489777 | 2020-09-01 | Jackson | Illinois | 17077 | 951 | 22 |
486544 | 486544 | 2020-08-31 | Jackson | Illinois | 17077 | 929 | 21 |
483309 | 483309 | 2020-08-30 | Jackson | Illinois | 17077 | 915 | 21 |
480075 | 480075 | 2020-08-29 | Jackson | Illinois | 17077 | 909 | 21 |
476842 | 476842 | 2020-08-28 | Jackson | Illinois | 17077 | 895 | 20 |
473609 | 473609 | 2020-08-27 | Jackson | Illinois | 17077 | 892 | 20 |
470377 | 470377 | 2020-08-26 | Jackson | Illinois | 17077 | 877 | 20 |
467148 | 467148 | 2020-08-25 | Jackson | Illinois | 17077 | 862 | 20 |
463919 | 463919 | 2020-08-24 | Jackson | Illinois | 17077 | 851 | 20 |
460690 | 460690 | 2020-08-23 | Jackson | Illinois | 17077 | 835 | 20 |
457463 | 457463 | 2020-08-22 | Jackson | Illinois | 17077 | 828 | 20 |
454235 | 454235 | 2020-08-21 | Jackson | Illinois | 17077 | 824 | 20 |
451007 | 451007 | 2020-08-20 | Jackson | Illinois | 17077 | 814 | 20 |
447779 | 447779 | 2020-08-19 | Jackson | Illinois | 17077 | 807 | 20 |
444552 | 444552 | 2020-08-18 | Jackson | Illinois | 17077 | 796 | 20 |
441326 | 441326 | 2020-08-17 | Jackson | Illinois | 17077 | 778 | 20 |
438100 | 438100 | 2020-08-16 | Jackson | Illinois | 17077 | 772 | 20 |
434874 | 434874 | 2020-08-15 | Jackson | Illinois | 17077 | 760 | 20 |
431649 | 431649 | 2020-08-14 | Jackson | Illinois | 17077 | 755 | 20 |
428421 | 428421 | 2020-08-13 | Jackson | Illinois | 17077 | 743 | 20 |
425197 | 425197 | 2020-08-12 | Jackson | Illinois | 17077 | 740 | 20 |
421976 | 421976 | 2020-08-11 | Jackson | Illinois | 17077 | 731 | 20 |
418753 | 418753 | 2020-08-10 | Jackson | Illinois | 17077 | 722 | 19 |
415532 | 415532 | 2020-08-09 | Jackson | Illinois | 17077 | 717 | 19 |
412312 | 412312 | 2020-08-08 | Jackson | Illinois | 17077 | 708 | 19 |
409093 | 409093 | 2020-08-07 | Jackson | Illinois | 17077 | 695 | 19 |
405873 | 405873 | 2020-08-06 | Jackson | Illinois | 17077 | 685 | 19 |
402655 | 402655 | 2020-08-05 | Jackson | Illinois | 17077 | 676 | 19 |
399439 | 399439 | 2020-08-04 | Jackson | Illinois | 17077 | 658 | 19 |
396223 | 396223 | 2020-08-03 | Jackson | Illinois | 17077 | 650 | 19 |
393007 | 393007 | 2020-08-02 | Jackson | Illinois | 17077 | 644 | 19 |
389790 | 389790 | 2020-08-01 | Jackson | Illinois | 17077 | 631 | 19 |
386573 | 386573 | 2020-07-31 | Jackson | Illinois | 17077 | 616 | 19 |
383355 | 383355 | 2020-07-30 | Jackson | Illinois | 17077 | 591 | 19 |
380138 | 380138 | 2020-07-29 | Jackson | Illinois | 17077 | 572 | 19 |
376921 | 376921 | 2020-07-28 | Jackson | Illinois | 17077 | 556 | 19 |
373706 | 373706 | 2020-07-27 | Jackson | Illinois | 17077 | 544 | 19 |
370494 | 370494 | 2020-07-26 | Jackson | Illinois | 17077 | 530 | 19 |
367284 | 367284 | 2020-07-25 | Jackson | Illinois | 17077 | 487 | 19 |
364077 | 364077 | 2020-07-24 | Jackson | Illinois | 17077 | 463 | 19 |
360870 | 360870 | 2020-07-23 | Jackson | Illinois | 17077 | 450 | 19 |
357665 | 357665 | 2020-07-22 | Jackson | Illinois | 17077 | 434 | 19 |
354463 | 354463 | 2020-07-21 | Jackson | Illinois | 17077 | 420 | 19 |
351261 | 351261 | 2020-07-20 | Jackson | Illinois | 17077 | 420 | 19 |
348061 | 348061 | 2020-07-19 | Jackson | Illinois | 17077 | 400 | 19 |
344860 | 344860 | 2020-07-18 | Jackson | Illinois | 17077 | 389 | 19 |
341660 | 341660 | 2020-07-17 | Jackson | Illinois | 17077 | 381 | 19 |
338464 | 338464 | 2020-07-16 | Jackson | Illinois | 17077 | 373 | 19 |
335268 | 335268 | 2020-07-15 | Jackson | Illinois | 17077 | 366 | 19 |
332075 | 332075 | 2020-07-14 | Jackson | Illinois | 17077 | 359 | 19 |
328888 | 328888 | 2020-07-13 | Jackson | Illinois | 17077 | 357 | 19 |
325702 | 325702 | 2020-07-12 | Jackson | Illinois | 17077 | 356 | 19 |
322521 | 322521 | 2020-07-11 | Jackson | Illinois | 17077 | 351 | 19 |
319342 | 319342 | 2020-07-10 | Jackson | Illinois | 17077 | 347 | 19 |
316169 | 316169 | 2020-07-09 | Jackson | Illinois | 17077 | 345 | 19 |
312995 | 312995 | 2020-07-08 | Jackson | Illinois | 17077 | 343 | 19 |
309825 | 309825 | 2020-07-07 | Jackson | Illinois | 17077 | 340 | 19 |
306657 | 306657 | 2020-07-06 | Jackson | Illinois | 17077 | 340 | 19 |
303492 | 303492 | 2020-07-05 | Jackson | Illinois | 17077 | 339 | 19 |
300328 | 300328 | 2020-07-04 | Jackson | Illinois | 17077 | 336 | 19 |
297166 | 297166 | 2020-07-03 | Jackson | Illinois | 17077 | 335 | 19 |
294009 | 294009 | 2020-07-02 | Jackson | Illinois | 17077 | 333 | 19 |
290855 | 290855 | 2020-07-01 | Jackson | Illinois | 17077 | 332 | 19 |
287705 | 287705 | 2020-06-30 | Jackson | Illinois | 17077 | 332 | 19 |
284556 | 284556 | 2020-06-29 | Jackson | Illinois | 17077 | 329 | 19 |
281411 | 281411 | 2020-06-28 | Jackson | Illinois | 17077 | 329 | 19 |
278263 | 278263 | 2020-06-27 | Jackson | Illinois | 17077 | 329 | 19 |
275115 | 275115 | 2020-06-26 | Jackson | Illinois | 17077 | 329 | 19 |
271973 | 271973 | 2020-06-25 | Jackson | Illinois | 17077 | 328 | 19 |
268836 | 268836 | 2020-06-24 | Jackson | Illinois | 17077 | 325 | 19 |
265706 | 265706 | 2020-06-23 | Jackson | Illinois | 17077 | 325 | 18 |
262578 | 262578 | 2020-06-22 | Jackson | Illinois | 17077 | 324 | 18 |
259451 | 259451 | 2020-06-21 | Jackson | Illinois | 17077 | 323 | 18 |
256325 | 256325 | 2020-06-20 | Jackson | Illinois | 17077 | 322 | 18 |
253205 | 253205 | 2020-06-19 | Jackson | Illinois | 17077 | 321 | 18 |
250090 | 250090 | 2020-06-18 | Jackson | Illinois | 17077 | 321 | 18 |
246978 | 246978 | 2020-06-17 | Jackson | Illinois | 17077 | 321 | 18 |
243865 | 243865 | 2020-06-16 | Jackson | Illinois | 17077 | 320 | 15 |
240754 | 240754 | 2020-06-15 | Jackson | Illinois | 17077 | 317 | 13 |
237646 | 237646 | 2020-06-14 | Jackson | Illinois | 17077 | 315 | 13 |
234539 | 234539 | 2020-06-13 | Jackson | Illinois | 17077 | 313 | 13 |
231433 | 231433 | 2020-06-12 | Jackson | Illinois | 17077 | 311 | 12 |
228330 | 228330 | 2020-06-11 | Jackson | Illinois | 17077 | 307 | 12 |
225228 | 225228 | 2020-06-10 | Jackson | Illinois | 17077 | 307 | 11 |
222133 | 222133 | 2020-06-09 | Jackson | Illinois | 17077 | 304 | 11 |
219038 | 219038 | 2020-06-08 | Jackson | Illinois | 17077 | 301 | 11 |
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);