ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 34023 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 |
---|---|---|---|---|---|---|---|
536216 | 536216 | 2020-09-15 | Middlesex | New Jersey | 34023 | 19111 | 1423 |
532981 | 532981 | 2020-09-14 | Middlesex | New Jersey | 34023 | 19072 | 1422 |
529745 | 529745 | 2020-09-13 | Middlesex | New Jersey | 34023 | 19044 | 1422 |
526509 | 526509 | 2020-09-12 | Middlesex | New Jersey | 34023 | 19016 | 1422 |
523273 | 523273 | 2020-09-11 | Middlesex | New Jersey | 34023 | 18962 | 1422 |
520036 | 520036 | 2020-09-10 | Middlesex | New Jersey | 34023 | 18905 | 1423 |
516801 | 516801 | 2020-09-09 | Middlesex | New Jersey | 34023 | 18851 | 1421 |
513567 | 513567 | 2020-09-08 | Middlesex | New Jersey | 34023 | 18826 | 1420 |
510334 | 510334 | 2020-09-07 | Middlesex | New Jersey | 34023 | 18804 | 1419 |
507101 | 507101 | 2020-09-06 | Middlesex | New Jersey | 34023 | 18787 | 1419 |
503869 | 503869 | 2020-09-05 | Middlesex | New Jersey | 34023 | 18754 | 1419 |
500635 | 500635 | 2020-09-04 | Middlesex | New Jersey | 34023 | 18732 | 1418 |
497401 | 497401 | 2020-09-03 | Middlesex | New Jersey | 34023 | 18708 | 1418 |
494168 | 494168 | 2020-09-02 | Middlesex | New Jersey | 34023 | 18684 | 1417 |
490934 | 490934 | 2020-09-01 | Middlesex | New Jersey | 34023 | 18669 | 1417 |
487701 | 487701 | 2020-08-31 | Middlesex | New Jersey | 34023 | 18657 | 1418 |
484467 | 484467 | 2020-08-30 | Middlesex | New Jersey | 34023 | 18633 | 1418 |
481232 | 481232 | 2020-08-29 | Middlesex | New Jersey | 34023 | 18616 | 1418 |
478000 | 478000 | 2020-08-28 | Middlesex | New Jersey | 34023 | 18578 | 1417 |
474767 | 474767 | 2020-08-27 | Middlesex | New Jersey | 34023 | 18562 | 1417 |
471533 | 471533 | 2020-08-26 | Middlesex | New Jersey | 34023 | 18549 | 1416 |
468301 | 468301 | 2020-08-25 | Middlesex | New Jersey | 34023 | 18525 | 1421 |
465073 | 465073 | 2020-08-24 | Middlesex | New Jersey | 34023 | 18499 | 1420 |
461843 | 461843 | 2020-08-23 | Middlesex | New Jersey | 34023 | 18481 | 1420 |
458615 | 458615 | 2020-08-22 | Middlesex | New Jersey | 34023 | 18454 | 1420 |
455388 | 455388 | 2020-08-21 | Middlesex | New Jersey | 34023 | 18425 | 1419 |
452160 | 452160 | 2020-08-20 | Middlesex | New Jersey | 34023 | 18391 | 1418 |
448931 | 448931 | 2020-08-19 | Middlesex | New Jersey | 34023 | 18374 | 1418 |
445704 | 445704 | 2020-08-18 | Middlesex | New Jersey | 34023 | 18338 | 1416 |
442478 | 442478 | 2020-08-17 | Middlesex | New Jersey | 34023 | 18324 | 1415 |
439251 | 439251 | 2020-08-16 | Middlesex | New Jersey | 34023 | 18304 | 1415 |
436026 | 436026 | 2020-08-15 | Middlesex | New Jersey | 34023 | 18275 | 1414 |
432800 | 432800 | 2020-08-14 | Middlesex | New Jersey | 34023 | 18250 | 1412 |
429573 | 429573 | 2020-08-13 | Middlesex | New Jersey | 34023 | 18220 | 1411 |
426349 | 426349 | 2020-08-12 | Middlesex | New Jersey | 34023 | 18193 | 1409 |
423126 | 423126 | 2020-08-11 | Middlesex | New Jersey | 34023 | 18163 | 1408 |
419903 | 419903 | 2020-08-10 | Middlesex | New Jersey | 34023 | 18136 | 1403 |
416683 | 416683 | 2020-08-09 | Middlesex | New Jersey | 34023 | 18123 | 1403 |
413462 | 413462 | 2020-08-08 | Middlesex | New Jersey | 34023 | 18088 | 1403 |
410242 | 410242 | 2020-08-07 | Middlesex | New Jersey | 34023 | 18061 | 1401 |
407022 | 407022 | 2020-08-06 | Middlesex | New Jersey | 34023 | 18025 | 1401 |
403803 | 403803 | 2020-08-05 | Middlesex | New Jersey | 34023 | 18002 | 1400 |
400585 | 400585 | 2020-08-04 | Middlesex | New Jersey | 34023 | 17971 | 1403 |
397370 | 397370 | 2020-08-03 | Middlesex | New Jersey | 34023 | 17941 | 1403 |
394153 | 394153 | 2020-08-02 | Middlesex | New Jersey | 34023 | 17919 | 1404 |
390936 | 390936 | 2020-08-01 | Middlesex | New Jersey | 34023 | 17906 | 1404 |
387720 | 387720 | 2020-07-31 | Middlesex | New Jersey | 34023 | 17879 | 1404 |
384503 | 384503 | 2020-07-30 | Middlesex | New Jersey | 34023 | 17832 | 1403 |
381285 | 381285 | 2020-07-29 | Middlesex | New Jersey | 34023 | 17821 | 1403 |
378067 | 378067 | 2020-07-28 | Middlesex | New Jersey | 34023 | 17792 | 1408 |
374852 | 374852 | 2020-07-27 | Middlesex | New Jersey | 34023 | 17769 | 1404 |
371640 | 371640 | 2020-07-26 | Middlesex | New Jersey | 34023 | 17747 | 1402 |
368428 | 368428 | 2020-07-25 | Middlesex | New Jersey | 34023 | 17726 | 1399 |
365219 | 365219 | 2020-07-24 | Middlesex | New Jersey | 34023 | 17688 | 1398 |
362013 | 362013 | 2020-07-23 | Middlesex | New Jersey | 34023 | 17654 | 1396 |
358807 | 358807 | 2020-07-22 | Middlesex | New Jersey | 34023 | 17591 | 1392 |
355603 | 355603 | 2020-07-21 | Middlesex | New Jersey | 34023 | 17376 | 1400 |
352400 | 352400 | 2020-07-20 | Middlesex | New Jersey | 34023 | 17389 | 1397 |
349197 | 349197 | 2020-07-19 | Middlesex | New Jersey | 34023 | 17379 | 1397 |
345996 | 345996 | 2020-07-18 | Middlesex | New Jersey | 34023 | 17395 | 1398 |
342797 | 342797 | 2020-07-17 | Middlesex | New Jersey | 34023 | 17383 | 1397 |
339599 | 339599 | 2020-07-16 | Middlesex | New Jersey | 34023 | 17363 | 1397 |
336403 | 336403 | 2020-07-15 | Middlesex | New Jersey | 34023 | 17340 | 1395 |
333209 | 333209 | 2020-07-14 | Middlesex | New Jersey | 34023 | 17295 | 1379 |
330019 | 330019 | 2020-07-13 | Middlesex | New Jersey | 34023 | 17265 | 1377 |
326832 | 326832 | 2020-07-12 | Middlesex | New Jersey | 34023 | 17241 | 1375 |
323648 | 323648 | 2020-07-11 | Middlesex | New Jersey | 34023 | 17226 | 1375 |
320468 | 320468 | 2020-07-10 | Middlesex | New Jersey | 34023 | 17211 | 1366 |
317292 | 317292 | 2020-07-09 | Middlesex | New Jersey | 34023 | 17158 | 1361 |
314118 | 314118 | 2020-07-08 | Middlesex | New Jersey | 34023 | 17152 | 1348 |
310947 | 310947 | 2020-07-07 | Middlesex | New Jersey | 34023 | 17162 | 1338 |
307779 | 307779 | 2020-07-06 | Middlesex | New Jersey | 34023 | 17153 | 1333 |
304612 | 304612 | 2020-07-05 | Middlesex | New Jersey | 34023 | 17109 | 1331 |
301449 | 301449 | 2020-07-04 | Middlesex | New Jersey | 34023 | 17097 | 1330 |
298286 | 298286 | 2020-07-03 | Middlesex | New Jersey | 34023 | 17080 | 1328 |
295126 | 295126 | 2020-07-02 | Middlesex | New Jersey | 34023 | 17048 | 1323 |
291971 | 291971 | 2020-07-01 | Middlesex | New Jersey | 34023 | 17025 | 1324 |
288819 | 288819 | 2020-06-30 | Middlesex | New Jersey | 34023 | 17016 | 1322 |
285669 | 285669 | 2020-06-29 | Middlesex | New Jersey | 34023 | 16964 | 1319 |
282524 | 282524 | 2020-06-28 | Middlesex | New Jersey | 34023 | 16964 | 1318 |
279377 | 279377 | 2020-06-27 | Middlesex | New Jersey | 34023 | 16924 | 1317 |
276229 | 276229 | 2020-06-26 | Middlesex | New Jersey | 34023 | 16885 | 1310 |
273084 | 273084 | 2020-06-25 | Middlesex | New Jersey | 34023 | 16867 | 1307 |
269945 | 269945 | 2020-06-24 | Middlesex | New Jersey | 34023 | 16640 | 1107 |
266810 | 266810 | 2020-06-23 | Middlesex | New Jersey | 34023 | 16640 | 1104 |
263683 | 263683 | 2020-06-22 | Middlesex | New Jersey | 34023 | 16618 | 1101 |
260554 | 260554 | 2020-06-21 | Middlesex | New Jersey | 34023 | 16605 | 1101 |
257428 | 257428 | 2020-06-20 | Middlesex | New Jersey | 34023 | 16592 | 1100 |
254305 | 254305 | 2020-06-19 | Middlesex | New Jersey | 34023 | 16563 | 1097 |
251190 | 251190 | 2020-06-18 | Middlesex | New Jersey | 34023 | 16547 | 1094 |
248075 | 248075 | 2020-06-17 | Middlesex | New Jersey | 34023 | 16513 | 1094 |
244962 | 244962 | 2020-06-16 | Middlesex | New Jersey | 34023 | 16474 | 1085 |
241850 | 241850 | 2020-06-15 | Middlesex | New Jersey | 34023 | 16458 | 1083 |
238740 | 238740 | 2020-06-14 | Middlesex | New Jersey | 34023 | 16430 | 1076 |
235633 | 235633 | 2020-06-13 | Middlesex | New Jersey | 34023 | 16385 | 1074 |
232528 | 232528 | 2020-06-12 | Middlesex | New Jersey | 34023 | 16353 | 1070 |
229423 | 229423 | 2020-06-11 | Middlesex | New Jersey | 34023 | 16327 | 1069 |
226319 | 226319 | 2020-06-10 | Middlesex | New Jersey | 34023 | 16288 | 1064 |
223219 | 223219 | 2020-06-09 | Middlesex | New Jersey | 34023 | 16251 | 1053 |
220124 | 220124 | 2020-06-08 | Middlesex | New Jersey | 34023 | 16227 | 1043 |
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);