ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,352 rows where county = "Northampton" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 3
- Pennsylvania 760
- North Carolina 746
- Virginia 746
county 1
- Northampton · 2,252 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2394434 | 2394434 | 2022-04-10 | Northampton | Pennsylvania | 42095 | 79623 | 1086 |
2395135 | 2395135 | 2022-04-10 | Northampton | Virginia | 51131 | 2147 | 63 |
2390835 | 2390835 | 2022-04-09 | Northampton | North Carolina | 37131 | 4316 | 82 |
2391178 | 2391178 | 2022-04-09 | Northampton | Pennsylvania | 42095 | 79596 | 1086 |
2391879 | 2391879 | 2022-04-09 | Northampton | Virginia | 51131 | 2147 | 63 |
2387579 | 2387579 | 2022-04-08 | Northampton | North Carolina | 37131 | 4316 | 82 |
2387922 | 2387922 | 2022-04-08 | Northampton | Pennsylvania | 42095 | 79555 | 1086 |
2388623 | 2388623 | 2022-04-08 | Northampton | Virginia | 51131 | 2147 | 63 |
2384324 | 2384324 | 2022-04-07 | Northampton | North Carolina | 37131 | 4316 | 82 |
2384667 | 2384667 | 2022-04-07 | Northampton | Pennsylvania | 42095 | 79524 | 1086 |
2385368 | 2385368 | 2022-04-07 | Northampton | Virginia | 51131 | 2147 | 63 |
2381069 | 2381069 | 2022-04-06 | Northampton | North Carolina | 37131 | 4316 | 82 |
2381412 | 2381412 | 2022-04-06 | Northampton | Pennsylvania | 42095 | 79486 | 1085 |
2382113 | 2382113 | 2022-04-06 | Northampton | Virginia | 51131 | 2145 | 63 |
2377814 | 2377814 | 2022-04-05 | Northampton | North Carolina | 37131 | 4317 | 82 |
2378157 | 2378157 | 2022-04-05 | Northampton | Pennsylvania | 42095 | 79456 | 1083 |
2378858 | 2378858 | 2022-04-05 | Northampton | Virginia | 51131 | 2144 | 62 |
2374561 | 2374561 | 2022-04-04 | Northampton | North Carolina | 37131 | 4317 | 82 |
2374903 | 2374903 | 2022-04-04 | Northampton | Pennsylvania | 42095 | 79432 | 1083 |
2375604 | 2375604 | 2022-04-04 | Northampton | Virginia | 51131 | 2143 | 61 |
2371309 | 2371309 | 2022-04-03 | Northampton | North Carolina | 37131 | 4315 | 82 |
2371651 | 2371651 | 2022-04-03 | Northampton | Pennsylvania | 42095 | 79418 | 1083 |
2372352 | 2372352 | 2022-04-03 | Northampton | Virginia | 51131 | 2148 | 61 |
2368056 | 2368056 | 2022-04-02 | Northampton | North Carolina | 37131 | 4315 | 82 |
2368398 | 2368398 | 2022-04-02 | Northampton | Pennsylvania | 42095 | 79418 | 1083 |
2369099 | 2369099 | 2022-04-02 | Northampton | Virginia | 51131 | 2148 | 61 |
2364803 | 2364803 | 2022-04-01 | Northampton | North Carolina | 37131 | 4315 | 82 |
2365145 | 2365145 | 2022-04-01 | Northampton | Pennsylvania | 42095 | 79393 | 1082 |
2365846 | 2365846 | 2022-04-01 | Northampton | Virginia | 51131 | 2148 | 61 |
2361549 | 2361549 | 2022-03-31 | Northampton | North Carolina | 37131 | 4314 | 82 |
2361892 | 2361892 | 2022-03-31 | Northampton | Pennsylvania | 42095 | 79364 | 1082 |
2362593 | 2362593 | 2022-03-31 | Northampton | Virginia | 51131 | 2148 | 61 |
2358295 | 2358295 | 2022-03-30 | Northampton | North Carolina | 37131 | 4314 | 82 |
2358638 | 2358638 | 2022-03-30 | Northampton | Pennsylvania | 42095 | 79332 | 1082 |
2359339 | 2359339 | 2022-03-30 | Northampton | Virginia | 51131 | 2149 | 61 |
2355041 | 2355041 | 2022-03-29 | Northampton | North Carolina | 37131 | 4314 | 82 |
2355384 | 2355384 | 2022-03-29 | Northampton | Pennsylvania | 42095 | 79314 | 1082 |
2356085 | 2356085 | 2022-03-29 | Northampton | Virginia | 51131 | 2149 | 61 |
2351788 | 2351788 | 2022-03-28 | Northampton | North Carolina | 37131 | 4313 | 82 |
2352131 | 2352131 | 2022-03-28 | Northampton | Pennsylvania | 42095 | 79299 | 1082 |
2352832 | 2352832 | 2022-03-28 | Northampton | Virginia | 51131 | 2150 | 61 |
2348536 | 2348536 | 2022-03-27 | Northampton | North Carolina | 37131 | 4312 | 82 |
2348879 | 2348879 | 2022-03-27 | Northampton | Pennsylvania | 42095 | 79291 | 1082 |
2349580 | 2349580 | 2022-03-27 | Northampton | Virginia | 51131 | 2148 | 61 |
2345283 | 2345283 | 2022-03-26 | Northampton | North Carolina | 37131 | 4312 | 82 |
2345626 | 2345626 | 2022-03-26 | Northampton | Pennsylvania | 42095 | 79276 | 1082 |
2346327 | 2346327 | 2022-03-26 | Northampton | Virginia | 51131 | 2148 | 61 |
2342030 | 2342030 | 2022-03-25 | Northampton | North Carolina | 37131 | 4312 | 82 |
2342373 | 2342373 | 2022-03-25 | Northampton | Pennsylvania | 42095 | 79254 | 1080 |
2343074 | 2343074 | 2022-03-25 | Northampton | Virginia | 51131 | 2148 | 61 |
2338777 | 2338777 | 2022-03-24 | Northampton | North Carolina | 37131 | 4315 | 82 |
2339120 | 2339120 | 2022-03-24 | Northampton | Pennsylvania | 42095 | 79224 | 1079 |
2339821 | 2339821 | 2022-03-24 | Northampton | Virginia | 51131 | 2144 | 61 |
2335523 | 2335523 | 2022-03-23 | Northampton | North Carolina | 37131 | 4312 | 82 |
2335866 | 2335866 | 2022-03-23 | Northampton | Pennsylvania | 42095 | 79182 | 1079 |
2336567 | 2336567 | 2022-03-23 | Northampton | Virginia | 51131 | 2144 | 61 |
2332269 | 2332269 | 2022-03-22 | Northampton | North Carolina | 37131 | 4311 | 82 |
2332612 | 2332612 | 2022-03-22 | Northampton | Pennsylvania | 42095 | 79169 | 1079 |
2333313 | 2333313 | 2022-03-22 | Northampton | Virginia | 51131 | 2144 | 61 |
2329016 | 2329016 | 2022-03-21 | Northampton | North Carolina | 37131 | 4311 | 82 |
2329359 | 2329359 | 2022-03-21 | Northampton | Pennsylvania | 42095 | 79166 | 1079 |
2330060 | 2330060 | 2022-03-21 | Northampton | Virginia | 51131 | 2144 | 61 |
2325764 | 2325764 | 2022-03-20 | Northampton | North Carolina | 37131 | 4311 | 82 |
2326107 | 2326107 | 2022-03-20 | Northampton | Pennsylvania | 42095 | 79153 | 1079 |
2326808 | 2326808 | 2022-03-20 | Northampton | Virginia | 51131 | 2143 | 61 |
2322511 | 2322511 | 2022-03-19 | Northampton | North Carolina | 37131 | 4311 | 82 |
2322854 | 2322854 | 2022-03-19 | Northampton | Pennsylvania | 42095 | 79129 | 1079 |
2323555 | 2323555 | 2022-03-19 | Northampton | Virginia | 51131 | 2143 | 61 |
2319257 | 2319257 | 2022-03-18 | Northampton | North Carolina | 37131 | 4311 | 82 |
2319600 | 2319600 | 2022-03-18 | Northampton | Pennsylvania | 42095 | 79114 | 1079 |
2320301 | 2320301 | 2022-03-18 | Northampton | Virginia | 51131 | 2143 | 61 |
2316003 | 2316003 | 2022-03-17 | Northampton | North Carolina | 37131 | 4307 | 82 |
2316346 | 2316346 | 2022-03-17 | Northampton | Pennsylvania | 42095 | 79092 | 1079 |
2317047 | 2317047 | 2022-03-17 | Northampton | Virginia | 51131 | 2142 | 61 |
2312750 | 2312750 | 2022-03-16 | Northampton | North Carolina | 37131 | 4307 | 82 |
2313093 | 2313093 | 2022-03-16 | Northampton | Pennsylvania | 42095 | 79078 | 1078 |
2313794 | 2313794 | 2022-03-16 | Northampton | Virginia | 51131 | 2142 | 61 |
2309497 | 2309497 | 2022-03-15 | Northampton | North Carolina | 37131 | 4305 | 82 |
2309840 | 2309840 | 2022-03-15 | Northampton | Pennsylvania | 42095 | 79066 | 1077 |
2310541 | 2310541 | 2022-03-15 | Northampton | Virginia | 51131 | 2141 | 61 |
2306244 | 2306244 | 2022-03-14 | Northampton | North Carolina | 37131 | 4304 | 82 |
2306587 | 2306587 | 2022-03-14 | Northampton | Pennsylvania | 42095 | 79052 | 1077 |
2307288 | 2307288 | 2022-03-14 | Northampton | Virginia | 51131 | 2136 | 61 |
2302993 | 2302993 | 2022-03-13 | Northampton | North Carolina | 37131 | 4304 | 82 |
2303336 | 2303336 | 2022-03-13 | Northampton | Pennsylvania | 42095 | 79045 | 1077 |
2304037 | 2304037 | 2022-03-13 | Northampton | Virginia | 51131 | 2135 | 61 |
2299741 | 2299741 | 2022-03-12 | Northampton | North Carolina | 37131 | 4304 | 82 |
2300084 | 2300084 | 2022-03-12 | Northampton | Pennsylvania | 42095 | 79039 | 1077 |
2300785 | 2300785 | 2022-03-12 | Northampton | Virginia | 51131 | 2135 | 61 |
2296489 | 2296489 | 2022-03-11 | Northampton | North Carolina | 37131 | 4304 | 82 |
2296832 | 2296832 | 2022-03-11 | Northampton | Pennsylvania | 42095 | 79014 | 1076 |
2297533 | 2297533 | 2022-03-11 | Northampton | Virginia | 51131 | 2135 | 61 |
2293237 | 2293237 | 2022-03-10 | Northampton | North Carolina | 37131 | 4304 | 82 |
2293580 | 2293580 | 2022-03-10 | Northampton | Pennsylvania | 42095 | 78999 | 1076 |
2294281 | 2294281 | 2022-03-10 | Northampton | Virginia | 51131 | 2135 | 61 |
2289985 | 2289985 | 2022-03-09 | Northampton | North Carolina | 37131 | 4303 | 82 |
2290328 | 2290328 | 2022-03-09 | Northampton | Pennsylvania | 42095 | 78974 | 1074 |
2291029 | 2291029 | 2022-03-09 | Northampton | Virginia | 51131 | 2134 | 61 |
2286733 | 2286733 | 2022-03-08 | Northampton | North Carolina | 37131 | 4300 | 80 |
2287076 | 2287076 | 2022-03-08 | Northampton | Pennsylvania | 42095 | 78952 | 1073 |
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);