ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Warren" and state = "New Jersey" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636696 | 636696 | 2020-10-16 | Warren | New Jersey | 34041 | 1515 | 171 |
633450 | 633450 | 2020-10-15 | Warren | New Jersey | 34041 | 1508 | 171 |
630205 | 630205 | 2020-10-14 | Warren | New Jersey | 34041 | 1506 | 171 |
626961 | 626961 | 2020-10-13 | Warren | New Jersey | 34041 | 1501 | 171 |
623719 | 623719 | 2020-10-12 | Warren | New Jersey | 34041 | 1493 | 171 |
620476 | 620476 | 2020-10-11 | Warren | New Jersey | 34041 | 1493 | 171 |
617234 | 617234 | 2020-10-10 | Warren | New Jersey | 34041 | 1490 | 171 |
613992 | 613992 | 2020-10-09 | Warren | New Jersey | 34041 | 1485 | 171 |
610751 | 610751 | 2020-10-08 | Warren | New Jersey | 34041 | 1484 | 171 |
607509 | 607509 | 2020-10-07 | Warren | New Jersey | 34041 | 1478 | 171 |
604266 | 604266 | 2020-10-06 | Warren | New Jersey | 34041 | 1476 | 171 |
601024 | 601024 | 2020-10-05 | Warren | New Jersey | 34041 | 1474 | 171 |
597780 | 597780 | 2020-10-04 | Warren | New Jersey | 34041 | 1471 | 171 |
594538 | 594538 | 2020-10-03 | Warren | New Jersey | 34041 | 1469 | 171 |
591297 | 591297 | 2020-10-02 | Warren | New Jersey | 34041 | 1466 | 171 |
588056 | 588056 | 2020-10-01 | Warren | New Jersey | 34041 | 1462 | 171 |
584816 | 584816 | 2020-09-30 | Warren | New Jersey | 34041 | 1458 | 171 |
581575 | 581575 | 2020-09-29 | Warren | New Jersey | 34041 | 1458 | 171 |
578334 | 578334 | 2020-09-28 | Warren | New Jersey | 34041 | 1456 | 171 |
575093 | 575093 | 2020-09-27 | Warren | New Jersey | 34041 | 1454 | 171 |
571850 | 571850 | 2020-09-26 | Warren | New Jersey | 34041 | 1451 | 171 |
568608 | 568608 | 2020-09-25 | Warren | New Jersey | 34041 | 1448 | 171 |
565367 | 565367 | 2020-09-24 | Warren | New Jersey | 34041 | 1450 | 171 |
562126 | 562126 | 2020-09-23 | Warren | New Jersey | 34041 | 1449 | 171 |
558889 | 558889 | 2020-09-22 | Warren | New Jersey | 34041 | 1449 | 171 |
555652 | 555652 | 2020-09-21 | Warren | New Jersey | 34041 | 1446 | 171 |
552414 | 552414 | 2020-09-20 | Warren | New Jersey | 34041 | 1441 | 171 |
549175 | 549175 | 2020-09-19 | Warren | New Jersey | 34041 | 1441 | 171 |
545937 | 545937 | 2020-09-18 | Warren | New Jersey | 34041 | 1441 | 171 |
542700 | 542700 | 2020-09-17 | Warren | New Jersey | 34041 | 1437 | 171 |
539463 | 539463 | 2020-09-16 | Warren | New Jersey | 34041 | 1435 | 171 |
536226 | 536226 | 2020-09-15 | Warren | New Jersey | 34041 | 1438 | 171 |
532991 | 532991 | 2020-09-14 | Warren | New Jersey | 34041 | 1437 | 171 |
529755 | 529755 | 2020-09-13 | Warren | New Jersey | 34041 | 1431 | 171 |
526519 | 526519 | 2020-09-12 | Warren | New Jersey | 34041 | 1431 | 171 |
523283 | 523283 | 2020-09-11 | Warren | New Jersey | 34041 | 1428 | 171 |
520046 | 520046 | 2020-09-10 | Warren | New Jersey | 34041 | 1425 | 171 |
516811 | 516811 | 2020-09-09 | Warren | New Jersey | 34041 | 1423 | 171 |
513577 | 513577 | 2020-09-08 | Warren | New Jersey | 34041 | 1424 | 171 |
510344 | 510344 | 2020-09-07 | Warren | New Jersey | 34041 | 1421 | 171 |
507111 | 507111 | 2020-09-06 | Warren | New Jersey | 34041 | 1422 | 171 |
503879 | 503879 | 2020-09-05 | Warren | New Jersey | 34041 | 1417 | 171 |
500645 | 500645 | 2020-09-04 | Warren | New Jersey | 34041 | 1412 | 171 |
497411 | 497411 | 2020-09-03 | Warren | New Jersey | 34041 | 1412 | 171 |
494178 | 494178 | 2020-09-02 | Warren | New Jersey | 34041 | 1410 | 171 |
490944 | 490944 | 2020-09-01 | Warren | New Jersey | 34041 | 1410 | 171 |
487711 | 487711 | 2020-08-31 | Warren | New Jersey | 34041 | 1408 | 171 |
484477 | 484477 | 2020-08-30 | Warren | New Jersey | 34041 | 1405 | 171 |
481242 | 481242 | 2020-08-29 | Warren | New Jersey | 34041 | 1404 | 171 |
478010 | 478010 | 2020-08-28 | Warren | New Jersey | 34041 | 1403 | 171 |
474777 | 474777 | 2020-08-27 | Warren | New Jersey | 34041 | 1400 | 171 |
471543 | 471543 | 2020-08-26 | Warren | New Jersey | 34041 | 1397 | 171 |
468311 | 468311 | 2020-08-25 | Warren | New Jersey | 34041 | 1397 | 171 |
465083 | 465083 | 2020-08-24 | Warren | New Jersey | 34041 | 1394 | 171 |
461853 | 461853 | 2020-08-23 | Warren | New Jersey | 34041 | 1394 | 171 |
458625 | 458625 | 2020-08-22 | Warren | New Jersey | 34041 | 1392 | 171 |
455398 | 455398 | 2020-08-21 | Warren | New Jersey | 34041 | 1390 | 171 |
452170 | 452170 | 2020-08-20 | Warren | New Jersey | 34041 | 1390 | 171 |
448941 | 448941 | 2020-08-19 | Warren | New Jersey | 34041 | 1386 | 171 |
445714 | 445714 | 2020-08-18 | Warren | New Jersey | 34041 | 1384 | 172 |
442488 | 442488 | 2020-08-17 | Warren | New Jersey | 34041 | 1382 | 172 |
439261 | 439261 | 2020-08-16 | Warren | New Jersey | 34041 | 1379 | 172 |
436036 | 436036 | 2020-08-15 | Warren | New Jersey | 34041 | 1376 | 172 |
432810 | 432810 | 2020-08-14 | Warren | New Jersey | 34041 | 1369 | 172 |
429583 | 429583 | 2020-08-13 | Warren | New Jersey | 34041 | 1366 | 172 |
426359 | 426359 | 2020-08-12 | Warren | New Jersey | 34041 | 1361 | 172 |
423136 | 423136 | 2020-08-11 | Warren | New Jersey | 34041 | 1361 | 172 |
419913 | 419913 | 2020-08-10 | Warren | New Jersey | 34041 | 1359 | 172 |
416693 | 416693 | 2020-08-09 | Warren | New Jersey | 34041 | 1359 | 172 |
413472 | 413472 | 2020-08-08 | Warren | New Jersey | 34041 | 1357 | 172 |
410252 | 410252 | 2020-08-07 | Warren | New Jersey | 34041 | 1354 | 171 |
407032 | 407032 | 2020-08-06 | Warren | New Jersey | 34041 | 1353 | 171 |
403813 | 403813 | 2020-08-05 | Warren | New Jersey | 34041 | 1350 | 171 |
400595 | 400595 | 2020-08-04 | Warren | New Jersey | 34041 | 1345 | 171 |
397380 | 397380 | 2020-08-03 | Warren | New Jersey | 34041 | 1344 | 171 |
394163 | 394163 | 2020-08-02 | Warren | New Jersey | 34041 | 1344 | 171 |
390946 | 390946 | 2020-08-01 | Warren | New Jersey | 34041 | 1343 | 170 |
387730 | 387730 | 2020-07-31 | Warren | New Jersey | 34041 | 1343 | 170 |
384513 | 384513 | 2020-07-30 | Warren | New Jersey | 34041 | 1340 | 170 |
381295 | 381295 | 2020-07-29 | Warren | New Jersey | 34041 | 1341 | 171 |
378077 | 378077 | 2020-07-28 | Warren | New Jersey | 34041 | 1335 | 170 |
374862 | 374862 | 2020-07-27 | Warren | New Jersey | 34041 | 1329 | 170 |
371650 | 371650 | 2020-07-26 | Warren | New Jersey | 34041 | 1326 | 169 |
368438 | 368438 | 2020-07-25 | Warren | New Jersey | 34041 | 1322 | 169 |
365229 | 365229 | 2020-07-24 | Warren | New Jersey | 34041 | 1316 | 169 |
362023 | 362023 | 2020-07-23 | Warren | New Jersey | 34041 | 1310 | 169 |
358817 | 358817 | 2020-07-22 | Warren | New Jersey | 34041 | 1309 | 169 |
355613 | 355613 | 2020-07-21 | Warren | New Jersey | 34041 | 1303 | 172 |
352410 | 352410 | 2020-07-20 | Warren | New Jersey | 34041 | 1297 | 171 |
349207 | 349207 | 2020-07-19 | Warren | New Jersey | 34041 | 1293 | 171 |
346006 | 346006 | 2020-07-18 | Warren | New Jersey | 34041 | 1290 | 171 |
342807 | 342807 | 2020-07-17 | Warren | New Jersey | 34041 | 1289 | 171 |
339609 | 339609 | 2020-07-16 | Warren | New Jersey | 34041 | 1285 | 171 |
336413 | 336413 | 2020-07-15 | Warren | New Jersey | 34041 | 1284 | 170 |
333219 | 333219 | 2020-07-14 | Warren | New Jersey | 34041 | 1281 | 167 |
330029 | 330029 | 2020-07-13 | Warren | New Jersey | 34041 | 1279 | 167 |
326842 | 326842 | 2020-07-12 | Warren | New Jersey | 34041 | 1279 | 167 |
323658 | 323658 | 2020-07-11 | Warren | New Jersey | 34041 | 1277 | 167 |
320478 | 320478 | 2020-07-10 | Warren | New Jersey | 34041 | 1276 | 167 |
317302 | 317302 | 2020-07-09 | Warren | New Jersey | 34041 | 1275 | 167 |
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);