ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Lake" and fips = 18089 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
272082 | 272082 | 2020-06-25 | Lake | Indiana | 18089 | 4633 | 254 |
275224 | 275224 | 2020-06-26 | Lake | Indiana | 18089 | 4687 | 254 |
278372 | 278372 | 2020-06-27 | Lake | Indiana | 18089 | 4733 | 255 |
281520 | 281520 | 2020-06-28 | Lake | Indiana | 18089 | 4778 | 255 |
284665 | 284665 | 2020-06-29 | Lake | Indiana | 18089 | 4818 | 255 |
287814 | 287814 | 2020-06-30 | Lake | Indiana | 18089 | 4884 | 255 |
290964 | 290964 | 2020-07-01 | Lake | Indiana | 18089 | 4910 | 256 |
294118 | 294118 | 2020-07-02 | Lake | Indiana | 18089 | 5023 | 257 |
297276 | 297276 | 2020-07-03 | Lake | Indiana | 18089 | 5091 | 258 |
300438 | 300438 | 2020-07-04 | Lake | Indiana | 18089 | 5142 | 258 |
303602 | 303602 | 2020-07-05 | Lake | Indiana | 18089 | 5184 | 258 |
306767 | 306767 | 2020-07-06 | Lake | Indiana | 18089 | 5219 | 258 |
309935 | 309935 | 2020-07-07 | Lake | Indiana | 18089 | 5251 | 260 |
313105 | 313105 | 2020-07-08 | Lake | Indiana | 18089 | 5315 | 262 |
316279 | 316279 | 2020-07-09 | Lake | Indiana | 18089 | 5376 | 263 |
319452 | 319452 | 2020-07-10 | Lake | Indiana | 18089 | 5471 | 264 |
322631 | 322631 | 2020-07-11 | Lake | Indiana | 18089 | 5627 | 264 |
325812 | 325812 | 2020-07-12 | Lake | Indiana | 18089 | 5689 | 265 |
328998 | 328998 | 2020-07-13 | Lake | Indiana | 18089 | 5716 | 265 |
332185 | 332185 | 2020-07-14 | Lake | Indiana | 18089 | 5803 | 267 |
335378 | 335378 | 2020-07-15 | Lake | Indiana | 18089 | 5870 | 268 |
338574 | 338574 | 2020-07-16 | Lake | Indiana | 18089 | 5958 | 268 |
341770 | 341770 | 2020-07-17 | Lake | Indiana | 18089 | 6022 | 268 |
344970 | 344970 | 2020-07-18 | Lake | Indiana | 18089 | 6122 | 270 |
348171 | 348171 | 2020-07-19 | Lake | Indiana | 18089 | 6184 | 270 |
351371 | 351371 | 2020-07-20 | Lake | Indiana | 18089 | 6262 | 270 |
354573 | 354573 | 2020-07-21 | Lake | Indiana | 18089 | 6316 | 272 |
357775 | 357775 | 2020-07-22 | Lake | Indiana | 18089 | 6418 | 274 |
360980 | 360980 | 2020-07-23 | Lake | Indiana | 18089 | 6507 | 275 |
364187 | 364187 | 2020-07-24 | Lake | Indiana | 18089 | 6564 | 276 |
367394 | 367394 | 2020-07-25 | Lake | Indiana | 18089 | 6628 | 281 |
370604 | 370604 | 2020-07-26 | Lake | Indiana | 18089 | 6716 | 281 |
373816 | 373816 | 2020-07-27 | Lake | Indiana | 18089 | 6769 | 281 |
377031 | 377031 | 2020-07-28 | Lake | Indiana | 18089 | 6829 | 282 |
380248 | 380248 | 2020-07-29 | Lake | Indiana | 18089 | 6861 | 282 |
383465 | 383465 | 2020-07-30 | Lake | Indiana | 18089 | 6919 | 282 |
386683 | 386683 | 2020-07-31 | Lake | Indiana | 18089 | 6977 | 283 |
389900 | 389900 | 2020-08-01 | Lake | Indiana | 18089 | 7037 | 285 |
393117 | 393117 | 2020-08-02 | Lake | Indiana | 18089 | 7080 | 285 |
396333 | 396333 | 2020-08-03 | Lake | Indiana | 18089 | 7144 | 287 |
399549 | 399549 | 2020-08-04 | Lake | Indiana | 18089 | 7182 | 289 |
402765 | 402765 | 2020-08-05 | Lake | Indiana | 18089 | 7264 | 289 |
405983 | 405983 | 2020-08-06 | Lake | Indiana | 18089 | 7385 | 290 |
409203 | 409203 | 2020-08-07 | Lake | Indiana | 18089 | 7489 | 290 |
412422 | 412422 | 2020-08-08 | Lake | Indiana | 18089 | 7538 | 291 |
415642 | 415642 | 2020-08-09 | Lake | Indiana | 18089 | 7613 | 291 |
418863 | 418863 | 2020-08-10 | Lake | Indiana | 18089 | 7674 | 291 |
422086 | 422086 | 2020-08-11 | Lake | Indiana | 18089 | 7732 | 294 |
425307 | 425307 | 2020-08-12 | Lake | Indiana | 18089 | 7789 | 298 |
428531 | 428531 | 2020-08-13 | Lake | Indiana | 18089 | 7888 | 300 |
431759 | 431759 | 2020-08-14 | Lake | Indiana | 18089 | 8003 | 300 |
434984 | 434984 | 2020-08-15 | Lake | Indiana | 18089 | 8083 | 300 |
438210 | 438210 | 2020-08-16 | Lake | Indiana | 18089 | 8147 | 300 |
441436 | 441436 | 2020-08-17 | Lake | Indiana | 18089 | 8231 | 301 |
444662 | 444662 | 2020-08-18 | Lake | Indiana | 18089 | 8316 | 303 |
447889 | 447889 | 2020-08-19 | Lake | Indiana | 18089 | 8357 | 304 |
451117 | 451117 | 2020-08-20 | Lake | Indiana | 18089 | 8415 | 305 |
454345 | 454345 | 2020-08-21 | Lake | Indiana | 18089 | 8497 | 306 |
457573 | 457573 | 2020-08-22 | Lake | Indiana | 18089 | 8583 | 308 |
460800 | 460800 | 2020-08-23 | Lake | Indiana | 18089 | 8653 | 310 |
464029 | 464029 | 2020-08-24 | Lake | Indiana | 18089 | 8760 | 310 |
467258 | 467258 | 2020-08-25 | Lake | Indiana | 18089 | 8804 | 310 |
470487 | 470487 | 2020-08-26 | Lake | Indiana | 18089 | 8859 | 311 |
473719 | 473719 | 2020-08-27 | Lake | Indiana | 18089 | 8932 | 311 |
476952 | 476952 | 2020-08-28 | Lake | Indiana | 18089 | 9005 | 312 |
480185 | 480185 | 2020-08-29 | Lake | Indiana | 18089 | 9084 | 313 |
483419 | 483419 | 2020-08-30 | Lake | Indiana | 18089 | 9135 | 314 |
486654 | 486654 | 2020-08-31 | Lake | Indiana | 18089 | 9203 | 314 |
489887 | 489887 | 2020-09-01 | Lake | Indiana | 18089 | 9233 | 315 |
493120 | 493120 | 2020-09-02 | Lake | Indiana | 18089 | 9266 | 316 |
496354 | 496354 | 2020-09-03 | Lake | Indiana | 18089 | 9335 | 316 |
499587 | 499587 | 2020-09-04 | Lake | Indiana | 18089 | 9406 | 316 |
502821 | 502821 | 2020-09-05 | Lake | Indiana | 18089 | 9490 | 316 |
506055 | 506055 | 2020-09-06 | Lake | Indiana | 18089 | 9546 | 316 |
509287 | 509287 | 2020-09-07 | Lake | Indiana | 18089 | 9604 | 316 |
512520 | 512520 | 2020-09-08 | Lake | Indiana | 18089 | 9628 | 317 |
515753 | 515753 | 2020-09-09 | Lake | Indiana | 18089 | 9662 | 319 |
518988 | 518988 | 2020-09-10 | Lake | Indiana | 18089 | 9709 | 322 |
522225 | 522225 | 2020-09-11 | Lake | Indiana | 18089 | 9793 | 325 |
525461 | 525461 | 2020-09-12 | Lake | Indiana | 18089 | 9852 | 326 |
528697 | 528697 | 2020-09-13 | Lake | Indiana | 18089 | 9913 | 326 |
531934 | 531934 | 2020-09-14 | Lake | Indiana | 18089 | 9963 | 326 |
535169 | 535169 | 2020-09-15 | Lake | Indiana | 18089 | 10000 | 327 |
538405 | 538405 | 2020-09-16 | Lake | Indiana | 18089 | 10017 | 330 |
541642 | 541642 | 2020-09-17 | Lake | Indiana | 18089 | 10074 | 330 |
544878 | 544878 | 2020-09-18 | Lake | Indiana | 18089 | 10156 | 333 |
548116 | 548116 | 2020-09-19 | Lake | Indiana | 18089 | 10232 | 335 |
551355 | 551355 | 2020-09-20 | Lake | Indiana | 18089 | 10277 | 336 |
554594 | 554594 | 2020-09-21 | Lake | Indiana | 18089 | 10324 | 337 |
557831 | 557831 | 2020-09-22 | Lake | Indiana | 18089 | 10352 | 336 |
561067 | 561067 | 2020-09-23 | Lake | Indiana | 18089 | 10394 | 337 |
564307 | 564307 | 2020-09-24 | Lake | Indiana | 18089 | 10459 | 339 |
567547 | 567547 | 2020-09-25 | Lake | Indiana | 18089 | 10555 | 341 |
570789 | 570789 | 2020-09-26 | Lake | Indiana | 18089 | 10628 | 341 |
574032 | 574032 | 2020-09-27 | Lake | Indiana | 18089 | 10680 | 341 |
577274 | 577274 | 2020-09-28 | Lake | Indiana | 18089 | 10750 | 341 |
580515 | 580515 | 2020-09-29 | Lake | Indiana | 18089 | 10807 | 342 |
583754 | 583754 | 2020-09-30 | Lake | Indiana | 18089 | 10834 | 343 |
586994 | 586994 | 2020-10-01 | Lake | Indiana | 18089 | 10931 | 345 |
590235 | 590235 | 2020-10-02 | Lake | Indiana | 18089 | 11047 | 345 |
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);