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

788 rows where county = "Sullivan" 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 · 788 ✖

fips 1

county 1

  • Sullivan · 788 ✖
Link rowid date ▲ county state fips cases deaths
2501476 2501476 2022-05-13 Sullivan New York 36105 19217 130
2498218 2498218 2022-05-12 Sullivan New York 36105 19217 130
2494960 2494960 2022-05-11 Sullivan New York 36105 19175 130
2491702 2491702 2022-05-10 Sullivan New York 36105 19130 130
2488444 2488444 2022-05-09 Sullivan New York 36105 19116 130
2485187 2485187 2022-05-08 Sullivan New York 36105 19098 130
2481929 2481929 2022-05-07 Sullivan New York 36105 19070 130
2478671 2478671 2022-05-06 Sullivan New York 36105 19025 130
2475413 2475413 2022-05-05 Sullivan New York 36105 19003 130
2472156 2472156 2022-05-04 Sullivan New York 36105 18977 130
2468900 2468900 2022-05-03 Sullivan New York 36105 18949 130
2465644 2465644 2022-05-02 Sullivan New York 36105 18926 130
2462389 2462389 2022-05-01 Sullivan New York 36105 18910 130
2459133 2459133 2022-04-30 Sullivan New York 36105 18890 130
2455877 2455877 2022-04-29 Sullivan New York 36105 18861 130
2452621 2452621 2022-04-28 Sullivan New York 36105 18830 130
2449365 2449365 2022-04-27 Sullivan New York 36105 18801 130
2446108 2446108 2022-04-26 Sullivan New York 36105 18769 130
2442853 2442853 2022-04-25 Sullivan New York 36105 18755 129
2439597 2439597 2022-04-24 Sullivan New York 36105 18736 129
2436341 2436341 2022-04-23 Sullivan New York 36105 18709 129
2433085 2433085 2022-04-22 Sullivan New York 36105 18690 129
2429829 2429829 2022-04-21 Sullivan New York 36105 18662 129
2426573 2426573 2022-04-20 Sullivan New York 36105 18641 129
2423317 2423317 2022-04-19 Sullivan New York 36105 18619 129
2420060 2420060 2022-04-18 Sullivan New York 36105 18612 129
2416805 2416805 2022-04-17 Sullivan New York 36105 18601 129
2413549 2413549 2022-04-16 Sullivan New York 36105 18587 129
2410293 2410293 2022-04-15 Sullivan New York 36105 18554 129
2407037 2407037 2022-04-14 Sullivan New York 36105 18528 129
2403781 2403781 2022-04-13 Sullivan New York 36105 18513 129
2400526 2400526 2022-04-12 Sullivan New York 36105 18495 129
2397271 2397271 2022-04-11 Sullivan New York 36105 18484 129
2394016 2394016 2022-04-10 Sullivan New York 36105 18473 129
2390760 2390760 2022-04-09 Sullivan New York 36105 18462 129
2387504 2387504 2022-04-08 Sullivan New York 36105 18446 129
2384249 2384249 2022-04-07 Sullivan New York 36105 18429 129
2380994 2380994 2022-04-06 Sullivan New York 36105 18403 129
2377739 2377739 2022-04-05 Sullivan New York 36105 18386 129
2374486 2374486 2022-04-04 Sullivan New York 36105 18378 129
2371234 2371234 2022-04-03 Sullivan New York 36105 18373 129
2367981 2367981 2022-04-02 Sullivan New York 36105 18364 129
2364728 2364728 2022-04-01 Sullivan New York 36105 18351 129
2361474 2361474 2022-03-31 Sullivan New York 36105 18341 129
2358220 2358220 2022-03-30 Sullivan New York 36105 18331 129
2354966 2354966 2022-03-29 Sullivan New York 36105 18324 129
2351713 2351713 2022-03-28 Sullivan New York 36105 18321 129
2348461 2348461 2022-03-27 Sullivan New York 36105 18320 129
2345208 2345208 2022-03-26 Sullivan New York 36105 18311 129
2341955 2341955 2022-03-25 Sullivan New York 36105 18309 129
2338702 2338702 2022-03-24 Sullivan New York 36105 18304 129
2335448 2335448 2022-03-23 Sullivan New York 36105 18301 129
2332194 2332194 2022-03-22 Sullivan New York 36105 18292 129
2328941 2328941 2022-03-21 Sullivan New York 36105 18286 129
2325689 2325689 2022-03-20 Sullivan New York 36105 18285 129
2322436 2322436 2022-03-19 Sullivan New York 36105 18283 129
2319182 2319182 2022-03-18 Sullivan New York 36105 18276 129
2315928 2315928 2022-03-17 Sullivan New York 36105 18272 129
2312675 2312675 2022-03-16 Sullivan New York 36105 18266 129
2309422 2309422 2022-03-15 Sullivan New York 36105 18261 129
2306169 2306169 2022-03-14 Sullivan New York 36105 18255 129
2302918 2302918 2022-03-13 Sullivan New York 36105 18254 128
2299666 2299666 2022-03-12 Sullivan New York 36105 18249 128
2296414 2296414 2022-03-11 Sullivan New York 36105 18240 128
2293162 2293162 2022-03-10 Sullivan New York 36105 18232 128
2289910 2289910 2022-03-09 Sullivan New York 36105 18228 128
2286658 2286658 2022-03-08 Sullivan New York 36105 18218 127
2283406 2283406 2022-03-07 Sullivan New York 36105 18216 127
2280154 2280154 2022-03-06 Sullivan New York 36105 18213 127
2276901 2276901 2022-03-05 Sullivan New York 36105 18210 127
2273648 2273648 2022-03-04 Sullivan New York 36105 18194 127
2270395 2270395 2022-03-03 Sullivan New York 36105 18194 127
2267143 2267143 2022-03-02 Sullivan New York 36105 18183 126
2263891 2263891 2022-03-01 Sullivan New York 36105 18178 126
2260640 2260640 2022-02-28 Sullivan New York 36105 18176 125
2257389 2257389 2022-02-27 Sullivan New York 36105 18172 125
2254138 2254138 2022-02-26 Sullivan New York 36105 18167 125
2250887 2250887 2022-02-25 Sullivan New York 36105 18158 125
2247636 2247636 2022-02-24 Sullivan New York 36105 18144 125
2244385 2244385 2022-02-23 Sullivan New York 36105 18125 125
2241134 2241134 2022-02-22 Sullivan New York 36105 18117 125
2237883 2237883 2022-02-21 Sullivan New York 36105 18108 124
2234632 2234632 2022-02-20 Sullivan New York 36105 18096 124
2231381 2231381 2022-02-19 Sullivan New York 36105 18082 124
2228130 2228130 2022-02-18 Sullivan New York 36105 18061 124
2224879 2224879 2022-02-17 Sullivan New York 36105 18047 124
2221628 2221628 2022-02-16 Sullivan New York 36105 18032 124
2218377 2218377 2022-02-15 Sullivan New York 36105 18013 124
2215126 2215126 2022-02-14 Sullivan New York 36105 18002 123
2211875 2211875 2022-02-13 Sullivan New York 36105 17992 122
2208622 2208622 2022-02-12 Sullivan New York 36105 17975 122
2205369 2205369 2022-02-11 Sullivan New York 36105 17959 122
2202116 2202116 2022-02-10 Sullivan New York 36105 17923 122
2198862 2198862 2022-02-09 Sullivan New York 36105 17886 122
2195608 2195608 2022-02-08 Sullivan New York 36105 17848 122
2192354 2192354 2022-02-07 Sullivan New York 36105 17830 122
2189100 2189100 2022-02-06 Sullivan New York 36105 17812 121
2185847 2185847 2022-02-05 Sullivan New York 36105 17796 120
2182595 2182595 2022-02-04 Sullivan New York 36105 17771 119
2179343 2179343 2022-02-03 Sullivan New York 36105 17734 119

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