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

782 rows where fips = 23013 and state = "Maine" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Maine · 782 ✖

fips 1

  • 23013 · 782 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500770 2500770 2022-05-13 Knox Maine 23013 6414 38
2497512 2497512 2022-05-12 Knox Maine 23013 6391 38
2494254 2494254 2022-05-11 Knox Maine 23013 6381 37
2490996 2490996 2022-05-10 Knox Maine 23013 6360 37
2487739 2487739 2022-05-09 Knox Maine 23013 6340 37
2484481 2484481 2022-05-08 Knox Maine 23013 6333 37
2481223 2481223 2022-05-07 Knox Maine 23013 6333 37
2477965 2477965 2022-05-06 Knox Maine 23013 6315 37
2474707 2474707 2022-05-05 Knox Maine 23013 6291 36
2471450 2471450 2022-05-04 Knox Maine 23013 6268 36
2468194 2468194 2022-05-03 Knox Maine 23013 6243 36
2464939 2464939 2022-05-02 Knox Maine 23013 6204 35
2461683 2461683 2022-05-01 Knox Maine 23013 6188 35
2458427 2458427 2022-04-30 Knox Maine 23013 6188 35
2455171 2455171 2022-04-29 Knox Maine 23013 6156 35
2451915 2451915 2022-04-28 Knox Maine 23013 6148 35
2448659 2448659 2022-04-27 Knox Maine 23013 6132 35
2445403 2445403 2022-04-26 Knox Maine 23013 6118 35
2442147 2442147 2022-04-25 Knox Maine 23013 6101 34
2438891 2438891 2022-04-24 Knox Maine 23013 6101 34
2435635 2435635 2022-04-23 Knox Maine 23013 6101 34
2432379 2432379 2022-04-22 Knox Maine 23013 6086 34
2429123 2429123 2022-04-21 Knox Maine 23013 6066 34
2425867 2425867 2022-04-20 Knox Maine 23013 6054 34
2422611 2422611 2022-04-19 Knox Maine 23013 6026 34
2419355 2419355 2022-04-18 Knox Maine 23013 6026 34
2416099 2416099 2022-04-17 Knox Maine 23013 6026 34
2412843 2412843 2022-04-16 Knox Maine 23013 6026 34
2409587 2409587 2022-04-15 Knox Maine 23013 6021 34
2406331 2406331 2022-04-14 Knox Maine 23013 6014 34
2403075 2403075 2022-04-13 Knox Maine 23013 6003 34
2399821 2399821 2022-04-12 Knox Maine 23013 5978 33
2396565 2396565 2022-04-11 Knox Maine 23013 5964 33
2393310 2393310 2022-04-10 Knox Maine 23013 5964 33
2390054 2390054 2022-04-09 Knox Maine 23013 5964 33
2386798 2386798 2022-04-08 Knox Maine 23013 5953 33
2383543 2383543 2022-04-07 Knox Maine 23013 5952 33
2380288 2380288 2022-04-06 Knox Maine 23013 5944 33
2377033 2377033 2022-04-05 Knox Maine 23013 5932 33
2373781 2373781 2022-04-04 Knox Maine 23013 5917 33
2370528 2370528 2022-04-03 Knox Maine 23013 5917 33
2367275 2367275 2022-04-02 Knox Maine 23013 5917 33
2364022 2364022 2022-04-01 Knox Maine 23013 5911 33
2360768 2360768 2022-03-31 Knox Maine 23013 5907 33
2357514 2357514 2022-03-30 Knox Maine 23013 5897 33
2354261 2354261 2022-03-29 Knox Maine 23013 5882 33
2351009 2351009 2022-03-28 Knox Maine 23013 5865 33
2347756 2347756 2022-03-27 Knox Maine 23013 5865 33
2344503 2344503 2022-03-26 Knox Maine 23013 5865 33
2341250 2341250 2022-03-25 Knox Maine 23013 5861 33
2337997 2337997 2022-03-24 Knox Maine 23013 5856 33
2334743 2334743 2022-03-23 Knox Maine 23013 5847 33
2331489 2331489 2022-03-22 Knox Maine 23013 5838 33
2328237 2328237 2022-03-21 Knox Maine 23013 5820 33
2324984 2324984 2022-03-20 Knox Maine 23013 5820 33
2321730 2321730 2022-03-19 Knox Maine 23013 5820 33
2318476 2318476 2022-03-18 Knox Maine 23013 5815 33
2315223 2315223 2022-03-17 Knox Maine 23013 5799 33
2311970 2311970 2022-03-16 Knox Maine 23013 5796 32
2308717 2308717 2022-03-15 Knox Maine 23013 5786 31
2305466 2305466 2022-03-14 Knox Maine 23013 5775 31
2302214 2302214 2022-03-13 Knox Maine 23013 5775 31
2298962 2298962 2022-03-12 Knox Maine 23013 5775 31
2295710 2295710 2022-03-11 Knox Maine 23013 5770 31
2292458 2292458 2022-03-10 Knox Maine 23013 5763 31
2289206 2289206 2022-03-09 Knox Maine 23013 5755 31
2285955 2285955 2022-03-08 Knox Maine 23013 5749 31
2282703 2282703 2022-03-07 Knox Maine 23013 5739 31
2279450 2279450 2022-03-06 Knox Maine 23013 5739 31
2276197 2276197 2022-03-05 Knox Maine 23013 5739 31
2272944 2272944 2022-03-04 Knox Maine 23013 5724 29
2269692 2269692 2022-03-03 Knox Maine 23013 5712 29
2266439 2266439 2022-03-02 Knox Maine 23013 5666 29
2263188 2263188 2022-03-01 Knox Maine 23013 5644 26
2259937 2259937 2022-02-28 Knox Maine 23013 5620 26
2256686 2256686 2022-02-27 Knox Maine 23013 5620 26
2253435 2253435 2022-02-26 Knox Maine 23013 5620 26
2250184 2250184 2022-02-25 Knox Maine 23013 5607 26
2246933 2246933 2022-02-24 Knox Maine 23013 5585 25
2243682 2243682 2022-02-23 Knox Maine 23013 5561 24
2240431 2240431 2022-02-22 Knox Maine 23013 5541 24
2237180 2237180 2022-02-21 Knox Maine 23013 5525 24
2233929 2233929 2022-02-20 Knox Maine 23013 5525 24
2230678 2230678 2022-02-19 Knox Maine 23013 5422 24
2227427 2227427 2022-02-18 Knox Maine 23013 5265 22
2224176 2224176 2022-02-17 Knox Maine 23013 5137 22
2220925 2220925 2022-02-16 Knox Maine 23013 4945 22
2217674 2217674 2022-02-15 Knox Maine 23013 4860 22
2214423 2214423 2022-02-14 Knox Maine 23013 4689 22
2211171 2211171 2022-02-13 Knox Maine 23013 4689 22
2207918 2207918 2022-02-12 Knox Maine 23013 4689 22
2204665 2204665 2022-02-11 Knox Maine 23013 4457 22
2201412 2201412 2022-02-10 Knox Maine 23013 4415 22
2198158 2198158 2022-02-09 Knox Maine 23013 4340 22
2194904 2194904 2022-02-08 Knox Maine 23013 4325 22
2191650 2191650 2022-02-07 Knox Maine 23013 4284 22
2188397 2188397 2022-02-06 Knox Maine 23013 4284 22
2185144 2185144 2022-02-05 Knox Maine 23013 4284 22
2181892 2181892 2022-02-04 Knox Maine 23013 4267 22
2178641 2178641 2022-02-03 Knox Maine 23013 4251 22

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