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

793 rows where county = "Orange" 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 · 793 ✖

fips 1

county 1

  • Orange · 793 ✖
Link rowid date ▲ county state fips cases deaths
2501461 2501461 2022-05-13 Orange New York 36071 111228 954
2498203 2498203 2022-05-12 Orange New York 36071 111228 953
2494945 2494945 2022-05-11 Orange New York 36071 111001 953
2491687 2491687 2022-05-10 Orange New York 36071 110754 953
2488429 2488429 2022-05-09 Orange New York 36071 110607 953
2485172 2485172 2022-05-08 Orange New York 36071 110498 953
2481914 2481914 2022-05-07 Orange New York 36071 110336 953
2478656 2478656 2022-05-06 Orange New York 36071 110120 953
2475398 2475398 2022-05-05 Orange New York 36071 109911 953
2472141 2472141 2022-05-04 Orange New York 36071 109690 953
2468885 2468885 2022-05-03 Orange New York 36071 109534 953
2465629 2465629 2022-05-02 Orange New York 36071 109423 953
2462374 2462374 2022-05-01 Orange New York 36071 109333 953
2459118 2459118 2022-04-30 Orange New York 36071 109188 953
2455862 2455862 2022-04-29 Orange New York 36071 109048 953
2452606 2452606 2022-04-28 Orange New York 36071 108902 953
2449350 2449350 2022-04-27 Orange New York 36071 108749 952
2446093 2446093 2022-04-26 Orange New York 36071 108618 952
2442838 2442838 2022-04-25 Orange New York 36071 108525 952
2439582 2439582 2022-04-24 Orange New York 36071 108436 952
2436326 2436326 2022-04-23 Orange New York 36071 108338 950
2433070 2433070 2022-04-22 Orange New York 36071 108211 950
2429814 2429814 2022-04-21 Orange New York 36071 108107 950
2426558 2426558 2022-04-20 Orange New York 36071 107981 950
2423302 2423302 2022-04-19 Orange New York 36071 107873 950
2420045 2420045 2022-04-18 Orange New York 36071 107799 948
2416790 2416790 2022-04-17 Orange New York 36071 107724 948
2413534 2413534 2022-04-16 Orange New York 36071 107644 948
2410278 2410278 2022-04-15 Orange New York 36071 107565 948
2407022 2407022 2022-04-14 Orange New York 36071 107477 948
2403766 2403766 2022-04-13 Orange New York 36071 107374 948
2400511 2400511 2022-04-12 Orange New York 36071 107277 948
2397256 2397256 2022-04-11 Orange New York 36071 107208 948
2394001 2394001 2022-04-10 Orange New York 36071 107146 947
2390745 2390745 2022-04-09 Orange New York 36071 107062 947
2387489 2387489 2022-04-08 Orange New York 36071 106947 947
2384234 2384234 2022-04-07 Orange New York 36071 106843 947
2380979 2380979 2022-04-06 Orange New York 36071 106741 947
2377724 2377724 2022-04-05 Orange New York 36071 106643 947
2374471 2374471 2022-04-04 Orange New York 36071 106602 947
2371219 2371219 2022-04-03 Orange New York 36071 106560 947
2367966 2367966 2022-04-02 Orange New York 36071 106509 947
2364713 2364713 2022-04-01 Orange New York 36071 106450 947
2361459 2361459 2022-03-31 Orange New York 36071 106392 945
2358205 2358205 2022-03-30 Orange New York 36071 106338 945
2354951 2354951 2022-03-29 Orange New York 36071 106285 945
2351698 2351698 2022-03-28 Orange New York 36071 106250 945
2348446 2348446 2022-03-27 Orange New York 36071 106215 945
2345193 2345193 2022-03-26 Orange New York 36071 106146 945
2341940 2341940 2022-03-25 Orange New York 36071 106105 945
2338687 2338687 2022-03-24 Orange New York 36071 106064 945
2335433 2335433 2022-03-23 Orange New York 36071 106003 945
2332179 2332179 2022-03-22 Orange New York 36071 105960 945
2328926 2328926 2022-03-21 Orange New York 36071 105944 944
2325674 2325674 2022-03-20 Orange New York 36071 105931 944
2322421 2322421 2022-03-19 Orange New York 36071 105904 944
2319167 2319167 2022-03-18 Orange New York 36071 105885 944
2315913 2315913 2022-03-17 Orange New York 36071 105830 944
2312660 2312660 2022-03-16 Orange New York 36071 105823 944
2309407 2309407 2022-03-15 Orange New York 36071 105791 944
2306154 2306154 2022-03-14 Orange New York 36071 105775 944
2302903 2302903 2022-03-13 Orange New York 36071 105761 944
2299651 2299651 2022-03-12 Orange New York 36071 105731 943
2296399 2296399 2022-03-11 Orange New York 36071 105708 943
2293147 2293147 2022-03-10 Orange New York 36071 105677 943
2289895 2289895 2022-03-09 Orange New York 36071 105644 943
2286643 2286643 2022-03-08 Orange New York 36071 105620 942
2283391 2283391 2022-03-07 Orange New York 36071 105604 942
2280139 2280139 2022-03-06 Orange New York 36071 105581 942
2276886 2276886 2022-03-05 Orange New York 36071 105562 942
2273633 2273633 2022-03-04 Orange New York 36071 105421 942
2270380 2270380 2022-03-03 Orange New York 36071 105421 942
2267128 2267128 2022-03-02 Orange New York 36071 105389 940
2263876 2263876 2022-03-01 Orange New York 36071 105367 939
2260625 2260625 2022-02-28 Orange New York 36071 105343 939
2257374 2257374 2022-02-27 Orange New York 36071 105326 937
2254123 2254123 2022-02-26 Orange New York 36071 105300 936
2250872 2250872 2022-02-25 Orange New York 36071 105262 936
2247621 2247621 2022-02-24 Orange New York 36071 105216 935
2244370 2244370 2022-02-23 Orange New York 36071 105177 935
2241119 2241119 2022-02-22 Orange New York 36071 105129 934
2237868 2237868 2022-02-21 Orange New York 36071 105100 934
2234617 2234617 2022-02-20 Orange New York 36071 105078 933
2231366 2231366 2022-02-19 Orange New York 36071 105036 932
2228115 2228115 2022-02-18 Orange New York 36071 104966 932
2224864 2224864 2022-02-17 Orange New York 36071 104897 931
2221613 2221613 2022-02-16 Orange New York 36071 104825 931
2218362 2218362 2022-02-15 Orange New York 36071 104768 931
2215111 2215111 2022-02-14 Orange New York 36071 104720 930
2211860 2211860 2022-02-13 Orange New York 36071 104676 930
2208607 2208607 2022-02-12 Orange New York 36071 104615 929
2205354 2205354 2022-02-11 Orange New York 36071 104538 929
2202101 2202101 2022-02-10 Orange New York 36071 104436 927
2198847 2198847 2022-02-09 Orange New York 36071 104290 926
2195593 2195593 2022-02-08 Orange New York 36071 104154 925
2192339 2192339 2022-02-07 Orange New York 36071 104059 924
2189085 2189085 2022-02-06 Orange New York 36071 103987 922
2185832 2185832 2022-02-05 Orange New York 36071 103890 921
2182580 2182580 2022-02-04 Orange New York 36071 103742 921
2179328 2179328 2022-02-03 Orange New York 36071 103581 918

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