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

771 rows where county = "Washington" and state = "Maine" sorted by date descending

✎ View and edit SQL

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

state 1

  • Maine · 771 ✖

fips 1

county 1

  • Washington · 771 ✖
Link rowid date ▲ county state fips cases deaths
2500779 2500779 2022-05-13 Washington Maine 23029 4585 57
2497521 2497521 2022-05-12 Washington Maine 23029 4579 56
2494263 2494263 2022-05-11 Washington Maine 23029 4569 56
2491005 2491005 2022-05-10 Washington Maine 23029 4563 56
2487748 2487748 2022-05-09 Washington Maine 23029 4556 56
2484490 2484490 2022-05-08 Washington Maine 23029 4554 56
2481232 2481232 2022-05-07 Washington Maine 23029 4554 56
2477974 2477974 2022-05-06 Washington Maine 23029 4546 56
2474716 2474716 2022-05-05 Washington Maine 23029 4533 56
2471459 2471459 2022-05-04 Washington Maine 23029 4522 56
2468203 2468203 2022-05-03 Washington Maine 23029 4508 56
2464948 2464948 2022-05-02 Washington Maine 23029 4492 55
2461692 2461692 2022-05-01 Washington Maine 23029 4485 55
2458436 2458436 2022-04-30 Washington Maine 23029 4485 55
2455180 2455180 2022-04-29 Washington Maine 23029 4476 55
2451924 2451924 2022-04-28 Washington Maine 23029 4471 55
2448668 2448668 2022-04-27 Washington Maine 23029 4467 55
2445412 2445412 2022-04-26 Washington Maine 23029 4455 55
2442156 2442156 2022-04-25 Washington Maine 23029 4451 55
2438900 2438900 2022-04-24 Washington Maine 23029 4451 55
2435644 2435644 2022-04-23 Washington Maine 23029 4451 55
2432388 2432388 2022-04-22 Washington Maine 23029 4449 55
2429132 2429132 2022-04-21 Washington Maine 23029 4443 55
2425876 2425876 2022-04-20 Washington Maine 23029 4438 55
2422620 2422620 2022-04-19 Washington Maine 23029 4424 55
2419364 2419364 2022-04-18 Washington Maine 23029 4424 55
2416108 2416108 2022-04-17 Washington Maine 23029 4424 55
2412852 2412852 2022-04-16 Washington Maine 23029 4424 55
2409596 2409596 2022-04-15 Washington Maine 23029 4419 55
2406340 2406340 2022-04-14 Washington Maine 23029 4411 55
2403084 2403084 2022-04-13 Washington Maine 23029 4399 55
2399830 2399830 2022-04-12 Washington Maine 23029 4384 55
2396574 2396574 2022-04-11 Washington Maine 23029 4379 54
2393319 2393319 2022-04-10 Washington Maine 23029 4379 54
2390063 2390063 2022-04-09 Washington Maine 23029 4379 54
2386807 2386807 2022-04-08 Washington Maine 23029 4372 54
2383552 2383552 2022-04-07 Washington Maine 23029 4368 54
2380297 2380297 2022-04-06 Washington Maine 23029 4365 52
2377042 2377042 2022-04-05 Washington Maine 23029 4348 52
2373790 2373790 2022-04-04 Washington Maine 23029 4332 52
2370537 2370537 2022-04-03 Washington Maine 23029 4332 52
2367284 2367284 2022-04-02 Washington Maine 23029 4332 52
2364031 2364031 2022-04-01 Washington Maine 23029 4321 52
2360777 2360777 2022-03-31 Washington Maine 23029 4309 52
2357523 2357523 2022-03-30 Washington Maine 23029 4306 52
2354270 2354270 2022-03-29 Washington Maine 23029 4303 52
2351018 2351018 2022-03-28 Washington Maine 23029 4294 52
2347765 2347765 2022-03-27 Washington Maine 23029 4294 52
2344512 2344512 2022-03-26 Washington Maine 23029 4294 52
2341259 2341259 2022-03-25 Washington Maine 23029 4286 52
2338006 2338006 2022-03-24 Washington Maine 23029 4279 52
2334752 2334752 2022-03-23 Washington Maine 23029 4261 52
2331498 2331498 2022-03-22 Washington Maine 23029 4260 52
2328246 2328246 2022-03-21 Washington Maine 23029 4251 52
2324993 2324993 2022-03-20 Washington Maine 23029 4251 52
2321739 2321739 2022-03-19 Washington Maine 23029 4251 52
2318485 2318485 2022-03-18 Washington Maine 23029 4246 51
2315232 2315232 2022-03-17 Washington Maine 23029 4246 51
2311979 2311979 2022-03-16 Washington Maine 23029 4220 51
2308726 2308726 2022-03-15 Washington Maine 23029 4201 50
2305475 2305475 2022-03-14 Washington Maine 23029 4184 50
2302223 2302223 2022-03-13 Washington Maine 23029 4184 50
2298971 2298971 2022-03-12 Washington Maine 23029 4184 50
2295719 2295719 2022-03-11 Washington Maine 23029 4182 50
2292467 2292467 2022-03-10 Washington Maine 23029 4167 50
2289215 2289215 2022-03-09 Washington Maine 23029 4155 50
2285964 2285964 2022-03-08 Washington Maine 23029 4154 50
2282712 2282712 2022-03-07 Washington Maine 23029 4133 50
2279459 2279459 2022-03-06 Washington Maine 23029 4133 50
2276206 2276206 2022-03-05 Washington Maine 23029 4133 50
2272953 2272953 2022-03-04 Washington Maine 23029 4128 50
2269701 2269701 2022-03-03 Washington Maine 23029 4087 49
2266448 2266448 2022-03-02 Washington Maine 23029 4010 49
2263197 2263197 2022-03-01 Washington Maine 23029 3979 49
2259946 2259946 2022-02-28 Washington Maine 23029 3953 49
2256695 2256695 2022-02-27 Washington Maine 23029 3953 49
2253444 2253444 2022-02-26 Washington Maine 23029 3950 49
2250193 2250193 2022-02-25 Washington Maine 23029 3929 49
2246942 2246942 2022-02-24 Washington Maine 23029 3908 49
2243691 2243691 2022-02-23 Washington Maine 23029 3875 49
2240440 2240440 2022-02-22 Washington Maine 23029 3842 49
2237189 2237189 2022-02-21 Washington Maine 23029 3666 49
2233938 2233938 2022-02-20 Washington Maine 23029 3666 49
2230687 2230687 2022-02-19 Washington Maine 23029 3636 49
2227436 2227436 2022-02-18 Washington Maine 23029 3564 47
2224185 2224185 2022-02-17 Washington Maine 23029 3519 46
2220934 2220934 2022-02-16 Washington Maine 23029 3493 46
2217683 2217683 2022-02-15 Washington Maine 23029 3443 45
2214432 2214432 2022-02-14 Washington Maine 23029 3234 45
2211180 2211180 2022-02-13 Washington Maine 23029 3234 45
2207927 2207927 2022-02-12 Washington Maine 23029 3234 45
2204674 2204674 2022-02-11 Washington Maine 23029 3222 45
2201421 2201421 2022-02-10 Washington Maine 23029 3208 45
2198167 2198167 2022-02-09 Washington Maine 23029 3191 45
2194913 2194913 2022-02-08 Washington Maine 23029 3178 45
2191659 2191659 2022-02-07 Washington Maine 23029 3161 45
2188406 2188406 2022-02-06 Washington Maine 23029 3161 45
2185153 2185153 2022-02-05 Washington Maine 23029 3161 45
2181901 2181901 2022-02-04 Washington Maine 23029 3161 45
2178649 2178649 2022-02-03 Washington Maine 23029 3139 45

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