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

785 rows where county = "Genesee" 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 · 785 ✖

fips 1

county 1

  • Genesee · 785 ✖
Link rowid date ▲ county state fips cases deaths
2501445 2501445 2022-05-13 Genesee New York 36037 14395 187
2498187 2498187 2022-05-12 Genesee New York 36037 14395 187
2494929 2494929 2022-05-11 Genesee New York 36037 14363 187
2491671 2491671 2022-05-10 Genesee New York 36037 14331 187
2488413 2488413 2022-05-09 Genesee New York 36037 14304 187
2485156 2485156 2022-05-08 Genesee New York 36037 14281 187
2481898 2481898 2022-05-07 Genesee New York 36037 14255 187
2478640 2478640 2022-05-06 Genesee New York 36037 14230 187
2475382 2475382 2022-05-05 Genesee New York 36037 14207 187
2472125 2472125 2022-05-04 Genesee New York 36037 14181 187
2468869 2468869 2022-05-03 Genesee New York 36037 14150 186
2465613 2465613 2022-05-02 Genesee New York 36037 14126 186
2462358 2462358 2022-05-01 Genesee New York 36037 14102 186
2459102 2459102 2022-04-30 Genesee New York 36037 14085 186
2455846 2455846 2022-04-29 Genesee New York 36037 14063 186
2452590 2452590 2022-04-28 Genesee New York 36037 14038 186
2449334 2449334 2022-04-27 Genesee New York 36037 14001 185
2446077 2446077 2022-04-26 Genesee New York 36037 13972 185
2442822 2442822 2022-04-25 Genesee New York 36037 13950 185
2439566 2439566 2022-04-24 Genesee New York 36037 13929 185
2436310 2436310 2022-04-23 Genesee New York 36037 13894 185
2433054 2433054 2022-04-22 Genesee New York 36037 13874 185
2429798 2429798 2022-04-21 Genesee New York 36037 13847 185
2426542 2426542 2022-04-20 Genesee New York 36037 13824 185
2423286 2423286 2022-04-19 Genesee New York 36037 13801 185
2420029 2420029 2022-04-18 Genesee New York 36037 13793 185
2416774 2416774 2022-04-17 Genesee New York 36037 13772 185
2413518 2413518 2022-04-16 Genesee New York 36037 13761 185
2410262 2410262 2022-04-15 Genesee New York 36037 13752 185
2407006 2407006 2022-04-14 Genesee New York 36037 13733 185
2403750 2403750 2022-04-13 Genesee New York 36037 13715 185
2400495 2400495 2022-04-12 Genesee New York 36037 13703 185
2397240 2397240 2022-04-11 Genesee New York 36037 13701 185
2393985 2393985 2022-04-10 Genesee New York 36037 13697 185
2390729 2390729 2022-04-09 Genesee New York 36037 13685 185
2387473 2387473 2022-04-08 Genesee New York 36037 13677 185
2384218 2384218 2022-04-07 Genesee New York 36037 13669 185
2380963 2380963 2022-04-06 Genesee New York 36037 13655 185
2377708 2377708 2022-04-05 Genesee New York 36037 13651 184
2374455 2374455 2022-04-04 Genesee New York 36037 13649 184
2371203 2371203 2022-04-03 Genesee New York 36037 13642 184
2367950 2367950 2022-04-02 Genesee New York 36037 13641 184
2364697 2364697 2022-04-01 Genesee New York 36037 13632 184
2361443 2361443 2022-03-31 Genesee New York 36037 13627 184
2358189 2358189 2022-03-30 Genesee New York 36037 13620 184
2354935 2354935 2022-03-29 Genesee New York 36037 13615 184
2351682 2351682 2022-03-28 Genesee New York 36037 13611 184
2348430 2348430 2022-03-27 Genesee New York 36037 13611 184
2345177 2345177 2022-03-26 Genesee New York 36037 13610 184
2341924 2341924 2022-03-25 Genesee New York 36037 13600 184
2338671 2338671 2022-03-24 Genesee New York 36037 13597 184
2335417 2335417 2022-03-23 Genesee New York 36037 13594 184
2332163 2332163 2022-03-22 Genesee New York 36037 13589 184
2328910 2328910 2022-03-21 Genesee New York 36037 13588 184
2325658 2325658 2022-03-20 Genesee New York 36037 13588 184
2322405 2322405 2022-03-19 Genesee New York 36037 13588 184
2319151 2319151 2022-03-18 Genesee New York 36037 13584 184
2315897 2315897 2022-03-17 Genesee New York 36037 13578 184
2312644 2312644 2022-03-16 Genesee New York 36037 13574 184
2309391 2309391 2022-03-15 Genesee New York 36037 13568 184
2306138 2306138 2022-03-14 Genesee New York 36037 13566 184
2302887 2302887 2022-03-13 Genesee New York 36037 13564 184
2299635 2299635 2022-03-12 Genesee New York 36037 13559 184
2296383 2296383 2022-03-11 Genesee New York 36037 13558 184
2293131 2293131 2022-03-10 Genesee New York 36037 13553 184
2289879 2289879 2022-03-09 Genesee New York 36037 13548 184
2286627 2286627 2022-03-08 Genesee New York 36037 13544 184
2283375 2283375 2022-03-07 Genesee New York 36037 13542 184
2280123 2280123 2022-03-06 Genesee New York 36037 13541 184
2276870 2276870 2022-03-05 Genesee New York 36037 13540 184
2273617 2273617 2022-03-04 Genesee New York 36037 13535 184
2270364 2270364 2022-03-03 Genesee New York 36037 13535 184
2267112 2267112 2022-03-02 Genesee New York 36037 13530 184
2263860 2263860 2022-03-01 Genesee New York 36037 13528 183
2260609 2260609 2022-02-28 Genesee New York 36037 13526 183
2257358 2257358 2022-02-27 Genesee New York 36037 13521 183
2254107 2254107 2022-02-26 Genesee New York 36037 13516 183
2250856 2250856 2022-02-25 Genesee New York 36037 13512 182
2247605 2247605 2022-02-24 Genesee New York 36037 13511 182
2244354 2244354 2022-02-23 Genesee New York 36037 13507 182
2241103 2241103 2022-02-22 Genesee New York 36037 13502 182
2237852 2237852 2022-02-21 Genesee New York 36037 13496 182
2234601 2234601 2022-02-20 Genesee New York 36037 13492 182
2231350 2231350 2022-02-19 Genesee New York 36037 13490 182
2228099 2228099 2022-02-18 Genesee New York 36037 13478 182
2224848 2224848 2022-02-17 Genesee New York 36037 13466 182
2221597 2221597 2022-02-16 Genesee New York 36037 13453 182
2218346 2218346 2022-02-15 Genesee New York 36037 13440 182
2215095 2215095 2022-02-14 Genesee New York 36037 13427 181
2211844 2211844 2022-02-13 Genesee New York 36037 13417 181
2208591 2208591 2022-02-12 Genesee New York 36037 13410 181
2205338 2205338 2022-02-11 Genesee New York 36037 13393 181
2202085 2202085 2022-02-10 Genesee New York 36037 13380 181
2198831 2198831 2022-02-09 Genesee New York 36037 13351 181
2195577 2195577 2022-02-08 Genesee New York 36037 13335 181
2192323 2192323 2022-02-07 Genesee New York 36037 13323 180
2189069 2189069 2022-02-06 Genesee New York 36037 13317 179
2185816 2185816 2022-02-05 Genesee New York 36037 13304 179
2182564 2182564 2022-02-04 Genesee New York 36037 13273 179
2179312 2179312 2022-02-03 Genesee New York 36037 13241 177

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