ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Jefferson" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535061 | 535061 | 2020-09-15 | Jefferson | Illinois | 17081 | 521 | 37 |
531826 | 531826 | 2020-09-14 | Jefferson | Illinois | 17081 | 519 | 37 |
528589 | 528589 | 2020-09-13 | Jefferson | Illinois | 17081 | 513 | 37 |
525353 | 525353 | 2020-09-12 | Jefferson | Illinois | 17081 | 509 | 37 |
522117 | 522117 | 2020-09-11 | Jefferson | Illinois | 17081 | 504 | 37 |
518880 | 518880 | 2020-09-10 | Jefferson | Illinois | 17081 | 502 | 37 |
515645 | 515645 | 2020-09-09 | Jefferson | Illinois | 17081 | 499 | 37 |
512412 | 512412 | 2020-09-08 | Jefferson | Illinois | 17081 | 499 | 37 |
509179 | 509179 | 2020-09-07 | Jefferson | Illinois | 17081 | 498 | 37 |
505947 | 505947 | 2020-09-06 | Jefferson | Illinois | 17081 | 487 | 36 |
502713 | 502713 | 2020-09-05 | Jefferson | Illinois | 17081 | 486 | 35 |
499479 | 499479 | 2020-09-04 | Jefferson | Illinois | 17081 | 479 | 35 |
496246 | 496246 | 2020-09-03 | Jefferson | Illinois | 17081 | 470 | 35 |
493012 | 493012 | 2020-09-02 | Jefferson | Illinois | 17081 | 463 | 35 |
489779 | 489779 | 2020-09-01 | Jefferson | Illinois | 17081 | 462 | 34 |
486546 | 486546 | 2020-08-31 | Jefferson | Illinois | 17081 | 457 | 34 |
483311 | 483311 | 2020-08-30 | Jefferson | Illinois | 17081 | 455 | 34 |
480077 | 480077 | 2020-08-29 | Jefferson | Illinois | 17081 | 447 | 34 |
476844 | 476844 | 2020-08-28 | Jefferson | Illinois | 17081 | 442 | 34 |
473611 | 473611 | 2020-08-27 | Jefferson | Illinois | 17081 | 434 | 33 |
470379 | 470379 | 2020-08-26 | Jefferson | Illinois | 17081 | 416 | 31 |
467150 | 467150 | 2020-08-25 | Jefferson | Illinois | 17081 | 411 | 31 |
463921 | 463921 | 2020-08-24 | Jefferson | Illinois | 17081 | 402 | 31 |
460692 | 460692 | 2020-08-23 | Jefferson | Illinois | 17081 | 392 | 31 |
457465 | 457465 | 2020-08-22 | Jefferson | Illinois | 17081 | 384 | 31 |
454237 | 454237 | 2020-08-21 | Jefferson | Illinois | 17081 | 376 | 31 |
451009 | 451009 | 2020-08-20 | Jefferson | Illinois | 17081 | 369 | 31 |
447781 | 447781 | 2020-08-19 | Jefferson | Illinois | 17081 | 360 | 26 |
444554 | 444554 | 2020-08-18 | Jefferson | Illinois | 17081 | 357 | 24 |
441328 | 441328 | 2020-08-17 | Jefferson | Illinois | 17081 | 356 | 22 |
438102 | 438102 | 2020-08-16 | Jefferson | Illinois | 17081 | 353 | 20 |
434876 | 434876 | 2020-08-15 | Jefferson | Illinois | 17081 | 345 | 20 |
431651 | 431651 | 2020-08-14 | Jefferson | Illinois | 17081 | 320 | 20 |
428423 | 428423 | 2020-08-13 | Jefferson | Illinois | 17081 | 317 | 20 |
425199 | 425199 | 2020-08-12 | Jefferson | Illinois | 17081 | 304 | 20 |
421978 | 421978 | 2020-08-11 | Jefferson | Illinois | 17081 | 292 | 19 |
418755 | 418755 | 2020-08-10 | Jefferson | Illinois | 17081 | 290 | 19 |
415534 | 415534 | 2020-08-09 | Jefferson | Illinois | 17081 | 286 | 19 |
412314 | 412314 | 2020-08-08 | Jefferson | Illinois | 17081 | 282 | 19 |
409095 | 409095 | 2020-08-07 | Jefferson | Illinois | 17081 | 247 | 19 |
405875 | 405875 | 2020-08-06 | Jefferson | Illinois | 17081 | 218 | 19 |
402657 | 402657 | 2020-08-05 | Jefferson | Illinois | 17081 | 213 | 19 |
399441 | 399441 | 2020-08-04 | Jefferson | Illinois | 17081 | 191 | 17 |
396225 | 396225 | 2020-08-03 | Jefferson | Illinois | 17081 | 192 | 17 |
393009 | 393009 | 2020-08-02 | Jefferson | Illinois | 17081 | 187 | 17 |
389792 | 389792 | 2020-08-01 | Jefferson | Illinois | 17081 | 184 | 17 |
386575 | 386575 | 2020-07-31 | Jefferson | Illinois | 17081 | 176 | 17 |
383357 | 383357 | 2020-07-30 | Jefferson | Illinois | 17081 | 171 | 17 |
380140 | 380140 | 2020-07-29 | Jefferson | Illinois | 17081 | 169 | 17 |
376923 | 376923 | 2020-07-28 | Jefferson | Illinois | 17081 | 163 | 17 |
373708 | 373708 | 2020-07-27 | Jefferson | Illinois | 17081 | 162 | 17 |
370496 | 370496 | 2020-07-26 | Jefferson | Illinois | 17081 | 155 | 17 |
367286 | 367286 | 2020-07-25 | Jefferson | Illinois | 17081 | 153 | 17 |
364079 | 364079 | 2020-07-24 | Jefferson | Illinois | 17081 | 151 | 17 |
360872 | 360872 | 2020-07-23 | Jefferson | Illinois | 17081 | 142 | 17 |
357667 | 357667 | 2020-07-22 | Jefferson | Illinois | 17081 | 138 | 17 |
354465 | 354465 | 2020-07-21 | Jefferson | Illinois | 17081 | 137 | 17 |
351263 | 351263 | 2020-07-20 | Jefferson | Illinois | 17081 | 136 | 17 |
348063 | 348063 | 2020-07-19 | Jefferson | Illinois | 17081 | 130 | 17 |
344862 | 344862 | 2020-07-18 | Jefferson | Illinois | 17081 | 127 | 17 |
341662 | 341662 | 2020-07-17 | Jefferson | Illinois | 17081 | 125 | 17 |
338466 | 338466 | 2020-07-16 | Jefferson | Illinois | 17081 | 124 | 17 |
335270 | 335270 | 2020-07-15 | Jefferson | Illinois | 17081 | 123 | 17 |
332077 | 332077 | 2020-07-14 | Jefferson | Illinois | 17081 | 117 | 17 |
328890 | 328890 | 2020-07-13 | Jefferson | Illinois | 17081 | 115 | 17 |
325704 | 325704 | 2020-07-12 | Jefferson | Illinois | 17081 | 114 | 17 |
322523 | 322523 | 2020-07-11 | Jefferson | Illinois | 17081 | 114 | 17 |
319344 | 319344 | 2020-07-10 | Jefferson | Illinois | 17081 | 115 | 17 |
316171 | 316171 | 2020-07-09 | Jefferson | Illinois | 17081 | 113 | 17 |
312997 | 312997 | 2020-07-08 | Jefferson | Illinois | 17081 | 111 | 17 |
309827 | 309827 | 2020-07-07 | Jefferson | Illinois | 17081 | 107 | 17 |
306659 | 306659 | 2020-07-06 | Jefferson | Illinois | 17081 | 107 | 17 |
303494 | 303494 | 2020-07-05 | Jefferson | Illinois | 17081 | 107 | 17 |
300330 | 300330 | 2020-07-04 | Jefferson | Illinois | 17081 | 106 | 17 |
297168 | 297168 | 2020-07-03 | Jefferson | Illinois | 17081 | 106 | 17 |
294011 | 294011 | 2020-07-02 | Jefferson | Illinois | 17081 | 107 | 17 |
290857 | 290857 | 2020-07-01 | Jefferson | Illinois | 17081 | 107 | 17 |
287707 | 287707 | 2020-06-30 | Jefferson | Illinois | 17081 | 107 | 17 |
284558 | 284558 | 2020-06-29 | Jefferson | Illinois | 17081 | 107 | 17 |
281413 | 281413 | 2020-06-28 | Jefferson | Illinois | 17081 | 106 | 17 |
278265 | 278265 | 2020-06-27 | Jefferson | Illinois | 17081 | 106 | 17 |
275117 | 275117 | 2020-06-26 | Jefferson | Illinois | 17081 | 105 | 17 |
271975 | 271975 | 2020-06-25 | Jefferson | Illinois | 17081 | 105 | 17 |
268838 | 268838 | 2020-06-24 | Jefferson | Illinois | 17081 | 107 | 17 |
265708 | 265708 | 2020-06-23 | Jefferson | Illinois | 17081 | 104 | 17 |
262580 | 262580 | 2020-06-22 | Jefferson | Illinois | 17081 | 104 | 16 |
259453 | 259453 | 2020-06-21 | Jefferson | Illinois | 17081 | 104 | 16 |
256327 | 256327 | 2020-06-20 | Jefferson | Illinois | 17081 | 104 | 16 |
253207 | 253207 | 2020-06-19 | Jefferson | Illinois | 17081 | 104 | 16 |
250092 | 250092 | 2020-06-18 | Jefferson | Illinois | 17081 | 104 | 16 |
246980 | 246980 | 2020-06-17 | Jefferson | Illinois | 17081 | 104 | 16 |
243867 | 243867 | 2020-06-16 | Jefferson | Illinois | 17081 | 104 | 16 |
240756 | 240756 | 2020-06-15 | Jefferson | Illinois | 17081 | 104 | 16 |
237648 | 237648 | 2020-06-14 | Jefferson | Illinois | 17081 | 104 | 16 |
234541 | 234541 | 2020-06-13 | Jefferson | Illinois | 17081 | 103 | 16 |
231435 | 231435 | 2020-06-12 | Jefferson | Illinois | 17081 | 103 | 16 |
228332 | 228332 | 2020-06-11 | Jefferson | Illinois | 17081 | 101 | 16 |
225230 | 225230 | 2020-06-10 | Jefferson | Illinois | 17081 | 101 | 16 |
222135 | 222135 | 2020-06-09 | Jefferson | Illinois | 17081 | 101 | 16 |
219040 | 219040 | 2020-06-08 | Jefferson | Illinois | 17081 | 101 | 16 |
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);