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 = "Carroll" and fips = 33003 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

fips 1

  • 33003 · 789 ✖

county 1

  • Carroll · 789 ✖
Link rowid date ▲ county state fips cases deaths
2501362 2501362 2022-05-13 Carroll New Hampshire 33003 9865 62
2498104 2498104 2022-05-12 Carroll New Hampshire 33003 9844 62
2494846 2494846 2022-05-11 Carroll New Hampshire 33003 9815 61
2491588 2491588 2022-05-10 Carroll New Hampshire 33003 9798 61
2488330 2488330 2022-05-09 Carroll New Hampshire 33003 9784 61
2485073 2485073 2022-05-08 Carroll New Hampshire 33003 9719 61
2481815 2481815 2022-05-07 Carroll New Hampshire 33003 9719 61
2478557 2478557 2022-05-06 Carroll New Hampshire 33003 9719 61
2475299 2475299 2022-05-05 Carroll New Hampshire 33003 9691 61
2472042 2472042 2022-05-04 Carroll New Hampshire 33003 9676 61
2468786 2468786 2022-05-03 Carroll New Hampshire 33003 9652 61
2465530 2465530 2022-05-02 Carroll New Hampshire 33003 9642 61
2462275 2462275 2022-05-01 Carroll New Hampshire 33003 9598 61
2459019 2459019 2022-04-30 Carroll New Hampshire 33003 9598 61
2455763 2455763 2022-04-29 Carroll New Hampshire 33003 9598 61
2452507 2452507 2022-04-28 Carroll New Hampshire 33003 9586 61
2449251 2449251 2022-04-27 Carroll New Hampshire 33003 9572 61
2445994 2445994 2022-04-26 Carroll New Hampshire 33003 9557 61
2442739 2442739 2022-04-25 Carroll New Hampshire 33003 9554 60
2439483 2439483 2022-04-24 Carroll New Hampshire 33003 9493 60
2436227 2436227 2022-04-23 Carroll New Hampshire 33003 9493 60
2432971 2432971 2022-04-22 Carroll New Hampshire 33003 9493 60
2429715 2429715 2022-04-21 Carroll New Hampshire 33003 9473 60
2426459 2426459 2022-04-20 Carroll New Hampshire 33003 9464 60
2423203 2423203 2022-04-19 Carroll New Hampshire 33003 9452 59
2419946 2419946 2022-04-18 Carroll New Hampshire 33003 9441 59
2416691 2416691 2022-04-17 Carroll New Hampshire 33003 9411 59
2413435 2413435 2022-04-16 Carroll New Hampshire 33003 9411 59
2410179 2410179 2022-04-15 Carroll New Hampshire 33003 9411 59
2406923 2406923 2022-04-14 Carroll New Hampshire 33003 9406 59
2403667 2403667 2022-04-13 Carroll New Hampshire 33003 9390 59
2400412 2400412 2022-04-12 Carroll New Hampshire 33003 9375 59
2397157 2397157 2022-04-11 Carroll New Hampshire 33003 9354 59
2393902 2393902 2022-04-10 Carroll New Hampshire 33003 9325 59
2390646 2390646 2022-04-09 Carroll New Hampshire 33003 9325 59
2387390 2387390 2022-04-08 Carroll New Hampshire 33003 9325 59
2384135 2384135 2022-04-07 Carroll New Hampshire 33003 9247 56
2380880 2380880 2022-04-06 Carroll New Hampshire 33003 9247 56
2377625 2377625 2022-04-05 Carroll New Hampshire 33003 9247 56
2374372 2374372 2022-04-04 Carroll New Hampshire 33003 9247 56
2371120 2371120 2022-04-03 Carroll New Hampshire 33003 9247 56
2367867 2367867 2022-04-02 Carroll New Hampshire 33003 9247 56
2364614 2364614 2022-04-01 Carroll New Hampshire 33003 9247 56
2361360 2361360 2022-03-31 Carroll New Hampshire 33003 9247 56
2358106 2358106 2022-03-30 Carroll New Hampshire 33003 9242 56
2354853 2354853 2022-03-29 Carroll New Hampshire 33003 9238 56
2351600 2351600 2022-03-28 Carroll New Hampshire 33003 9232 56
2348348 2348348 2022-03-27 Carroll New Hampshire 33003 9209 56
2345095 2345095 2022-03-26 Carroll New Hampshire 33003 9209 56
2341842 2341842 2022-03-25 Carroll New Hampshire 33003 9209 56
2338589 2338589 2022-03-24 Carroll New Hampshire 33003 9178 56
2335335 2335335 2022-03-23 Carroll New Hampshire 33003 9174 56
2332081 2332081 2022-03-22 Carroll New Hampshire 33003 9161 56
2328828 2328828 2022-03-21 Carroll New Hampshire 33003 9162 56
2325576 2325576 2022-03-20 Carroll New Hampshire 33003 9158 56
2322322 2322322 2022-03-19 Carroll New Hampshire 33003 9158 56
2319068 2319068 2022-03-18 Carroll New Hampshire 33003 9158 56
2315815 2315815 2022-03-17 Carroll New Hampshire 33003 9145 56
2312562 2312562 2022-03-16 Carroll New Hampshire 33003 9138 56
2309309 2309309 2022-03-15 Carroll New Hampshire 33003 9126 56
2306056 2306056 2022-03-14 Carroll New Hampshire 33003 9123 56
2302805 2302805 2022-03-13 Carroll New Hampshire 33003 9110 56
2299553 2299553 2022-03-12 Carroll New Hampshire 33003 9110 56
2296301 2296301 2022-03-11 Carroll New Hampshire 33003 9110 56
2293049 2293049 2022-03-10 Carroll New Hampshire 33003 9103 56
2289797 2289797 2022-03-09 Carroll New Hampshire 33003 9098 55
2286545 2286545 2022-03-08 Carroll New Hampshire 33003 9091 55
2283293 2283293 2022-03-07 Carroll New Hampshire 33003 9086 55
2280040 2280040 2022-03-06 Carroll New Hampshire 33003 9056 55
2276787 2276787 2022-03-05 Carroll New Hampshire 33003 9056 55
2273534 2273534 2022-03-04 Carroll New Hampshire 33003 9056 55
2270282 2270282 2022-03-03 Carroll New Hampshire 33003 9056 55
2267029 2267029 2022-03-02 Carroll New Hampshire 33003 9048 55
2263778 2263778 2022-03-01 Carroll New Hampshire 33003 9023 55
2260527 2260527 2022-02-28 Carroll New Hampshire 33003 9015 55
2257276 2257276 2022-02-27 Carroll New Hampshire 33003 8987 55
2254025 2254025 2022-02-26 Carroll New Hampshire 33003 8987 55
2250774 2250774 2022-02-25 Carroll New Hampshire 33003 8987 55
2247523 2247523 2022-02-24 Carroll New Hampshire 33003 8957 55
2244272 2244272 2022-02-23 Carroll New Hampshire 33003 8923 55
2241021 2241021 2022-02-22 Carroll New Hampshire 33003 8871 55
2237770 2237770 2022-02-21 Carroll New Hampshire 33003 8871 55
2234519 2234519 2022-02-20 Carroll New Hampshire 33003 8871 55
2231268 2231268 2022-02-19 Carroll New Hampshire 33003 8871 55
2228017 2228017 2022-02-18 Carroll New Hampshire 33003 8871 55
2224766 2224766 2022-02-17 Carroll New Hampshire 33003 8820 55
2221515 2221515 2022-02-16 Carroll New Hampshire 33003 8811 55
2218264 2218264 2022-02-15 Carroll New Hampshire 33003 8804 55
2215013 2215013 2022-02-14 Carroll New Hampshire 33003 8717 54
2211761 2211761 2022-02-13 Carroll New Hampshire 33003 8717 54
2208508 2208508 2022-02-12 Carroll New Hampshire 33003 8717 54
2205255 2205255 2022-02-11 Carroll New Hampshire 33003 8717 54
2202002 2202002 2022-02-10 Carroll New Hampshire 33003 8688 54
2198748 2198748 2022-02-09 Carroll New Hampshire 33003 8655 54
2195494 2195494 2022-02-08 Carroll New Hampshire 33003 8624 52
2192240 2192240 2022-02-07 Carroll New Hampshire 33003 8601 51
2188987 2188987 2022-02-06 Carroll New Hampshire 33003 8513 50
2185734 2185734 2022-02-05 Carroll New Hampshire 33003 8513 50
2182482 2182482 2022-02-04 Carroll New Hampshire 33003 8513 50
2179230 2179230 2022-02-03 Carroll New Hampshire 33003 8472 50

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