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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, 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 |
11824 | 11824 | 2020-03-25 | Northampton | North Carolina | 37131 | 1 | 0 |
13428 | 13428 | 2020-03-26 | Northampton | North Carolina | 37131 | 3 | 0 |
13900 | 13900 | 2020-03-26 | Northampton | Virginia | 51131 | 1 | 0 |
15163 | 15163 | 2020-03-27 | Northampton | North Carolina | 37131 | 3 | 0 |
15668 | 15668 | 2020-03-27 | Northampton | Virginia | 51131 | 1 | 0 |
16995 | 16995 | 2020-03-28 | Northampton | North Carolina | 37131 | 4 | 0 |
17546 | 17546 | 2020-03-28 | Northampton | Virginia | 51131 | 1 | 0 |
18926 | 18926 | 2020-03-29 | Northampton | North Carolina | 37131 | 25 | 0 |
19508 | 19508 | 2020-03-29 | Northampton | Virginia | 51131 | 1 | 0 |
20966 | 20966 | 2020-03-30 | Northampton | North Carolina | 37131 | 26 | 0 |
21573 | 21573 | 2020-03-30 | Northampton | Virginia | 51131 | 1 | 0 |
23093 | 23093 | 2020-03-31 | Northampton | North Carolina | 37131 | 30 | 0 |
23719 | 23719 | 2020-03-31 | Northampton | Virginia | 51131 | 1 | 0 |
25287 | 25287 | 2020-04-01 | Northampton | North Carolina | 37131 | 30 | 0 |
25935 | 25935 | 2020-04-01 | Northampton | Virginia | 51131 | 1 | 0 |
27552 | 27552 | 2020-04-02 | Northampton | North Carolina | 37131 | 30 | 0 |
28225 | 28225 | 2020-04-02 | Northampton | Virginia | 51131 | 1 | 0 |
29879 | 29879 | 2020-04-03 | Northampton | North Carolina | 37131 | 33 | 0 |
30572 | 30572 | 2020-04-03 | Northampton | Virginia | 51131 | 2 | 0 |
32266 | 32266 | 2020-04-04 | Northampton | North Carolina | 37131 | 36 | 0 |
32971 | 32971 | 2020-04-04 | Northampton | Virginia | 51131 | 2 | 0 |
34697 | 34697 | 2020-04-05 | Northampton | North Carolina | 37131 | 42 | 0 |
35409 | 35409 | 2020-04-05 | Northampton | Virginia | 51131 | 2 | 0 |
37166 | 37166 | 2020-04-06 | Northampton | North Carolina | 37131 | 46 | 0 |
37892 | 37892 | 2020-04-06 | Northampton | Virginia | 51131 | 2 | 0 |
39681 | 39681 | 2020-04-07 | Northampton | North Carolina | 37131 | 51 | 0 |
40426 | 40426 | 2020-04-07 | Northampton | Virginia | 51131 | 2 | 0 |
42238 | 42238 | 2020-04-08 | Northampton | North Carolina | 37131 | 52 | 0 |
42995 | 42995 | 2020-04-08 | Northampton | Virginia | 51131 | 2 | 0 |
44822 | 44822 | 2020-04-09 | Northampton | North Carolina | 37131 | 54 | 0 |
45591 | 45591 | 2020-04-09 | Northampton | Virginia | 51131 | 2 | 0 |
47435 | 47435 | 2020-04-10 | Northampton | North Carolina | 37131 | 55 | 0 |
48217 | 48217 | 2020-04-10 | Northampton | Virginia | 51131 | 4 | 0 |
50090 | 50090 | 2020-04-11 | Northampton | North Carolina | 37131 | 60 | 0 |
50875 | 50875 | 2020-04-11 | Northampton | Virginia | 51131 | 4 | 0 |
52763 | 52763 | 2020-04-12 | Northampton | North Carolina | 37131 | 61 | 0 |
53550 | 53550 | 2020-04-12 | Northampton | Virginia | 51131 | 4 | 0 |
55447 | 55447 | 2020-04-13 | Northampton | North Carolina | 37131 | 61 | 0 |
56240 | 56240 | 2020-04-13 | Northampton | Virginia | 51131 | 4 | 0 |
58147 | 58147 | 2020-04-14 | Northampton | North Carolina | 37131 | 63 | 0 |
58946 | 58946 | 2020-04-14 | Northampton | Virginia | 51131 | 4 | 0 |
60861 | 60861 | 2020-04-15 | Northampton | North Carolina | 37131 | 65 | 0 |
61665 | 61665 | 2020-04-15 | Northampton | Virginia | 51131 | 4 | 0 |
64398 | 64398 | 2020-04-16 | Northampton | Virginia | 51131 | 4 | 0 |
67146 | 67146 | 2020-04-17 | Northampton | Virginia | 51131 | 5 | 0 |
69908 | 69908 | 2020-04-18 | Northampton | Virginia | 51131 | 5 | 0 |
72678 | 72678 | 2020-04-19 | Northampton | Virginia | 51131 | 7 | 0 |
75454 | 75454 | 2020-04-20 | Northampton | Virginia | 51131 | 7 | 0 |
78236 | 78236 | 2020-04-21 | Northampton | Virginia | 51131 | 7 | 0 |
81029 | 81029 | 2020-04-22 | Northampton | Virginia | 51131 | 8 | 0 |
83830 | 83830 | 2020-04-23 | Northampton | Virginia | 51131 | 12 | 0 |
86637 | 86637 | 2020-04-24 | Northampton | Virginia | 51131 | 15 | 0 |
89452 | 89452 | 2020-04-25 | Northampton | Virginia | 51131 | 20 | 0 |
92269 | 92269 | 2020-04-26 | Northampton | Virginia | 51131 | 24 | 0 |
95098 | 95098 | 2020-04-27 | Northampton | Virginia | 51131 | 28 | 0 |
97942 | 97942 | 2020-04-28 | Northampton | Virginia | 51131 | 35 | 0 |
100792 | 100792 | 2020-04-29 | Northampton | Virginia | 51131 | 36 | 0 |
103647 | 103647 | 2020-04-30 | Northampton | Virginia | 51131 | 64 | 0 |
106511 | 106511 | 2020-05-01 | Northampton | Virginia | 51131 | 82 | 0 |
109380 | 109380 | 2020-05-02 | Northampton | Virginia | 51131 | 94 | 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 |
63587 | 63587 | 2020-04-16 | Northampton | North Carolina | 37131 | 69 | 1 |
66330 | 66330 | 2020-04-17 | Northampton | North Carolina | 37131 | 69 | 1 |
112254 | 112254 | 2020-05-03 | Northampton | Virginia | 51131 | 134 | 1 |
115137 | 115137 | 2020-05-04 | Northampton | Virginia | 51131 | 139 | 1 |
118096 | 118096 | 2020-05-05 | Northampton | Virginia | 51131 | 140 | 1 |
121060 | 121060 | 2020-05-06 | Northampton | Virginia | 51131 | 140 | 1 |
10522 | 10522 | 2020-03-24 | Northampton | Pennsylvania | 42095 | 33 | 2 |
69087 | 69087 | 2020-04-18 | Northampton | North Carolina | 37131 | 69 | 2 |
71853 | 71853 | 2020-04-19 | Northampton | North Carolina | 37131 | 72 | 2 |
74628 | 74628 | 2020-04-20 | Northampton | North Carolina | 37131 | 72 | 2 |
77409 | 77409 | 2020-04-21 | Northampton | North Carolina | 37131 | 73 | 2 |
80198 | 80198 | 2020-04-22 | Northampton | North Carolina | 37131 | 73 | 2 |
82997 | 82997 | 2020-04-23 | Northampton | North Carolina | 37131 | 74 | 2 |
11987 | 11987 | 2020-03-25 | Northampton | Pennsylvania | 42095 | 44 | 3 |
13608 | 13608 | 2020-03-26 | Northampton | Pennsylvania | 42095 | 56 | 3 |
15354 | 15354 | 2020-03-27 | Northampton | Pennsylvania | 42095 | 79 | 3 |
85801 | 85801 | 2020-04-24 | Northampton | North Carolina | 37131 | 79 | 3 |
88614 | 88614 | 2020-04-25 | Northampton | North Carolina | 37131 | 80 | 3 |
91429 | 91429 | 2020-04-26 | Northampton | North Carolina | 37131 | 80 | 3 |
124041 | 124041 | 2020-05-07 | Northampton | Virginia | 51131 | 149 | 3 |
17205 | 17205 | 2020-03-28 | Northampton | Pennsylvania | 42095 | 94 | 4 |
19144 | 19144 | 2020-03-29 | Northampton | Pennsylvania | 42095 | 126 | 4 |
94255 | 94255 | 2020-04-27 | Northampton | North Carolina | 37131 | 81 | 4 |
97092 | 97092 | 2020-04-28 | Northampton | North Carolina | 37131 | 81 | 4 |
99940 | 99940 | 2020-04-29 | Northampton | North Carolina | 37131 | 81 | 4 |
102793 | 102793 | 2020-04-30 | Northampton | North Carolina | 37131 | 82 | 4 |
105655 | 105655 | 2020-05-01 | Northampton | North Carolina | 37131 | 87 | 4 |
108522 | 108522 | 2020-05-02 | Northampton | North Carolina | 37131 | 89 | 4 |
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);