ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

791 rows where county = "Broome" and state = "New York" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • New York · 791 ✖

fips 1

county 1

  • Broome · 791 ✖
Link rowid date ▲ county state fips cases deaths
2501430 2501430 2022-05-13 Broome New York 36007 48947 520
2498172 2498172 2022-05-12 Broome New York 36007 48947 520
2494914 2494914 2022-05-11 Broome New York 36007 48812 519
2491656 2491656 2022-05-10 Broome New York 36007 48673 519
2488398 2488398 2022-05-09 Broome New York 36007 48549 519
2485141 2485141 2022-05-08 Broome New York 36007 48509 519
2481883 2481883 2022-05-07 Broome New York 36007 48437 519
2478625 2478625 2022-05-06 Broome New York 36007 48333 518
2475367 2475367 2022-05-05 Broome New York 36007 48205 518
2472110 2472110 2022-05-04 Broome New York 36007 48101 518
2468854 2468854 2022-05-03 Broome New York 36007 47978 518
2465598 2465598 2022-05-02 Broome New York 36007 47907 517
2462343 2462343 2022-05-01 Broome New York 36007 47864 517
2459087 2459087 2022-04-30 Broome New York 36007 47786 517
2455831 2455831 2022-04-29 Broome New York 36007 47677 517
2452575 2452575 2022-04-28 Broome New York 36007 47559 517
2449319 2449319 2022-04-27 Broome New York 36007 47388 517
2446062 2446062 2022-04-26 Broome New York 36007 47260 517
2442807 2442807 2022-04-25 Broome New York 36007 47197 517
2439551 2439551 2022-04-24 Broome New York 36007 47119 517
2436295 2436295 2022-04-23 Broome New York 36007 46998 517
2433039 2433039 2022-04-22 Broome New York 36007 46890 517
2429783 2429783 2022-04-21 Broome New York 36007 46771 517
2426527 2426527 2022-04-20 Broome New York 36007 46655 515
2423271 2423271 2022-04-19 Broome New York 36007 46526 515
2420014 2420014 2022-04-18 Broome New York 36007 46476 514
2416759 2416759 2022-04-17 Broome New York 36007 46409 514
2413503 2413503 2022-04-16 Broome New York 36007 46320 514
2410247 2410247 2022-04-15 Broome New York 36007 46194 514
2406991 2406991 2022-04-14 Broome New York 36007 46075 514
2403735 2403735 2022-04-13 Broome New York 36007 45968 514
2400480 2400480 2022-04-12 Broome New York 36007 45852 514
2397225 2397225 2022-04-11 Broome New York 36007 45808 514
2393970 2393970 2022-04-10 Broome New York 36007 45747 513
2390714 2390714 2022-04-09 Broome New York 36007 45651 513
2387458 2387458 2022-04-08 Broome New York 36007 45555 513
2384203 2384203 2022-04-07 Broome New York 36007 45450 513
2380948 2380948 2022-04-06 Broome New York 36007 45353 513
2377693 2377693 2022-04-05 Broome New York 36007 45258 513
2374440 2374440 2022-04-04 Broome New York 36007 45231 513
2371188 2371188 2022-04-03 Broome New York 36007 45197 512
2367935 2367935 2022-04-02 Broome New York 36007 45165 512
2364682 2364682 2022-04-01 Broome New York 36007 45114 511
2361428 2361428 2022-03-31 Broome New York 36007 45053 511
2358174 2358174 2022-03-30 Broome New York 36007 45024 511
2354920 2354920 2022-03-29 Broome New York 36007 44993 510
2351667 2351667 2022-03-28 Broome New York 36007 44975 510
2348415 2348415 2022-03-27 Broome New York 36007 44956 510
2345162 2345162 2022-03-26 Broome New York 36007 44924 510
2341909 2341909 2022-03-25 Broome New York 36007 44898 510
2338656 2338656 2022-03-24 Broome New York 36007 44870 510
2335402 2335402 2022-03-23 Broome New York 36007 44829 510
2332148 2332148 2022-03-22 Broome New York 36007 44787 510
2328895 2328895 2022-03-21 Broome New York 36007 44777 510
2325643 2325643 2022-03-20 Broome New York 36007 44771 510
2322390 2322390 2022-03-19 Broome New York 36007 44758 510
2319136 2319136 2022-03-18 Broome New York 36007 44737 510
2315882 2315882 2022-03-17 Broome New York 36007 44716 509
2312629 2312629 2022-03-16 Broome New York 36007 44694 509
2309376 2309376 2022-03-15 Broome New York 36007 44680 509
2306123 2306123 2022-03-14 Broome New York 36007 44667 509
2302872 2302872 2022-03-13 Broome New York 36007 44663 509
2299620 2299620 2022-03-12 Broome New York 36007 44636 508
2296368 2296368 2022-03-11 Broome New York 36007 44617 508
2293116 2293116 2022-03-10 Broome New York 36007 44584 508
2289864 2289864 2022-03-09 Broome New York 36007 44557 508
2286612 2286612 2022-03-08 Broome New York 36007 44529 508
2283360 2283360 2022-03-07 Broome New York 36007 44517 508
2280108 2280108 2022-03-06 Broome New York 36007 44512 508
2276855 2276855 2022-03-05 Broome New York 36007 44477 508
2273602 2273602 2022-03-04 Broome New York 36007 44408 508
2270349 2270349 2022-03-03 Broome New York 36007 44408 507
2267097 2267097 2022-03-02 Broome New York 36007 44381 506
2263845 2263845 2022-03-01 Broome New York 36007 44338 506
2260594 2260594 2022-02-28 Broome New York 36007 44325 506
2257343 2257343 2022-02-27 Broome New York 36007 44310 506
2254092 2254092 2022-02-26 Broome New York 36007 44291 505
2250841 2250841 2022-02-25 Broome New York 36007 44244 505
2247590 2247590 2022-02-24 Broome New York 36007 44204 503
2244339 2244339 2022-02-23 Broome New York 36007 44152 503
2241088 2241088 2022-02-22 Broome New York 36007 44095 503
2237837 2237837 2022-02-21 Broome New York 36007 44057 502
2234586 2234586 2022-02-20 Broome New York 36007 44028 502
2231335 2231335 2022-02-19 Broome New York 36007 43955 501
2228084 2228084 2022-02-18 Broome New York 36007 43897 501
2224833 2224833 2022-02-17 Broome New York 36007 43818 500
2221582 2221582 2022-02-16 Broome New York 36007 43739 499
2218331 2218331 2022-02-15 Broome New York 36007 43666 499
2215080 2215080 2022-02-14 Broome New York 36007 43620 499
2211829 2211829 2022-02-13 Broome New York 36007 43579 499
2208576 2208576 2022-02-12 Broome New York 36007 43514 499
2205323 2205323 2022-02-11 Broome New York 36007 43442 499
2202070 2202070 2022-02-10 Broome New York 36007 43340 499
2198816 2198816 2022-02-09 Broome New York 36007 43246 497
2195562 2195562 2022-02-08 Broome New York 36007 43143 497
2192308 2192308 2022-02-07 Broome New York 36007 43083 497
2189054 2189054 2022-02-06 Broome New York 36007 43021 497
2185801 2185801 2022-02-05 Broome New York 36007 42966 497
2182549 2182549 2022-02-04 Broome New York 36007 42873 495
2179297 2179297 2022-02-03 Broome New York 36007 42744 494

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);