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

789 rows where county = "Onondaga" 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 · 789 ✖

fips 1

county 1

  • Onondaga · 789 ✖
Link rowid date ▲ county state fips cases deaths
2501459 2501459 2022-05-13 Onondaga New York 36067 121727 1073
2498201 2498201 2022-05-12 Onondaga New York 36067 121727 1073
2494943 2494943 2022-05-11 Onondaga New York 36067 121517 1073
2491685 2491685 2022-05-10 Onondaga New York 36067 121351 1072
2488427 2488427 2022-05-09 Onondaga New York 36067 121238 1072
2485170 2485170 2022-05-08 Onondaga New York 36067 121096 1071
2481912 2481912 2022-05-07 Onondaga New York 36067 120905 1069
2478654 2478654 2022-05-06 Onondaga New York 36067 120720 1068
2475396 2475396 2022-05-05 Onondaga New York 36067 120457 1066
2472139 2472139 2022-05-04 Onondaga New York 36067 120191 1065
2468883 2468883 2022-05-03 Onondaga New York 36067 119941 1065
2465627 2465627 2022-05-02 Onondaga New York 36067 119809 1064
2462372 2462372 2022-05-01 Onondaga New York 36067 119644 1063
2459116 2459116 2022-04-30 Onondaga New York 36067 119467 1062
2455860 2455860 2022-04-29 Onondaga New York 36067 119268 1060
2452604 2452604 2022-04-28 Onondaga New York 36067 118997 1060
2449348 2449348 2022-04-27 Onondaga New York 36067 118676 1058
2446091 2446091 2022-04-26 Onondaga New York 36067 118381 1056
2442836 2442836 2022-04-25 Onondaga New York 36067 118231 1055
2439580 2439580 2022-04-24 Onondaga New York 36067 118031 1053
2436324 2436324 2022-04-23 Onondaga New York 36067 117831 1051
2433068 2433068 2022-04-22 Onondaga New York 36067 117542 1051
2429812 2429812 2022-04-21 Onondaga New York 36067 117302 1049
2426556 2426556 2022-04-20 Onondaga New York 36067 116954 1048
2423300 2423300 2022-04-19 Onondaga New York 36067 116674 1048
2420043 2420043 2022-04-18 Onondaga New York 36067 116493 1047
2416788 2416788 2022-04-17 Onondaga New York 36067 116313 1047
2413532 2413532 2022-04-16 Onondaga New York 36067 116097 1047
2410276 2410276 2022-04-15 Onondaga New York 36067 115777 1047
2407020 2407020 2022-04-14 Onondaga New York 36067 115487 1047
2403764 2403764 2022-04-13 Onondaga New York 36067 115150 1047
2400509 2400509 2022-04-12 Onondaga New York 36067 114864 1047
2397254 2397254 2022-04-11 Onondaga New York 36067 114684 1047
2393999 2393999 2022-04-10 Onondaga New York 36067 114488 1047
2390743 2390743 2022-04-09 Onondaga New York 36067 114262 1046
2387487 2387487 2022-04-08 Onondaga New York 36067 114017 1046
2384232 2384232 2022-04-07 Onondaga New York 36067 113728 1046
2380977 2380977 2022-04-06 Onondaga New York 36067 113427 1046
2377722 2377722 2022-04-05 Onondaga New York 36067 113177 1046
2374469 2374469 2022-04-04 Onondaga New York 36067 113021 1044
2371217 2371217 2022-04-03 Onondaga New York 36067 112866 1043
2367964 2367964 2022-04-02 Onondaga New York 36067 112687 1042
2364711 2364711 2022-04-01 Onondaga New York 36067 112463 1042
2361457 2361457 2022-03-31 Onondaga New York 36067 112251 1040
2358203 2358203 2022-03-30 Onondaga New York 36067 111793 1040
2354949 2354949 2022-03-29 Onondaga New York 36067 111597 1040
2351696 2351696 2022-03-28 Onondaga New York 36067 111323 1040
2348444 2348444 2022-03-27 Onondaga New York 36067 111161 1040
2345191 2345191 2022-03-26 Onondaga New York 36067 110947 1040
2341938 2341938 2022-03-25 Onondaga New York 36067 110775 1039
2338685 2338685 2022-03-24 Onondaga New York 36067 110504 1039
2335431 2335431 2022-03-23 Onondaga New York 36067 110228 1039
2332177 2332177 2022-03-22 Onondaga New York 36067 109846 1038
2328924 2328924 2022-03-21 Onondaga New York 36067 109618 1038
2325672 2325672 2022-03-20 Onondaga New York 36067 109547 1038
2322419 2322419 2022-03-19 Onondaga New York 36067 109421 1038
2319165 2319165 2022-03-18 Onondaga New York 36067 109206 1038
2315911 2315911 2022-03-17 Onondaga New York 36067 109088 1038
2312658 2312658 2022-03-16 Onondaga New York 36067 108851 1038
2309405 2309405 2022-03-15 Onondaga New York 36067 108734 1037
2306152 2306152 2022-03-14 Onondaga New York 36067 108543 1037
2302901 2302901 2022-03-13 Onondaga New York 36067 108500 1036
2299649 2299649 2022-03-12 Onondaga New York 36067 108353 1036
2296397 2296397 2022-03-11 Onondaga New York 36067 108272 1036
2293145 2293145 2022-03-10 Onondaga New York 36067 108097 1036
2289893 2289893 2022-03-09 Onondaga New York 36067 108013 1035
2286641 2286641 2022-03-08 Onondaga New York 36067 107847 1033
2283389 2283389 2022-03-07 Onondaga New York 36067 107756 1032
2280137 2280137 2022-03-06 Onondaga New York 36067 107706 1031
2276884 2276884 2022-03-05 Onondaga New York 36067 107652 1031
2273631 2273631 2022-03-04 Onondaga New York 36067 107408 1030
2270378 2270378 2022-03-03 Onondaga New York 36067 107408 1030
2267126 2267126 2022-03-02 Onondaga New York 36067 107268 1029
2263874 2263874 2022-03-01 Onondaga New York 36067 107100 1029
2260623 2260623 2022-02-28 Onondaga New York 36067 107001 1029
2257372 2257372 2022-02-27 Onondaga New York 36067 106938 1027
2254121 2254121 2022-02-26 Onondaga New York 36067 106883 1025
2250870 2250870 2022-02-25 Onondaga New York 36067 106793 1023
2247619 2247619 2022-02-24 Onondaga New York 36067 106670 1022
2244368 2244368 2022-02-23 Onondaga New York 36067 106548 1022
2241117 2241117 2022-02-22 Onondaga New York 36067 106442 1021
2237866 2237866 2022-02-21 Onondaga New York 36067 106365 1021
2234615 2234615 2022-02-20 Onondaga New York 36067 106307 1019
2231364 2231364 2022-02-19 Onondaga New York 36067 106211 1016
2228113 2228113 2022-02-18 Onondaga New York 36067 106091 1015
2224862 2224862 2022-02-17 Onondaga New York 36067 105917 1012
2221611 2221611 2022-02-16 Onondaga New York 36067 105776 1010
2218360 2218360 2022-02-15 Onondaga New York 36067 105589 1010
2215109 2215109 2022-02-14 Onondaga New York 36067 105492 1009
2211858 2211858 2022-02-13 Onondaga New York 36067 105413 1006
2208605 2208605 2022-02-12 Onondaga New York 36067 105247 1003
2205352 2205352 2022-02-11 Onondaga New York 36067 105048 1003
2202099 2202099 2022-02-10 Onondaga New York 36067 104897 997
2198845 2198845 2022-02-09 Onondaga New York 36067 104657 995
2195591 2195591 2022-02-08 Onondaga New York 36067 104412 992
2192337 2192337 2022-02-07 Onondaga New York 36067 104107 989
2189083 2189083 2022-02-06 Onondaga New York 36067 103968 989
2185830 2185830 2022-02-05 Onondaga New York 36067 103840 988
2182578 2182578 2022-02-04 Onondaga New York 36067 103496 985
2179326 2179326 2022-02-03 Onondaga New York 36067 103195 983

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