ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,130 rows where county = "Somerset" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 4
- New Jersey 739
- Maryland 734
- Pennsylvania 731
- Maine 726
county 1
- Somerset · 2,930 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2338003 | 2338003 | 2022-03-24 | Somerset | Maine | 23025 | 9493 | 101 |
2338026 | 2338026 | 2022-03-24 | Somerset | Maryland | 24039 | 5168 | 73 |
2338616 | 2338616 | 2022-03-24 | Somerset | New Jersey | 34035 | 67204 | 966 |
2339128 | 2339128 | 2022-03-24 | Somerset | Pennsylvania | 42111 | 18660 | 399 |
2334749 | 2334749 | 2022-03-23 | Somerset | Maine | 23025 | 9480 | 101 |
2334772 | 2334772 | 2022-03-23 | Somerset | Maryland | 24039 | 5166 | 73 |
2335362 | 2335362 | 2022-03-23 | Somerset | New Jersey | 34035 | 67163 | 966 |
2335874 | 2335874 | 2022-03-23 | Somerset | Pennsylvania | 42111 | 18659 | 399 |
2331495 | 2331495 | 2022-03-22 | Somerset | Maine | 23025 | 9462 | 101 |
2331518 | 2331518 | 2022-03-22 | Somerset | Maryland | 24039 | 5164 | 73 |
2332108 | 2332108 | 2022-03-22 | Somerset | New Jersey | 34035 | 67116 | 966 |
2332620 | 2332620 | 2022-03-22 | Somerset | Pennsylvania | 42111 | 18659 | 399 |
2328243 | 2328243 | 2022-03-21 | Somerset | Maine | 23025 | 9438 | 101 |
2328266 | 2328266 | 2022-03-21 | Somerset | Maryland | 24039 | 5164 | 73 |
2328855 | 2328855 | 2022-03-21 | Somerset | New Jersey | 34035 | 67074 | 966 |
2329367 | 2329367 | 2022-03-21 | Somerset | Pennsylvania | 42111 | 18658 | 398 |
2324990 | 2324990 | 2022-03-20 | Somerset | Maine | 23025 | 9438 | 101 |
2325013 | 2325013 | 2022-03-20 | Somerset | Maryland | 24039 | 5162 | 73 |
2325603 | 2325603 | 2022-03-20 | Somerset | New Jersey | 34035 | 67060 | 965 |
2326115 | 2326115 | 2022-03-20 | Somerset | Pennsylvania | 42111 | 18657 | 398 |
2321736 | 2321736 | 2022-03-19 | Somerset | Maine | 23025 | 9438 | 101 |
2321759 | 2321759 | 2022-03-19 | Somerset | Maryland | 24039 | 5162 | 73 |
2322349 | 2322349 | 2022-03-19 | Somerset | New Jersey | 34035 | 67046 | 965 |
2322862 | 2322862 | 2022-03-19 | Somerset | Pennsylvania | 42111 | 18657 | 398 |
2318482 | 2318482 | 2022-03-18 | Somerset | Maine | 23025 | 9432 | 101 |
2318505 | 2318505 | 2022-03-18 | Somerset | Maryland | 24039 | 5159 | 73 |
2319095 | 2319095 | 2022-03-18 | Somerset | New Jersey | 34035 | 67022 | 965 |
2319608 | 2319608 | 2022-03-18 | Somerset | Pennsylvania | 42111 | 18655 | 398 |
2315229 | 2315229 | 2022-03-17 | Somerset | Maine | 23025 | 9415 | 101 |
2315252 | 2315252 | 2022-03-17 | Somerset | Maryland | 24039 | 5157 | 73 |
2315842 | 2315842 | 2022-03-17 | Somerset | New Jersey | 34035 | 66901 | 965 |
2316354 | 2316354 | 2022-03-17 | Somerset | Pennsylvania | 42111 | 18654 | 398 |
2311976 | 2311976 | 2022-03-16 | Somerset | Maine | 23025 | 9402 | 101 |
2311999 | 2311999 | 2022-03-16 | Somerset | Maryland | 24039 | 5155 | 73 |
2312589 | 2312589 | 2022-03-16 | Somerset | New Jersey | 34035 | 66872 | 965 |
2313101 | 2313101 | 2022-03-16 | Somerset | Pennsylvania | 42111 | 18650 | 398 |
2308723 | 2308723 | 2022-03-15 | Somerset | Maine | 23025 | 9454 | 103 |
2308746 | 2308746 | 2022-03-15 | Somerset | Maryland | 24039 | 5151 | 73 |
2309336 | 2309336 | 2022-03-15 | Somerset | New Jersey | 34035 | 66821 | 964 |
2309848 | 2309848 | 2022-03-15 | Somerset | Pennsylvania | 42111 | 18645 | 397 |
2305472 | 2305472 | 2022-03-14 | Somerset | Maine | 23025 | 9430 | 102 |
2305495 | 2305495 | 2022-03-14 | Somerset | Maryland | 24039 | 5150 | 73 |
2306083 | 2306083 | 2022-03-14 | Somerset | New Jersey | 34035 | 66796 | 963 |
2306595 | 2306595 | 2022-03-14 | Somerset | Pennsylvania | 42111 | 18640 | 396 |
2302220 | 2302220 | 2022-03-13 | Somerset | Maine | 23025 | 9430 | 102 |
2302243 | 2302243 | 2022-03-13 | Somerset | Maryland | 24039 | 5150 | 73 |
2302832 | 2302832 | 2022-03-13 | Somerset | New Jersey | 34035 | 66778 | 962 |
2303344 | 2303344 | 2022-03-13 | Somerset | Pennsylvania | 42111 | 18640 | 396 |
2298968 | 2298968 | 2022-03-12 | Somerset | Maine | 23025 | 9430 | 102 |
2298991 | 2298991 | 2022-03-12 | Somerset | Maryland | 24039 | 5148 | 73 |
2299580 | 2299580 | 2022-03-12 | Somerset | New Jersey | 34035 | 66743 | 962 |
2300092 | 2300092 | 2022-03-12 | Somerset | Pennsylvania | 42111 | 18638 | 396 |
2295716 | 2295716 | 2022-03-11 | Somerset | Maine | 23025 | 9413 | 102 |
2295739 | 2295739 | 2022-03-11 | Somerset | Maryland | 24039 | 5142 | 70 |
2296328 | 2296328 | 2022-03-11 | Somerset | New Jersey | 34035 | 66743 | 962 |
2296840 | 2296840 | 2022-03-11 | Somerset | Pennsylvania | 42111 | 18634 | 396 |
2292464 | 2292464 | 2022-03-10 | Somerset | Maine | 23025 | 9389 | 102 |
2292487 | 2292487 | 2022-03-10 | Somerset | Maryland | 24039 | 5148 | 70 |
2293076 | 2293076 | 2022-03-10 | Somerset | New Jersey | 34035 | 66714 | 962 |
2293588 | 2293588 | 2022-03-10 | Somerset | Pennsylvania | 42111 | 18629 | 396 |
2289212 | 2289212 | 2022-03-09 | Somerset | Maine | 23025 | 9376 | 102 |
2289235 | 2289235 | 2022-03-09 | Somerset | Maryland | 24039 | 5147 | 70 |
2289824 | 2289824 | 2022-03-09 | Somerset | New Jersey | 34035 | 66676 | 962 |
2290336 | 2290336 | 2022-03-09 | Somerset | Pennsylvania | 42111 | 18629 | 396 |
2285961 | 2285961 | 2022-03-08 | Somerset | Maine | 23025 | 9369 | 102 |
2285984 | 2285984 | 2022-03-08 | Somerset | Maryland | 24039 | 5145 | 70 |
2286572 | 2286572 | 2022-03-08 | Somerset | New Jersey | 34035 | 66624 | 961 |
2287084 | 2287084 | 2022-03-08 | Somerset | Pennsylvania | 42111 | 18625 | 396 |
2282709 | 2282709 | 2022-03-07 | Somerset | Maine | 23025 | 9333 | 102 |
2282732 | 2282732 | 2022-03-07 | Somerset | Maryland | 24039 | 5145 | 70 |
2283320 | 2283320 | 2022-03-07 | Somerset | New Jersey | 34035 | 66558 | 961 |
2283832 | 2283832 | 2022-03-07 | Somerset | Pennsylvania | 42111 | 18621 | 396 |
2279456 | 2279456 | 2022-03-06 | Somerset | Maine | 23025 | 9333 | 102 |
2279479 | 2279479 | 2022-03-06 | Somerset | Maryland | 24039 | 5144 | 70 |
2280067 | 2280067 | 2022-03-06 | Somerset | New Jersey | 34035 | 66537 | 960 |
2280580 | 2280580 | 2022-03-06 | Somerset | Pennsylvania | 42111 | 18618 | 396 |
2276203 | 2276203 | 2022-03-05 | Somerset | Maine | 23025 | 9333 | 102 |
2276226 | 2276226 | 2022-03-05 | Somerset | Maryland | 24039 | 5144 | 70 |
2276814 | 2276814 | 2022-03-05 | Somerset | New Jersey | 34035 | 66516 | 960 |
2277327 | 2277327 | 2022-03-05 | Somerset | Pennsylvania | 42111 | 18615 | 396 |
2272950 | 2272950 | 2022-03-04 | Somerset | Maine | 23025 | 9304 | 100 |
2272973 | 2272973 | 2022-03-04 | Somerset | Maryland | 24039 | 5144 | 70 |
2273561 | 2273561 | 2022-03-04 | Somerset | New Jersey | 34035 | 66493 | 960 |
2274074 | 2274074 | 2022-03-04 | Somerset | Pennsylvania | 42111 | 18616 | 396 |
2269698 | 2269698 | 2022-03-03 | Somerset | Maine | 23025 | 9256 | 99 |
2269721 | 2269721 | 2022-03-03 | Somerset | Maryland | 24039 | 5144 | 70 |
2270309 | 2270309 | 2022-03-03 | Somerset | New Jersey | 34035 | 66469 | 960 |
2270821 | 2270821 | 2022-03-03 | Somerset | Pennsylvania | 42111 | 18609 | 396 |
2266445 | 2266445 | 2022-03-02 | Somerset | Maine | 23025 | 9168 | 99 |
2266468 | 2266468 | 2022-03-02 | Somerset | Maryland | 24039 | 5142 | 69 |
2267056 | 2267056 | 2022-03-02 | Somerset | New Jersey | 34035 | 66435 | 960 |
2267569 | 2267569 | 2022-03-02 | Somerset | Pennsylvania | 42111 | 18600 | 396 |
2263194 | 2263194 | 2022-03-01 | Somerset | Maine | 23025 | 9122 | 99 |
2263217 | 2263217 | 2022-03-01 | Somerset | Maryland | 24039 | 5139 | 69 |
2263805 | 2263805 | 2022-03-01 | Somerset | New Jersey | 34035 | 66400 | 960 |
2264316 | 2264316 | 2022-03-01 | Somerset | Pennsylvania | 42111 | 18588 | 396 |
2259943 | 2259943 | 2022-02-28 | Somerset | Maine | 23025 | 9082 | 99 |
2259966 | 2259966 | 2022-02-28 | Somerset | Maryland | 24039 | 5137 | 69 |
2260554 | 2260554 | 2022-02-28 | Somerset | New Jersey | 34035 | 66350 | 960 |
2261066 | 2261066 | 2022-02-28 | Somerset | Pennsylvania | 42111 | 18587 | 394 |
Advanced export
JSON shape: default, array, newline-delimited
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);