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 764
- Maryland 759
- Pennsylvania 756
- Maine 751
county 1
- Somerset · 3,030 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2419361 | 2419361 | 2022-04-18 | Somerset | Maine | 23025 | 9779 | 103 |
2419384 | 2419384 | 2022-04-18 | Somerset | Maryland | 24039 | 5213 | 73 |
2419973 | 2419973 | 2022-04-18 | Somerset | New Jersey | 34035 | 68781 | 972 |
2420487 | 2420487 | 2022-04-18 | Somerset | Pennsylvania | 42111 | 18723 | 405 |
2416105 | 2416105 | 2022-04-17 | Somerset | Maine | 23025 | 9779 | 103 |
2416128 | 2416128 | 2022-04-17 | Somerset | Maryland | 24039 | 5211 | 73 |
2416718 | 2416718 | 2022-04-17 | Somerset | New Jersey | 34035 | 68739 | 971 |
2417231 | 2417231 | 2022-04-17 | Somerset | Pennsylvania | 42111 | 18722 | 405 |
2412849 | 2412849 | 2022-04-16 | Somerset | Maine | 23025 | 9779 | 103 |
2412872 | 2412872 | 2022-04-16 | Somerset | Maryland | 24039 | 5211 | 73 |
2413462 | 2413462 | 2022-04-16 | Somerset | New Jersey | 34035 | 68654 | 971 |
2413975 | 2413975 | 2022-04-16 | Somerset | Pennsylvania | 42111 | 18721 | 405 |
2409593 | 2409593 | 2022-04-15 | Somerset | Maine | 23025 | 9767 | 103 |
2409616 | 2409616 | 2022-04-15 | Somerset | Maryland | 24039 | 5211 | 73 |
2410206 | 2410206 | 2022-04-15 | Somerset | New Jersey | 34035 | 68461 | 971 |
2410719 | 2410719 | 2022-04-15 | Somerset | Pennsylvania | 42111 | 18716 | 405 |
2406337 | 2406337 | 2022-04-14 | Somerset | Maine | 23025 | 9750 | 103 |
2406360 | 2406360 | 2022-04-14 | Somerset | Maryland | 24039 | 5209 | 73 |
2406950 | 2406950 | 2022-04-14 | Somerset | New Jersey | 34035 | 68461 | 971 |
2407463 | 2407463 | 2022-04-14 | Somerset | Pennsylvania | 42111 | 18715 | 405 |
2403081 | 2403081 | 2022-04-13 | Somerset | Maine | 23025 | 9734 | 103 |
2403104 | 2403104 | 2022-04-13 | Somerset | Maryland | 24039 | 5209 | 73 |
2403694 | 2403694 | 2022-04-13 | Somerset | New Jersey | 34035 | 68347 | 971 |
2404207 | 2404207 | 2022-04-13 | Somerset | Pennsylvania | 42111 | 18714 | 405 |
2399827 | 2399827 | 2022-04-12 | Somerset | Maine | 23025 | 9716 | 103 |
2399850 | 2399850 | 2022-04-12 | Somerset | Maryland | 24039 | 5208 | 73 |
2400439 | 2400439 | 2022-04-12 | Somerset | New Jersey | 34035 | 68261 | 970 |
2400952 | 2400952 | 2022-04-12 | Somerset | Pennsylvania | 42111 | 18712 | 405 |
2396571 | 2396571 | 2022-04-11 | Somerset | Maine | 23025 | 9690 | 101 |
2396594 | 2396594 | 2022-04-11 | Somerset | Maryland | 24039 | 5206 | 73 |
2397184 | 2397184 | 2022-04-11 | Somerset | New Jersey | 34035 | 68195 | 970 |
2397697 | 2397697 | 2022-04-11 | Somerset | Pennsylvania | 42111 | 18711 | 404 |
2393316 | 2393316 | 2022-04-10 | Somerset | Maine | 23025 | 9690 | 101 |
2393339 | 2393339 | 2022-04-10 | Somerset | Maryland | 24039 | 5203 | 73 |
2393929 | 2393929 | 2022-04-10 | Somerset | New Jersey | 34035 | 68139 | 970 |
2394442 | 2394442 | 2022-04-10 | Somerset | Pennsylvania | 42111 | 18710 | 404 |
2390060 | 2390060 | 2022-04-09 | Somerset | Maine | 23025 | 9690 | 101 |
2390083 | 2390083 | 2022-04-09 | Somerset | Maryland | 24039 | 5203 | 73 |
2390673 | 2390673 | 2022-04-09 | Somerset | New Jersey | 34035 | 68077 | 970 |
2391186 | 2391186 | 2022-04-09 | Somerset | Pennsylvania | 42111 | 18707 | 404 |
2386804 | 2386804 | 2022-04-08 | Somerset | Maine | 23025 | 9662 | 101 |
2386827 | 2386827 | 2022-04-08 | Somerset | Maryland | 24039 | 5203 | 73 |
2387417 | 2387417 | 2022-04-08 | Somerset | New Jersey | 34035 | 68018 | 970 |
2387930 | 2387930 | 2022-04-08 | Somerset | Pennsylvania | 42111 | 18703 | 404 |
2383549 | 2383549 | 2022-04-07 | Somerset | Maine | 23025 | 9650 | 101 |
2383572 | 2383572 | 2022-04-07 | Somerset | Maryland | 24039 | 5202 | 73 |
2384162 | 2384162 | 2022-04-07 | Somerset | New Jersey | 34035 | 67905 | 970 |
2384675 | 2384675 | 2022-04-07 | Somerset | Pennsylvania | 42111 | 18700 | 404 |
2380294 | 2380294 | 2022-04-06 | Somerset | Maine | 23025 | 9626 | 101 |
2380317 | 2380317 | 2022-04-06 | Somerset | Maryland | 24039 | 5198 | 73 |
2380907 | 2380907 | 2022-04-06 | Somerset | New Jersey | 34035 | 67811 | 970 |
2381420 | 2381420 | 2022-04-06 | Somerset | Pennsylvania | 42111 | 18698 | 404 |
2377039 | 2377039 | 2022-04-05 | Somerset | Maine | 23025 | 9627 | 101 |
2377062 | 2377062 | 2022-04-05 | Somerset | Maryland | 24039 | 5196 | 73 |
2377652 | 2377652 | 2022-04-05 | Somerset | New Jersey | 34035 | 67745 | 970 |
2378165 | 2378165 | 2022-04-05 | Somerset | Pennsylvania | 42111 | 18698 | 403 |
2373787 | 2373787 | 2022-04-04 | Somerset | Maine | 23025 | 9593 | 101 |
2373810 | 2373810 | 2022-04-04 | Somerset | Maryland | 24039 | 5193 | 73 |
2374399 | 2374399 | 2022-04-04 | Somerset | New Jersey | 34035 | 67698 | 969 |
2374911 | 2374911 | 2022-04-04 | Somerset | Pennsylvania | 42111 | 18692 | 402 |
2370534 | 2370534 | 2022-04-03 | Somerset | Maine | 23025 | 9593 | 101 |
2370557 | 2370557 | 2022-04-03 | Somerset | Maryland | 24039 | 5189 | 73 |
2371147 | 2371147 | 2022-04-03 | Somerset | New Jersey | 34035 | 67672 | 967 |
2371659 | 2371659 | 2022-04-03 | Somerset | Pennsylvania | 42111 | 18690 | 402 |
2367281 | 2367281 | 2022-04-02 | Somerset | Maine | 23025 | 9593 | 101 |
2367304 | 2367304 | 2022-04-02 | Somerset | Maryland | 24039 | 5189 | 73 |
2367894 | 2367894 | 2022-04-02 | Somerset | New Jersey | 34035 | 67636 | 967 |
2368406 | 2368406 | 2022-04-02 | Somerset | Pennsylvania | 42111 | 18690 | 402 |
2364028 | 2364028 | 2022-04-01 | Somerset | Maine | 23025 | 9583 | 101 |
2364051 | 2364051 | 2022-04-01 | Somerset | Maryland | 24039 | 5189 | 73 |
2364641 | 2364641 | 2022-04-01 | Somerset | New Jersey | 34035 | 67573 | 967 |
2365153 | 2365153 | 2022-04-01 | Somerset | Pennsylvania | 42111 | 18686 | 401 |
2360774 | 2360774 | 2022-03-31 | Somerset | Maine | 23025 | 9565 | 101 |
2360797 | 2360797 | 2022-03-31 | Somerset | Maryland | 24039 | 5187 | 73 |
2361387 | 2361387 | 2022-03-31 | Somerset | New Jersey | 34035 | 67491 | 967 |
2361900 | 2361900 | 2022-03-31 | Somerset | Pennsylvania | 42111 | 18684 | 401 |
2357520 | 2357520 | 2022-03-30 | Somerset | Maine | 23025 | 9558 | 101 |
2357543 | 2357543 | 2022-03-30 | Somerset | Maryland | 24039 | 5186 | 73 |
2358133 | 2358133 | 2022-03-30 | Somerset | New Jersey | 34035 | 67441 | 967 |
2358646 | 2358646 | 2022-03-30 | Somerset | Pennsylvania | 42111 | 18681 | 401 |
2354267 | 2354267 | 2022-03-29 | Somerset | Maine | 23025 | 9546 | 101 |
2354290 | 2354290 | 2022-03-29 | Somerset | Maryland | 24039 | 5184 | 73 |
2354880 | 2354880 | 2022-03-29 | Somerset | New Jersey | 34035 | 67403 | 967 |
2355392 | 2355392 | 2022-03-29 | Somerset | Pennsylvania | 42111 | 18675 | 401 |
2351015 | 2351015 | 2022-03-28 | Somerset | Maine | 23025 | 9527 | 101 |
2351038 | 2351038 | 2022-03-28 | Somerset | Maryland | 24039 | 5183 | 73 |
2351627 | 2351627 | 2022-03-28 | Somerset | New Jersey | 34035 | 67359 | 967 |
2352139 | 2352139 | 2022-03-28 | Somerset | Pennsylvania | 42111 | 18668 | 400 |
2347762 | 2347762 | 2022-03-27 | Somerset | Maine | 23025 | 9527 | 101 |
2347785 | 2347785 | 2022-03-27 | Somerset | Maryland | 24039 | 5180 | 73 |
2348375 | 2348375 | 2022-03-27 | Somerset | New Jersey | 34035 | 67337 | 966 |
2348887 | 2348887 | 2022-03-27 | Somerset | Pennsylvania | 42111 | 18667 | 400 |
2344509 | 2344509 | 2022-03-26 | Somerset | Maine | 23025 | 9527 | 101 |
2344532 | 2344532 | 2022-03-26 | Somerset | Maryland | 24039 | 5174 | 73 |
2345122 | 2345122 | 2022-03-26 | Somerset | New Jersey | 34035 | 67312 | 966 |
2345634 | 2345634 | 2022-03-26 | Somerset | Pennsylvania | 42111 | 18662 | 400 |
2341256 | 2341256 | 2022-03-25 | Somerset | Maine | 23025 | 9509 | 101 |
2341279 | 2341279 | 2022-03-25 | Somerset | Maryland | 24039 | 5172 | 73 |
2341869 | 2341869 | 2022-03-25 | Somerset | New Jersey | 34035 | 67269 | 966 |
2342381 | 2342381 | 2022-03-25 | Somerset | Pennsylvania | 42111 | 18661 | 399 |
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);