ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 34035 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
269951 | 269951 | 2020-06-24 | Somerset | New Jersey | 34035 | 4819 | 444 |
273090 | 273090 | 2020-06-25 | Somerset | New Jersey | 34035 | 4909 | 524 |
276235 | 276235 | 2020-06-26 | Somerset | New Jersey | 34035 | 4912 | 524 |
279383 | 279383 | 2020-06-27 | Somerset | New Jersey | 34035 | 4922 | 524 |
282530 | 282530 | 2020-06-28 | Somerset | New Jersey | 34035 | 4938 | 527 |
285675 | 285675 | 2020-06-29 | Somerset | New Jersey | 34035 | 4939 | 528 |
288825 | 288825 | 2020-06-30 | Somerset | New Jersey | 34035 | 4950 | 528 |
291977 | 291977 | 2020-07-01 | Somerset | New Jersey | 34035 | 4962 | 528 |
295132 | 295132 | 2020-07-02 | Somerset | New Jersey | 34035 | 4992 | 527 |
298292 | 298292 | 2020-07-03 | Somerset | New Jersey | 34035 | 4999 | 529 |
301455 | 301455 | 2020-07-04 | Somerset | New Jersey | 34035 | 5008 | 529 |
304618 | 304618 | 2020-07-05 | Somerset | New Jersey | 34035 | 5017 | 530 |
307785 | 307785 | 2020-07-06 | Somerset | New Jersey | 34035 | 5023 | 531 |
310953 | 310953 | 2020-07-07 | Somerset | New Jersey | 34035 | 5025 | 535 |
314124 | 314124 | 2020-07-08 | Somerset | New Jersey | 34035 | 5030 | 537 |
317298 | 317298 | 2020-07-09 | Somerset | New Jersey | 34035 | 5038 | 544 |
320474 | 320474 | 2020-07-10 | Somerset | New Jersey | 34035 | 5060 | 549 |
323654 | 323654 | 2020-07-11 | Somerset | New Jersey | 34035 | 5084 | 551 |
326838 | 326838 | 2020-07-12 | Somerset | New Jersey | 34035 | 5100 | 551 |
330025 | 330025 | 2020-07-13 | Somerset | New Jersey | 34035 | 5104 | 551 |
333215 | 333215 | 2020-07-14 | Somerset | New Jersey | 34035 | 5122 | 551 |
336409 | 336409 | 2020-07-15 | Somerset | New Jersey | 34035 | 5139 | 550 |
339605 | 339605 | 2020-07-16 | Somerset | New Jersey | 34035 | 5141 | 552 |
342803 | 342803 | 2020-07-17 | Somerset | New Jersey | 34035 | 5143 | 553 |
346002 | 346002 | 2020-07-18 | Somerset | New Jersey | 34035 | 5152 | 554 |
349203 | 349203 | 2020-07-19 | Somerset | New Jersey | 34035 | 5147 | 553 |
352406 | 352406 | 2020-07-20 | Somerset | New Jersey | 34035 | 5150 | 553 |
355609 | 355609 | 2020-07-21 | Somerset | New Jersey | 34035 | 5154 | 553 |
358813 | 358813 | 2020-07-22 | Somerset | New Jersey | 34035 | 5160 | 550 |
362019 | 362019 | 2020-07-23 | Somerset | New Jersey | 34035 | 5172 | 550 |
365225 | 365225 | 2020-07-24 | Somerset | New Jersey | 34035 | 5184 | 553 |
368434 | 368434 | 2020-07-25 | Somerset | New Jersey | 34035 | 5198 | 555 |
371646 | 371646 | 2020-07-26 | Somerset | New Jersey | 34035 | 5209 | 556 |
374858 | 374858 | 2020-07-27 | Somerset | New Jersey | 34035 | 5217 | 557 |
378073 | 378073 | 2020-07-28 | Somerset | New Jersey | 34035 | 5233 | 558 |
381291 | 381291 | 2020-07-29 | Somerset | New Jersey | 34035 | 5236 | 553 |
384509 | 384509 | 2020-07-30 | Somerset | New Jersey | 34035 | 5243 | 554 |
387726 | 387726 | 2020-07-31 | Somerset | New Jersey | 34035 | 5250 | 554 |
390942 | 390942 | 2020-08-01 | Somerset | New Jersey | 34035 | 5259 | 555 |
394159 | 394159 | 2020-08-02 | Somerset | New Jersey | 34035 | 5263 | 555 |
397376 | 397376 | 2020-08-03 | Somerset | New Jersey | 34035 | 5268 | 555 |
400591 | 400591 | 2020-08-04 | Somerset | New Jersey | 34035 | 5272 | 558 |
403809 | 403809 | 2020-08-05 | Somerset | New Jersey | 34035 | 5277 | 561 |
407028 | 407028 | 2020-08-06 | Somerset | New Jersey | 34035 | 5292 | 562 |
410248 | 410248 | 2020-08-07 | Somerset | New Jersey | 34035 | 5298 | 562 |
413468 | 413468 | 2020-08-08 | Somerset | New Jersey | 34035 | 5306 | 561 |
416689 | 416689 | 2020-08-09 | Somerset | New Jersey | 34035 | 5320 | 561 |
419909 | 419909 | 2020-08-10 | Somerset | New Jersey | 34035 | 5328 | 561 |
423132 | 423132 | 2020-08-11 | Somerset | New Jersey | 34035 | 5340 | 562 |
426355 | 426355 | 2020-08-12 | Somerset | New Jersey | 34035 | 5350 | 564 |
429579 | 429579 | 2020-08-13 | Somerset | New Jersey | 34035 | 5357 | 564 |
432806 | 432806 | 2020-08-14 | Somerset | New Jersey | 34035 | 5366 | 564 |
436032 | 436032 | 2020-08-15 | Somerset | New Jersey | 34035 | 5375 | 565 |
439257 | 439257 | 2020-08-16 | Somerset | New Jersey | 34035 | 5382 | 565 |
442484 | 442484 | 2020-08-17 | Somerset | New Jersey | 34035 | 5392 | 566 |
445710 | 445710 | 2020-08-18 | Somerset | New Jersey | 34035 | 5398 | 566 |
448937 | 448937 | 2020-08-19 | Somerset | New Jersey | 34035 | 5403 | 565 |
452166 | 452166 | 2020-08-20 | Somerset | New Jersey | 34035 | 5405 | 565 |
455394 | 455394 | 2020-08-21 | Somerset | New Jersey | 34035 | 5410 | 564 |
458621 | 458621 | 2020-08-22 | Somerset | New Jersey | 34035 | 5415 | 564 |
461849 | 461849 | 2020-08-23 | Somerset | New Jersey | 34035 | 5420 | 564 |
465079 | 465079 | 2020-08-24 | Somerset | New Jersey | 34035 | 5425 | 564 |
468307 | 468307 | 2020-08-25 | Somerset | New Jersey | 34035 | 5432 | 564 |
471539 | 471539 | 2020-08-26 | Somerset | New Jersey | 34035 | 5438 | 565 |
474773 | 474773 | 2020-08-27 | Somerset | New Jersey | 34035 | 5447 | 566 |
478006 | 478006 | 2020-08-28 | Somerset | New Jersey | 34035 | 5453 | 567 |
481238 | 481238 | 2020-08-29 | Somerset | New Jersey | 34035 | 5461 | 567 |
484473 | 484473 | 2020-08-30 | Somerset | New Jersey | 34035 | 5474 | 567 |
487707 | 487707 | 2020-08-31 | Somerset | New Jersey | 34035 | 5494 | 567 |
490940 | 490940 | 2020-09-01 | Somerset | New Jersey | 34035 | 5499 | 567 |
494174 | 494174 | 2020-09-02 | Somerset | New Jersey | 34035 | 5499 | 566 |
497407 | 497407 | 2020-09-03 | Somerset | New Jersey | 34035 | 5510 | 566 |
500641 | 500641 | 2020-09-04 | Somerset | New Jersey | 34035 | 5519 | 566 |
503875 | 503875 | 2020-09-05 | Somerset | New Jersey | 34035 | 5524 | 566 |
507107 | 507107 | 2020-09-06 | Somerset | New Jersey | 34035 | 5535 | 566 |
510340 | 510340 | 2020-09-07 | Somerset | New Jersey | 34035 | 5551 | 566 |
513573 | 513573 | 2020-09-08 | Somerset | New Jersey | 34035 | 5554 | 566 |
516807 | 516807 | 2020-09-09 | Somerset | New Jersey | 34035 | 5563 | 567 |
520042 | 520042 | 2020-09-10 | Somerset | New Jersey | 34035 | 5582 | 568 |
523279 | 523279 | 2020-09-11 | Somerset | New Jersey | 34035 | 5603 | 568 |
526515 | 526515 | 2020-09-12 | Somerset | New Jersey | 34035 | 5626 | 568 |
529751 | 529751 | 2020-09-13 | Somerset | New Jersey | 34035 | 5632 | 568 |
532987 | 532987 | 2020-09-14 | Somerset | New Jersey | 34035 | 5649 | 568 |
536222 | 536222 | 2020-09-15 | Somerset | New Jersey | 34035 | 5670 | 568 |
539459 | 539459 | 2020-09-16 | Somerset | New Jersey | 34035 | 5685 | 568 |
542696 | 542696 | 2020-09-17 | Somerset | New Jersey | 34035 | 5703 | 568 |
545933 | 545933 | 2020-09-18 | Somerset | New Jersey | 34035 | 5745 | 569 |
549171 | 549171 | 2020-09-19 | Somerset | New Jersey | 34035 | 5759 | 569 |
552410 | 552410 | 2020-09-20 | Somerset | New Jersey | 34035 | 5765 | 569 |
555648 | 555648 | 2020-09-21 | Somerset | New Jersey | 34035 | 5777 | 569 |
558885 | 558885 | 2020-09-22 | Somerset | New Jersey | 34035 | 5783 | 569 |
562122 | 562122 | 2020-09-23 | Somerset | New Jersey | 34035 | 5799 | 572 |
565363 | 565363 | 2020-09-24 | Somerset | New Jersey | 34035 | 5814 | 573 |
568604 | 568604 | 2020-09-25 | Somerset | New Jersey | 34035 | 5851 | 573 |
571846 | 571846 | 2020-09-26 | Somerset | New Jersey | 34035 | 5860 | 573 |
575089 | 575089 | 2020-09-27 | Somerset | New Jersey | 34035 | 5872 | 573 |
578330 | 578330 | 2020-09-28 | Somerset | New Jersey | 34035 | 5882 | 573 |
581571 | 581571 | 2020-09-29 | Somerset | New Jersey | 34035 | 5893 | 573 |
584812 | 584812 | 2020-09-30 | Somerset | New Jersey | 34035 | 5904 | 577 |
588052 | 588052 | 2020-10-01 | Somerset | New Jersey | 34035 | 5924 | 577 |
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);