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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
state 3
- Pennsylvania 793
- North Carolina 780
- Virginia 779
county 1
- Northampton · 2,352 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1556 | 1556 | 2020-03-12 | Northampton | Pennsylvania | 42095 | 1 | 0 |
1854 | 1854 | 2020-03-13 | Northampton | Pennsylvania | 42095 | 1 | 0 |
2216 | 2216 | 2020-03-14 | Northampton | Pennsylvania | 42095 | 1 | 0 |
2638 | 2638 | 2020-03-15 | Northampton | Pennsylvania | 42095 | 1 | 0 |
3103 | 3103 | 2020-03-16 | Northampton | Pennsylvania | 42095 | 1 | 0 |
3633 | 3633 | 2020-03-17 | Northampton | Pennsylvania | 42095 | 1 | 0 |
4251 | 4251 | 2020-03-18 | Northampton | Pennsylvania | 42095 | 1 | 1 |
4992 | 4992 | 2020-03-19 | Northampton | Pennsylvania | 42095 | 5 | 1 |
5864 | 5864 | 2020-03-20 | Northampton | Pennsylvania | 42095 | 10 | 1 |
6868 | 6868 | 2020-03-21 | Northampton | Pennsylvania | 42095 | 17 | 1 |
7987 | 7987 | 2020-03-22 | Northampton | Pennsylvania | 42095 | 21 | 1 |
9198 | 9198 | 2020-03-23 | Northampton | Pennsylvania | 42095 | 23 | 1 |
10522 | 10522 | 2020-03-24 | Northampton | Pennsylvania | 42095 | 33 | 2 |
11824 | 11824 | 2020-03-25 | Northampton | North Carolina | 37131 | 1 | 0 |
11987 | 11987 | 2020-03-25 | Northampton | Pennsylvania | 42095 | 44 | 3 |
13428 | 13428 | 2020-03-26 | Northampton | North Carolina | 37131 | 3 | 0 |
13608 | 13608 | 2020-03-26 | Northampton | Pennsylvania | 42095 | 56 | 3 |
13900 | 13900 | 2020-03-26 | Northampton | Virginia | 51131 | 1 | 0 |
15163 | 15163 | 2020-03-27 | Northampton | North Carolina | 37131 | 3 | 0 |
15354 | 15354 | 2020-03-27 | Northampton | Pennsylvania | 42095 | 79 | 3 |
15668 | 15668 | 2020-03-27 | Northampton | Virginia | 51131 | 1 | 0 |
16995 | 16995 | 2020-03-28 | Northampton | North Carolina | 37131 | 4 | 0 |
17205 | 17205 | 2020-03-28 | Northampton | Pennsylvania | 42095 | 94 | 4 |
17546 | 17546 | 2020-03-28 | Northampton | Virginia | 51131 | 1 | 0 |
18926 | 18926 | 2020-03-29 | Northampton | North Carolina | 37131 | 25 | 0 |
19144 | 19144 | 2020-03-29 | Northampton | Pennsylvania | 42095 | 126 | 4 |
19508 | 19508 | 2020-03-29 | Northampton | Virginia | 51131 | 1 | 0 |
20966 | 20966 | 2020-03-30 | Northampton | North Carolina | 37131 | 26 | 0 |
21194 | 21194 | 2020-03-30 | Northampton | Pennsylvania | 42095 | 184 | 5 |
21573 | 21573 | 2020-03-30 | Northampton | Virginia | 51131 | 1 | 0 |
23093 | 23093 | 2020-03-31 | Northampton | North Carolina | 37131 | 30 | 0 |
23330 | 23330 | 2020-03-31 | Northampton | Pennsylvania | 42095 | 245 | 5 |
23719 | 23719 | 2020-03-31 | Northampton | Virginia | 51131 | 1 | 0 |
25287 | 25287 | 2020-04-01 | Northampton | North Carolina | 37131 | 30 | 0 |
25528 | 25528 | 2020-04-01 | Northampton | Pennsylvania | 42095 | 312 | 5 |
25935 | 25935 | 2020-04-01 | Northampton | Virginia | 51131 | 1 | 0 |
27552 | 27552 | 2020-04-02 | Northampton | North Carolina | 37131 | 30 | 0 |
27801 | 27801 | 2020-04-02 | Northampton | Pennsylvania | 42095 | 378 | 9 |
28225 | 28225 | 2020-04-02 | Northampton | Virginia | 51131 | 1 | 0 |
29879 | 29879 | 2020-04-03 | Northampton | North Carolina | 37131 | 33 | 0 |
30135 | 30135 | 2020-04-03 | Northampton | Pennsylvania | 42095 | 466 | 10 |
30572 | 30572 | 2020-04-03 | Northampton | Virginia | 51131 | 2 | 0 |
32266 | 32266 | 2020-04-04 | Northampton | North Carolina | 37131 | 36 | 0 |
32525 | 32525 | 2020-04-04 | Northampton | Pennsylvania | 42095 | 588 | 11 |
32971 | 32971 | 2020-04-04 | Northampton | Virginia | 51131 | 2 | 0 |
34697 | 34697 | 2020-04-05 | Northampton | North Carolina | 37131 | 42 | 0 |
34961 | 34961 | 2020-04-05 | Northampton | Pennsylvania | 42095 | 636 | 11 |
35409 | 35409 | 2020-04-05 | Northampton | Virginia | 51131 | 2 | 0 |
37166 | 37166 | 2020-04-06 | Northampton | North Carolina | 37131 | 46 | 0 |
37436 | 37436 | 2020-04-06 | Northampton | Pennsylvania | 42095 | 716 | 12 |
37892 | 37892 | 2020-04-06 | Northampton | Virginia | 51131 | 2 | 0 |
39681 | 39681 | 2020-04-07 | Northampton | North Carolina | 37131 | 51 | 0 |
39959 | 39959 | 2020-04-07 | Northampton | Pennsylvania | 42095 | 774 | 14 |
40426 | 40426 | 2020-04-07 | Northampton | Virginia | 51131 | 2 | 0 |
42238 | 42238 | 2020-04-08 | Northampton | North Carolina | 37131 | 52 | 0 |
42519 | 42519 | 2020-04-08 | Northampton | Pennsylvania | 42095 | 857 | 17 |
42995 | 42995 | 2020-04-08 | Northampton | Virginia | 51131 | 2 | 0 |
44822 | 44822 | 2020-04-09 | Northampton | North Carolina | 37131 | 54 | 0 |
45105 | 45105 | 2020-04-09 | Northampton | Pennsylvania | 42095 | 949 | 20 |
45591 | 45591 | 2020-04-09 | Northampton | Virginia | 51131 | 2 | 0 |
47435 | 47435 | 2020-04-10 | Northampton | North Carolina | 37131 | 55 | 0 |
47722 | 47722 | 2020-04-10 | Northampton | Pennsylvania | 42095 | 994 | 21 |
48217 | 48217 | 2020-04-10 | Northampton | Virginia | 51131 | 4 | 0 |
50090 | 50090 | 2020-04-11 | Northampton | North Carolina | 37131 | 60 | 0 |
50379 | 50379 | 2020-04-11 | Northampton | Pennsylvania | 42095 | 1039 | 23 |
50875 | 50875 | 2020-04-11 | Northampton | Virginia | 51131 | 4 | 0 |
52763 | 52763 | 2020-04-12 | Northampton | North Carolina | 37131 | 61 | 0 |
53052 | 53052 | 2020-04-12 | Northampton | Pennsylvania | 42095 | 1082 | 23 |
53550 | 53550 | 2020-04-12 | Northampton | Virginia | 51131 | 4 | 0 |
55447 | 55447 | 2020-04-13 | Northampton | North Carolina | 37131 | 61 | 0 |
55737 | 55737 | 2020-04-13 | Northampton | Pennsylvania | 42095 | 1130 | 23 |
56240 | 56240 | 2020-04-13 | Northampton | Virginia | 51131 | 4 | 0 |
58147 | 58147 | 2020-04-14 | Northampton | North Carolina | 37131 | 63 | 0 |
58440 | 58440 | 2020-04-14 | Northampton | Pennsylvania | 42095 | 1176 | 25 |
58946 | 58946 | 2020-04-14 | Northampton | Virginia | 51131 | 4 | 0 |
60861 | 60861 | 2020-04-15 | Northampton | North Carolina | 37131 | 65 | 0 |
61155 | 61155 | 2020-04-15 | Northampton | Pennsylvania | 42095 | 1251 | 25 |
61665 | 61665 | 2020-04-15 | Northampton | Virginia | 51131 | 4 | 0 |
63587 | 63587 | 2020-04-16 | Northampton | North Carolina | 37131 | 69 | 1 |
63881 | 63881 | 2020-04-16 | Northampton | Pennsylvania | 42095 | 1296 | 25 |
64398 | 64398 | 2020-04-16 | Northampton | Virginia | 51131 | 4 | 0 |
66330 | 66330 | 2020-04-17 | Northampton | North Carolina | 37131 | 69 | 1 |
66627 | 66627 | 2020-04-17 | Northampton | Pennsylvania | 42095 | 1335 | 27 |
67146 | 67146 | 2020-04-17 | Northampton | Virginia | 51131 | 5 | 0 |
69087 | 69087 | 2020-04-18 | Northampton | North Carolina | 37131 | 69 | 2 |
69385 | 69385 | 2020-04-18 | Northampton | Pennsylvania | 42095 | 1396 | 29 |
69908 | 69908 | 2020-04-18 | Northampton | Virginia | 51131 | 5 | 0 |
71853 | 71853 | 2020-04-19 | Northampton | North Carolina | 37131 | 72 | 2 |
72152 | 72152 | 2020-04-19 | Northampton | Pennsylvania | 42095 | 1441 | 36 |
72678 | 72678 | 2020-04-19 | Northampton | Virginia | 51131 | 7 | 0 |
74628 | 74628 | 2020-04-20 | Northampton | North Carolina | 37131 | 72 | 2 |
74927 | 74927 | 2020-04-20 | Northampton | Pennsylvania | 42095 | 1469 | 36 |
75454 | 75454 | 2020-04-20 | Northampton | Virginia | 51131 | 7 | 0 |
77409 | 77409 | 2020-04-21 | Northampton | North Carolina | 37131 | 73 | 2 |
77709 | 77709 | 2020-04-21 | Northampton | Pennsylvania | 42095 | 1544 | 43 |
78236 | 78236 | 2020-04-21 | Northampton | Virginia | 51131 | 7 | 0 |
80198 | 80198 | 2020-04-22 | Northampton | North Carolina | 37131 | 73 | 2 |
80499 | 80499 | 2020-04-22 | Northampton | Pennsylvania | 42095 | 1591 | 44 |
81029 | 81029 | 2020-04-22 | Northampton | Virginia | 51131 | 8 | 0 |
82997 | 82997 | 2020-04-23 | Northampton | North Carolina | 37131 | 74 | 2 |
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);