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 = "Fulton", fips = 36035 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

  • 36035 · 785 ✖

county 1

  • Fulton · 785 ✖
Link rowid date ▲ county state fips cases deaths
2501444 2501444 2022-05-13 Fulton New York 36035 13428 169
2498186 2498186 2022-05-12 Fulton New York 36035 13428 169
2494928 2494928 2022-05-11 Fulton New York 36035 13402 169
2491670 2491670 2022-05-10 Fulton New York 36035 13385 169
2488412 2488412 2022-05-09 Fulton New York 36035 13362 169
2485155 2485155 2022-05-08 Fulton New York 36035 13344 169
2481897 2481897 2022-05-07 Fulton New York 36035 13311 169
2478639 2478639 2022-05-06 Fulton New York 36035 13288 169
2475381 2475381 2022-05-05 Fulton New York 36035 13261 169
2472124 2472124 2022-05-04 Fulton New York 36035 13234 169
2468868 2468868 2022-05-03 Fulton New York 36035 13209 169
2465612 2465612 2022-05-02 Fulton New York 36035 13190 169
2462357 2462357 2022-05-01 Fulton New York 36035 13178 169
2459101 2459101 2022-04-30 Fulton New York 36035 13150 169
2455845 2455845 2022-04-29 Fulton New York 36035 13121 169
2452589 2452589 2022-04-28 Fulton New York 36035 13098 169
2449333 2449333 2022-04-27 Fulton New York 36035 13046 169
2446076 2446076 2022-04-26 Fulton New York 36035 13028 169
2442821 2442821 2022-04-25 Fulton New York 36035 13008 169
2439565 2439565 2022-04-24 Fulton New York 36035 12995 169
2436309 2436309 2022-04-23 Fulton New York 36035 12981 169
2433053 2433053 2022-04-22 Fulton New York 36035 12971 169
2429797 2429797 2022-04-21 Fulton New York 36035 12953 169
2426541 2426541 2022-04-20 Fulton New York 36035 12935 169
2423285 2423285 2022-04-19 Fulton New York 36035 12918 169
2420028 2420028 2022-04-18 Fulton New York 36035 12905 169
2416773 2416773 2022-04-17 Fulton New York 36035 12881 169
2413517 2413517 2022-04-16 Fulton New York 36035 12865 169
2410261 2410261 2022-04-15 Fulton New York 36035 12844 169
2407005 2407005 2022-04-14 Fulton New York 36035 12819 169
2403749 2403749 2022-04-13 Fulton New York 36035 12796 169
2400494 2400494 2022-04-12 Fulton New York 36035 12772 169
2397239 2397239 2022-04-11 Fulton New York 36035 12753 169
2393984 2393984 2022-04-10 Fulton New York 36035 12737 169
2390728 2390728 2022-04-09 Fulton New York 36035 12712 169
2387472 2387472 2022-04-08 Fulton New York 36035 12683 169
2384217 2384217 2022-04-07 Fulton New York 36035 12659 169
2380962 2380962 2022-04-06 Fulton New York 36035 12643 169
2377707 2377707 2022-04-05 Fulton New York 36035 12620 169
2374454 2374454 2022-04-04 Fulton New York 36035 12613 169
2371202 2371202 2022-04-03 Fulton New York 36035 12608 169
2367949 2367949 2022-04-02 Fulton New York 36035 12591 169
2364696 2364696 2022-04-01 Fulton New York 36035 12580 168
2361442 2361442 2022-03-31 Fulton New York 36035 12561 167
2358188 2358188 2022-03-30 Fulton New York 36035 12552 167
2354934 2354934 2022-03-29 Fulton New York 36035 12534 167
2351681 2351681 2022-03-28 Fulton New York 36035 12526 167
2348429 2348429 2022-03-27 Fulton New York 36035 12518 166
2345176 2345176 2022-03-26 Fulton New York 36035 12508 166
2341923 2341923 2022-03-25 Fulton New York 36035 12504 166
2338670 2338670 2022-03-24 Fulton New York 36035 12494 166
2335416 2335416 2022-03-23 Fulton New York 36035 12484 166
2332162 2332162 2022-03-22 Fulton New York 36035 12461 166
2328909 2328909 2022-03-21 Fulton New York 36035 12456 166
2325657 2325657 2022-03-20 Fulton New York 36035 12453 166
2322404 2322404 2022-03-19 Fulton New York 36035 12449 166
2319150 2319150 2022-03-18 Fulton New York 36035 12443 166
2315896 2315896 2022-03-17 Fulton New York 36035 12432 166
2312643 2312643 2022-03-16 Fulton New York 36035 12410 166
2309390 2309390 2022-03-15 Fulton New York 36035 12394 166
2306137 2306137 2022-03-14 Fulton New York 36035 12382 166
2302886 2302886 2022-03-13 Fulton New York 36035 12372 166
2299634 2299634 2022-03-12 Fulton New York 36035 12361 166
2296382 2296382 2022-03-11 Fulton New York 36035 12352 166
2293130 2293130 2022-03-10 Fulton New York 36035 12334 166
2289878 2289878 2022-03-09 Fulton New York 36035 12324 166
2286626 2286626 2022-03-08 Fulton New York 36035 12318 166
2283374 2283374 2022-03-07 Fulton New York 36035 12308 166
2280122 2280122 2022-03-06 Fulton New York 36035 12305 166
2276869 2276869 2022-03-05 Fulton New York 36035 12300 166
2273616 2273616 2022-03-04 Fulton New York 36035 12283 166
2270363 2270363 2022-03-03 Fulton New York 36035 12283 166
2267111 2267111 2022-03-02 Fulton New York 36035 12275 166
2263859 2263859 2022-03-01 Fulton New York 36035 12259 166
2260608 2260608 2022-02-28 Fulton New York 36035 12257 165
2257357 2257357 2022-02-27 Fulton New York 36035 12254 165
2254106 2254106 2022-02-26 Fulton New York 36035 12249 165
2250855 2250855 2022-02-25 Fulton New York 36035 12237 165
2247604 2247604 2022-02-24 Fulton New York 36035 12233 165
2244353 2244353 2022-02-23 Fulton New York 36035 12216 165
2241102 2241102 2022-02-22 Fulton New York 36035 12199 165
2237851 2237851 2022-02-21 Fulton New York 36035 12189 165
2234600 2234600 2022-02-20 Fulton New York 36035 12182 164
2231349 2231349 2022-02-19 Fulton New York 36035 12169 164
2228098 2228098 2022-02-18 Fulton New York 36035 12160 163
2224847 2224847 2022-02-17 Fulton New York 36035 12140 162
2221596 2221596 2022-02-16 Fulton New York 36035 12120 162
2218345 2218345 2022-02-15 Fulton New York 36035 12104 161
2215094 2215094 2022-02-14 Fulton New York 36035 12093 161
2211843 2211843 2022-02-13 Fulton New York 36035 12082 161
2208590 2208590 2022-02-12 Fulton New York 36035 12066 160
2205337 2205337 2022-02-11 Fulton New York 36035 12040 160
2202084 2202084 2022-02-10 Fulton New York 36035 12017 158
2198830 2198830 2022-02-09 Fulton New York 36035 11979 156
2195576 2195576 2022-02-08 Fulton New York 36035 11944 156
2192322 2192322 2022-02-07 Fulton New York 36035 11921 156
2189068 2189068 2022-02-06 Fulton New York 36035 11898 156
2185815 2185815 2022-02-05 Fulton New York 36035 11857 154
2182563 2182563 2022-02-04 Fulton New York 36035 11828 154
2179311 2179311 2022-02-03 Fulton New York 36035 11793 154

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