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

776 rows where fips = 36049 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 · 776 ✖

fips 1

  • 36049 · 776 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501450 2501450 2022-05-13 Lewis New York 36049 6417 49
2498192 2498192 2022-05-12 Lewis New York 36049 6417 49
2494934 2494934 2022-05-11 Lewis New York 36049 6397 49
2491676 2491676 2022-05-10 Lewis New York 36049 6389 49
2488418 2488418 2022-05-09 Lewis New York 36049 6378 49
2485161 2485161 2022-05-08 Lewis New York 36049 6371 49
2481903 2481903 2022-05-07 Lewis New York 36049 6368 49
2478645 2478645 2022-05-06 Lewis New York 36049 6356 49
2475387 2475387 2022-05-05 Lewis New York 36049 6344 49
2472130 2472130 2022-05-04 Lewis New York 36049 6335 49
2468874 2468874 2022-05-03 Lewis New York 36049 6329 49
2465618 2465618 2022-05-02 Lewis New York 36049 6321 49
2462363 2462363 2022-05-01 Lewis New York 36049 6313 49
2459107 2459107 2022-04-30 Lewis New York 36049 6309 49
2455851 2455851 2022-04-29 Lewis New York 36049 6294 49
2452595 2452595 2022-04-28 Lewis New York 36049 6275 49
2449339 2449339 2022-04-27 Lewis New York 36049 6264 49
2446082 2446082 2022-04-26 Lewis New York 36049 6253 49
2442827 2442827 2022-04-25 Lewis New York 36049 6242 49
2439571 2439571 2022-04-24 Lewis New York 36049 6240 49
2436315 2436315 2022-04-23 Lewis New York 36049 6235 49
2433059 2433059 2022-04-22 Lewis New York 36049 6230 49
2429803 2429803 2022-04-21 Lewis New York 36049 6221 49
2426547 2426547 2022-04-20 Lewis New York 36049 6219 49
2423291 2423291 2022-04-19 Lewis New York 36049 6215 49
2420034 2420034 2022-04-18 Lewis New York 36049 6208 49
2416779 2416779 2022-04-17 Lewis New York 36049 6206 49
2413523 2413523 2022-04-16 Lewis New York 36049 6198 49
2410267 2410267 2022-04-15 Lewis New York 36049 6196 49
2407011 2407011 2022-04-14 Lewis New York 36049 6189 49
2403755 2403755 2022-04-13 Lewis New York 36049 6185 49
2400500 2400500 2022-04-12 Lewis New York 36049 6174 49
2397245 2397245 2022-04-11 Lewis New York 36049 6172 49
2393990 2393990 2022-04-10 Lewis New York 36049 6169 49
2390734 2390734 2022-04-09 Lewis New York 36049 6166 49
2387478 2387478 2022-04-08 Lewis New York 36049 6162 49
2384223 2384223 2022-04-07 Lewis New York 36049 6154 49
2380968 2380968 2022-04-06 Lewis New York 36049 6149 49
2377713 2377713 2022-04-05 Lewis New York 36049 6146 49
2374460 2374460 2022-04-04 Lewis New York 36049 6145 49
2371208 2371208 2022-04-03 Lewis New York 36049 6142 49
2367955 2367955 2022-04-02 Lewis New York 36049 6140 49
2364702 2364702 2022-04-01 Lewis New York 36049 6137 49
2361448 2361448 2022-03-31 Lewis New York 36049 6135 49
2358194 2358194 2022-03-30 Lewis New York 36049 6133 49
2354940 2354940 2022-03-29 Lewis New York 36049 6129 49
2351687 2351687 2022-03-28 Lewis New York 36049 6129 49
2348435 2348435 2022-03-27 Lewis New York 36049 6127 49
2345182 2345182 2022-03-26 Lewis New York 36049 6126 49
2341929 2341929 2022-03-25 Lewis New York 36049 6125 49
2338676 2338676 2022-03-24 Lewis New York 36049 6125 49
2335422 2335422 2022-03-23 Lewis New York 36049 6125 49
2332168 2332168 2022-03-22 Lewis New York 36049 6123 49
2328915 2328915 2022-03-21 Lewis New York 36049 6123 49
2325663 2325663 2022-03-20 Lewis New York 36049 6123 49
2322410 2322410 2022-03-19 Lewis New York 36049 6120 49
2319156 2319156 2022-03-18 Lewis New York 36049 6118 49
2315902 2315902 2022-03-17 Lewis New York 36049 6118 48
2312649 2312649 2022-03-16 Lewis New York 36049 6115 48
2309396 2309396 2022-03-15 Lewis New York 36049 6114 48
2306143 2306143 2022-03-14 Lewis New York 36049 6113 48
2302892 2302892 2022-03-13 Lewis New York 36049 6113 48
2299640 2299640 2022-03-12 Lewis New York 36049 6113 48
2296388 2296388 2022-03-11 Lewis New York 36049 6112 48
2293136 2293136 2022-03-10 Lewis New York 36049 6106 47
2289884 2289884 2022-03-09 Lewis New York 36049 6104 47
2286632 2286632 2022-03-08 Lewis New York 36049 6101 47
2283380 2283380 2022-03-07 Lewis New York 36049 6100 47
2280128 2280128 2022-03-06 Lewis New York 36049 6100 47
2276875 2276875 2022-03-05 Lewis New York 36049 6099 47
2273622 2273622 2022-03-04 Lewis New York 36049 6095 47
2270369 2270369 2022-03-03 Lewis New York 36049 6095 47
2267117 2267117 2022-03-02 Lewis New York 36049 6092 47
2263865 2263865 2022-03-01 Lewis New York 36049 6087 47
2260614 2260614 2022-02-28 Lewis New York 36049 6087 47
2257363 2257363 2022-02-27 Lewis New York 36049 6085 47
2254112 2254112 2022-02-26 Lewis New York 36049 6081 47
2250861 2250861 2022-02-25 Lewis New York 36049 6078 47
2247610 2247610 2022-02-24 Lewis New York 36049 6074 47
2244359 2244359 2022-02-23 Lewis New York 36049 6067 47
2241108 2241108 2022-02-22 Lewis New York 36049 6062 47
2237857 2237857 2022-02-21 Lewis New York 36049 6061 47
2234606 2234606 2022-02-20 Lewis New York 36049 6060 47
2231355 2231355 2022-02-19 Lewis New York 36049 6058 47
2228104 2228104 2022-02-18 Lewis New York 36049 6050 46
2224853 2224853 2022-02-17 Lewis New York 36049 6046 46
2221602 2221602 2022-02-16 Lewis New York 36049 6035 46
2218351 2218351 2022-02-15 Lewis New York 36049 6028 46
2215100 2215100 2022-02-14 Lewis New York 36049 6028 46
2211849 2211849 2022-02-13 Lewis New York 36049 6022 46
2208596 2208596 2022-02-12 Lewis New York 36049 6019 46
2205343 2205343 2022-02-11 Lewis New York 36049 6011 46
2202090 2202090 2022-02-10 Lewis New York 36049 6005 46
2198836 2198836 2022-02-09 Lewis New York 36049 5985 46
2195582 2195582 2022-02-08 Lewis New York 36049 5972 46
2192328 2192328 2022-02-07 Lewis New York 36049 5967 46
2189074 2189074 2022-02-06 Lewis New York 36049 5965 46
2185821 2185821 2022-02-05 Lewis New York 36049 5957 45
2182569 2182569 2022-02-04 Lewis New York 36049 5942 45
2179317 2179317 2022-02-03 Lewis New York 36049 5922 45

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