ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
162 rows where county = "Lawrence", deaths = 0, fips = 17101 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535071 | 535071 | 2020-09-15 | Lawrence | Illinois | 17101 | 235 | 0 |
531836 | 531836 | 2020-09-14 | Lawrence | Illinois | 17101 | 235 | 0 |
528599 | 528599 | 2020-09-13 | Lawrence | Illinois | 17101 | 233 | 0 |
525363 | 525363 | 2020-09-12 | Lawrence | Illinois | 17101 | 225 | 0 |
522127 | 522127 | 2020-09-11 | Lawrence | Illinois | 17101 | 210 | 0 |
518890 | 518890 | 2020-09-10 | Lawrence | Illinois | 17101 | 207 | 0 |
515655 | 515655 | 2020-09-09 | Lawrence | Illinois | 17101 | 206 | 0 |
512422 | 512422 | 2020-09-08 | Lawrence | Illinois | 17101 | 205 | 0 |
509189 | 509189 | 2020-09-07 | Lawrence | Illinois | 17101 | 199 | 0 |
505957 | 505957 | 2020-09-06 | Lawrence | Illinois | 17101 | 196 | 0 |
502723 | 502723 | 2020-09-05 | Lawrence | Illinois | 17101 | 193 | 0 |
499489 | 499489 | 2020-09-04 | Lawrence | Illinois | 17101 | 175 | 0 |
496256 | 496256 | 2020-09-03 | Lawrence | Illinois | 17101 | 142 | 0 |
493022 | 493022 | 2020-09-02 | Lawrence | Illinois | 17101 | 142 | 0 |
489789 | 489789 | 2020-09-01 | Lawrence | Illinois | 17101 | 136 | 0 |
486556 | 486556 | 2020-08-31 | Lawrence | Illinois | 17101 | 137 | 0 |
483321 | 483321 | 2020-08-30 | Lawrence | Illinois | 17101 | 135 | 0 |
480087 | 480087 | 2020-08-29 | Lawrence | Illinois | 17101 | 111 | 0 |
476854 | 476854 | 2020-08-28 | Lawrence | Illinois | 17101 | 96 | 0 |
473621 | 473621 | 2020-08-27 | Lawrence | Illinois | 17101 | 93 | 0 |
470389 | 470389 | 2020-08-26 | Lawrence | Illinois | 17101 | 89 | 0 |
467160 | 467160 | 2020-08-25 | Lawrence | Illinois | 17101 | 89 | 0 |
463931 | 463931 | 2020-08-24 | Lawrence | Illinois | 17101 | 87 | 0 |
460702 | 460702 | 2020-08-23 | Lawrence | Illinois | 17101 | 81 | 0 |
457475 | 457475 | 2020-08-22 | Lawrence | Illinois | 17101 | 80 | 0 |
454247 | 454247 | 2020-08-21 | Lawrence | Illinois | 17101 | 75 | 0 |
451019 | 451019 | 2020-08-20 | Lawrence | Illinois | 17101 | 74 | 0 |
447791 | 447791 | 2020-08-19 | Lawrence | Illinois | 17101 | 68 | 0 |
444564 | 444564 | 2020-08-18 | Lawrence | Illinois | 17101 | 67 | 0 |
441338 | 441338 | 2020-08-17 | Lawrence | Illinois | 17101 | 65 | 0 |
438112 | 438112 | 2020-08-16 | Lawrence | Illinois | 17101 | 62 | 0 |
434886 | 434886 | 2020-08-15 | Lawrence | Illinois | 17101 | 58 | 0 |
431661 | 431661 | 2020-08-14 | Lawrence | Illinois | 17101 | 55 | 0 |
428433 | 428433 | 2020-08-13 | Lawrence | Illinois | 17101 | 52 | 0 |
425209 | 425209 | 2020-08-12 | Lawrence | Illinois | 17101 | 51 | 0 |
421988 | 421988 | 2020-08-11 | Lawrence | Illinois | 17101 | 51 | 0 |
418765 | 418765 | 2020-08-10 | Lawrence | Illinois | 17101 | 50 | 0 |
415544 | 415544 | 2020-08-09 | Lawrence | Illinois | 17101 | 47 | 0 |
412324 | 412324 | 2020-08-08 | Lawrence | Illinois | 17101 | 48 | 0 |
409105 | 409105 | 2020-08-07 | Lawrence | Illinois | 17101 | 45 | 0 |
405885 | 405885 | 2020-08-06 | Lawrence | Illinois | 17101 | 44 | 0 |
402667 | 402667 | 2020-08-05 | Lawrence | Illinois | 17101 | 44 | 0 |
399451 | 399451 | 2020-08-04 | Lawrence | Illinois | 17101 | 43 | 0 |
396235 | 396235 | 2020-08-03 | Lawrence | Illinois | 17101 | 42 | 0 |
393019 | 393019 | 2020-08-02 | Lawrence | Illinois | 17101 | 42 | 0 |
389802 | 389802 | 2020-08-01 | Lawrence | Illinois | 17101 | 40 | 0 |
386585 | 386585 | 2020-07-31 | Lawrence | Illinois | 17101 | 40 | 0 |
383367 | 383367 | 2020-07-30 | Lawrence | Illinois | 17101 | 41 | 0 |
380150 | 380150 | 2020-07-29 | Lawrence | Illinois | 17101 | 39 | 0 |
376933 | 376933 | 2020-07-28 | Lawrence | Illinois | 17101 | 38 | 0 |
373718 | 373718 | 2020-07-27 | Lawrence | Illinois | 17101 | 37 | 0 |
370506 | 370506 | 2020-07-26 | Lawrence | Illinois | 17101 | 35 | 0 |
367296 | 367296 | 2020-07-25 | Lawrence | Illinois | 17101 | 34 | 0 |
364089 | 364089 | 2020-07-24 | Lawrence | Illinois | 17101 | 32 | 0 |
360882 | 360882 | 2020-07-23 | Lawrence | Illinois | 17101 | 32 | 0 |
357677 | 357677 | 2020-07-22 | Lawrence | Illinois | 17101 | 30 | 0 |
354475 | 354475 | 2020-07-21 | Lawrence | Illinois | 17101 | 28 | 0 |
351273 | 351273 | 2020-07-20 | Lawrence | Illinois | 17101 | 27 | 0 |
348073 | 348073 | 2020-07-19 | Lawrence | Illinois | 17101 | 23 | 0 |
344872 | 344872 | 2020-07-18 | Lawrence | Illinois | 17101 | 21 | 0 |
341672 | 341672 | 2020-07-17 | Lawrence | Illinois | 17101 | 18 | 0 |
338476 | 338476 | 2020-07-16 | Lawrence | Illinois | 17101 | 16 | 0 |
335280 | 335280 | 2020-07-15 | Lawrence | Illinois | 17101 | 13 | 0 |
332087 | 332087 | 2020-07-14 | Lawrence | Illinois | 17101 | 13 | 0 |
328900 | 328900 | 2020-07-13 | Lawrence | Illinois | 17101 | 12 | 0 |
325714 | 325714 | 2020-07-12 | Lawrence | Illinois | 17101 | 12 | 0 |
322533 | 322533 | 2020-07-11 | Lawrence | Illinois | 17101 | 12 | 0 |
319354 | 319354 | 2020-07-10 | Lawrence | Illinois | 17101 | 9 | 0 |
316181 | 316181 | 2020-07-09 | Lawrence | Illinois | 17101 | 8 | 0 |
313007 | 313007 | 2020-07-08 | Lawrence | Illinois | 17101 | 8 | 0 |
309837 | 309837 | 2020-07-07 | Lawrence | Illinois | 17101 | 8 | 0 |
306669 | 306669 | 2020-07-06 | Lawrence | Illinois | 17101 | 7 | 0 |
303504 | 303504 | 2020-07-05 | Lawrence | Illinois | 17101 | 7 | 0 |
300340 | 300340 | 2020-07-04 | Lawrence | Illinois | 17101 | 7 | 0 |
297178 | 297178 | 2020-07-03 | Lawrence | Illinois | 17101 | 7 | 0 |
294021 | 294021 | 2020-07-02 | Lawrence | Illinois | 17101 | 7 | 0 |
290867 | 290867 | 2020-07-01 | Lawrence | Illinois | 17101 | 7 | 0 |
287717 | 287717 | 2020-06-30 | Lawrence | Illinois | 17101 | 7 | 0 |
284568 | 284568 | 2020-06-29 | Lawrence | Illinois | 17101 | 7 | 0 |
281423 | 281423 | 2020-06-28 | Lawrence | Illinois | 17101 | 7 | 0 |
278275 | 278275 | 2020-06-27 | Lawrence | Illinois | 17101 | 7 | 0 |
275127 | 275127 | 2020-06-26 | Lawrence | Illinois | 17101 | 6 | 0 |
271985 | 271985 | 2020-06-25 | Lawrence | Illinois | 17101 | 6 | 0 |
268848 | 268848 | 2020-06-24 | Lawrence | Illinois | 17101 | 6 | 0 |
265718 | 265718 | 2020-06-23 | Lawrence | Illinois | 17101 | 5 | 0 |
262590 | 262590 | 2020-06-22 | Lawrence | Illinois | 17101 | 5 | 0 |
259463 | 259463 | 2020-06-21 | Lawrence | Illinois | 17101 | 5 | 0 |
256337 | 256337 | 2020-06-20 | Lawrence | Illinois | 17101 | 5 | 0 |
253217 | 253217 | 2020-06-19 | Lawrence | Illinois | 17101 | 5 | 0 |
250102 | 250102 | 2020-06-18 | Lawrence | Illinois | 17101 | 5 | 0 |
246990 | 246990 | 2020-06-17 | Lawrence | Illinois | 17101 | 4 | 0 |
243877 | 243877 | 2020-06-16 | Lawrence | Illinois | 17101 | 4 | 0 |
240766 | 240766 | 2020-06-15 | Lawrence | Illinois | 17101 | 4 | 0 |
237658 | 237658 | 2020-06-14 | Lawrence | Illinois | 17101 | 4 | 0 |
234551 | 234551 | 2020-06-13 | Lawrence | Illinois | 17101 | 4 | 0 |
231445 | 231445 | 2020-06-12 | Lawrence | Illinois | 17101 | 4 | 0 |
228342 | 228342 | 2020-06-11 | Lawrence | Illinois | 17101 | 4 | 0 |
225240 | 225240 | 2020-06-10 | Lawrence | Illinois | 17101 | 4 | 0 |
222145 | 222145 | 2020-06-09 | Lawrence | Illinois | 17101 | 4 | 0 |
219050 | 219050 | 2020-06-08 | Lawrence | Illinois | 17101 | 4 | 0 |
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);