ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Sampson" and state = "North Carolina" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
3577 | 3577 | 2020-03-17 | Sampson | North Carolina | 37163 | 1 | 0 |
4186 | 4186 | 2020-03-18 | Sampson | North Carolina | 37163 | 1 | 0 |
4917 | 4917 | 2020-03-19 | Sampson | North Carolina | 37163 | 1 | 0 |
5775 | 5775 | 2020-03-20 | Sampson | North Carolina | 37163 | 1 | 0 |
6772 | 6772 | 2020-03-21 | Sampson | North Carolina | 37163 | 1 | 0 |
7876 | 7876 | 2020-03-22 | Sampson | North Carolina | 37163 | 1 | 0 |
9077 | 9077 | 2020-03-23 | Sampson | North Carolina | 37163 | 1 | 0 |
10387 | 10387 | 2020-03-24 | Sampson | North Carolina | 37163 | 1 | 0 |
11832 | 11832 | 2020-03-25 | Sampson | North Carolina | 37163 | 1 | 0 |
13436 | 13436 | 2020-03-26 | Sampson | North Carolina | 37163 | 1 | 0 |
15172 | 15172 | 2020-03-27 | Sampson | North Carolina | 37163 | 1 | 0 |
17006 | 17006 | 2020-03-28 | Sampson | North Carolina | 37163 | 1 | 0 |
18938 | 18938 | 2020-03-29 | Sampson | North Carolina | 37163 | 1 | 0 |
20979 | 20979 | 2020-03-30 | Sampson | North Carolina | 37163 | 1 | 0 |
23107 | 23107 | 2020-03-31 | Sampson | North Carolina | 37163 | 1 | 0 |
25301 | 25301 | 2020-04-01 | Sampson | North Carolina | 37163 | 1 | 0 |
27566 | 27566 | 2020-04-02 | Sampson | North Carolina | 37163 | 1 | 0 |
29893 | 29893 | 2020-04-03 | Sampson | North Carolina | 37163 | 1 | 0 |
32280 | 32280 | 2020-04-04 | Sampson | North Carolina | 37163 | 2 | 0 |
34712 | 34712 | 2020-04-05 | Sampson | North Carolina | 37163 | 2 | 0 |
37181 | 37181 | 2020-04-06 | Sampson | North Carolina | 37163 | 3 | 0 |
39697 | 39697 | 2020-04-07 | Sampson | North Carolina | 37163 | 4 | 0 |
42254 | 42254 | 2020-04-08 | Sampson | North Carolina | 37163 | 5 | 0 |
44838 | 44838 | 2020-04-09 | Sampson | North Carolina | 37163 | 8 | 0 |
47451 | 47451 | 2020-04-10 | Sampson | North Carolina | 37163 | 10 | 0 |
50106 | 50106 | 2020-04-11 | Sampson | North Carolina | 37163 | 11 | 0 |
52779 | 52779 | 2020-04-12 | Sampson | North Carolina | 37163 | 11 | 0 |
55463 | 55463 | 2020-04-13 | Sampson | North Carolina | 37163 | 13 | 0 |
58163 | 58163 | 2020-04-14 | Sampson | North Carolina | 37163 | 13 | 0 |
60877 | 60877 | 2020-04-15 | Sampson | North Carolina | 37163 | 13 | 0 |
63603 | 63603 | 2020-04-16 | Sampson | North Carolina | 37163 | 16 | 0 |
66346 | 66346 | 2020-04-17 | Sampson | North Carolina | 37163 | 18 | 0 |
69103 | 69103 | 2020-04-18 | Sampson | North Carolina | 37163 | 19 | 0 |
71869 | 71869 | 2020-04-19 | Sampson | North Carolina | 37163 | 22 | 0 |
74644 | 74644 | 2020-04-20 | Sampson | North Carolina | 37163 | 22 | 0 |
77425 | 77425 | 2020-04-21 | Sampson | North Carolina | 37163 | 21 | 0 |
80214 | 80214 | 2020-04-22 | Sampson | North Carolina | 37163 | 23 | 0 |
83013 | 83013 | 2020-04-23 | Sampson | North Carolina | 37163 | 25 | 0 |
85817 | 85817 | 2020-04-24 | Sampson | North Carolina | 37163 | 31 | 0 |
88630 | 88630 | 2020-04-25 | Sampson | North Carolina | 37163 | 36 | 0 |
91445 | 91445 | 2020-04-26 | Sampson | North Carolina | 37163 | 39 | 0 |
94271 | 94271 | 2020-04-27 | Sampson | North Carolina | 37163 | 39 | 0 |
97108 | 97108 | 2020-04-28 | Sampson | North Carolina | 37163 | 44 | 0 |
99956 | 99956 | 2020-04-29 | Sampson | North Carolina | 37163 | 51 | 0 |
102809 | 102809 | 2020-04-30 | Sampson | North Carolina | 37163 | 63 | 0 |
105671 | 105671 | 2020-05-01 | Sampson | North Carolina | 37163 | 65 | 0 |
108538 | 108538 | 2020-05-02 | Sampson | North Carolina | 37163 | 83 | 0 |
111411 | 111411 | 2020-05-03 | Sampson | North Carolina | 37163 | 88 | 0 |
114292 | 114292 | 2020-05-04 | Sampson | North Carolina | 37163 | 88 | 0 |
117172 | 117172 | 2020-05-05 | Sampson | North Carolina | 37163 | 94 | 1 |
120133 | 120133 | 2020-05-06 | Sampson | North Carolina | 37163 | 108 | 1 |
123108 | 123108 | 2020-05-07 | Sampson | North Carolina | 37163 | 126 | 1 |
126091 | 126091 | 2020-05-08 | Sampson | North Carolina | 37163 | 136 | 1 |
129080 | 129080 | 2020-05-09 | Sampson | North Carolina | 37163 | 145 | 1 |
132069 | 132069 | 2020-05-10 | Sampson | North Carolina | 37163 | 156 | 1 |
135060 | 135060 | 2020-05-11 | Sampson | North Carolina | 37163 | 167 | 1 |
138050 | 138050 | 2020-05-12 | Sampson | North Carolina | 37163 | 170 | 1 |
141046 | 141046 | 2020-05-13 | Sampson | North Carolina | 37163 | 176 | 1 |
144041 | 144041 | 2020-05-14 | Sampson | North Carolina | 37163 | 203 | 1 |
147042 | 147042 | 2020-05-15 | Sampson | North Carolina | 37163 | 219 | 1 |
150049 | 150049 | 2020-05-16 | Sampson | North Carolina | 37163 | 232 | 1 |
153059 | 153059 | 2020-05-17 | Sampson | North Carolina | 37163 | 244 | 1 |
156076 | 156076 | 2020-05-18 | Sampson | North Carolina | 37163 | 259 | 1 |
159095 | 159095 | 2020-05-19 | Sampson | North Carolina | 37163 | 265 | 1 |
162122 | 162122 | 2020-05-20 | Sampson | North Carolina | 37163 | 273 | 1 |
165151 | 165151 | 2020-05-21 | Sampson | North Carolina | 37163 | 315 | 1 |
168186 | 168186 | 2020-05-22 | Sampson | North Carolina | 37163 | 345 | 1 |
171225 | 171225 | 2020-05-23 | Sampson | North Carolina | 37163 | 367 | 1 |
174267 | 174267 | 2020-05-24 | Sampson | North Carolina | 37163 | 385 | 1 |
177311 | 177311 | 2020-05-25 | Sampson | North Carolina | 37163 | 408 | 1 |
180354 | 180354 | 2020-05-26 | Sampson | North Carolina | 37163 | 409 | 1 |
183402 | 183402 | 2020-05-27 | Sampson | North Carolina | 37163 | 408 | 1 |
186459 | 186459 | 2020-05-28 | Sampson | North Carolina | 37163 | 412 | 4 |
189519 | 189519 | 2020-05-29 | Sampson | North Carolina | 37163 | 429 | 4 |
192583 | 192583 | 2020-05-30 | Sampson | North Carolina | 37163 | 462 | 4 |
195653 | 195653 | 2020-05-31 | Sampson | North Carolina | 37163 | 479 | 4 |
198726 | 198726 | 2020-06-01 | Sampson | North Carolina | 37163 | 499 | 4 |
201800 | 201800 | 2020-06-02 | Sampson | North Carolina | 37163 | 499 | 4 |
204877 | 204877 | 2020-06-03 | Sampson | North Carolina | 37163 | 509 | 4 |
207958 | 207958 | 2020-06-04 | Sampson | North Carolina | 37163 | 531 | 4 |
211040 | 211040 | 2020-06-05 | Sampson | North Carolina | 37163 | 553 | 4 |
214124 | 214124 | 2020-06-06 | Sampson | North Carolina | 37163 | 571 | 4 |
217214 | 217214 | 2020-06-07 | Sampson | North Carolina | 37163 | 597 | 4 |
220306 | 220306 | 2020-06-08 | Sampson | North Carolina | 37163 | 621 | 4 |
223400 | 223400 | 2020-06-09 | Sampson | North Carolina | 37163 | 626 | 4 |
226500 | 226500 | 2020-06-10 | Sampson | North Carolina | 37163 | 627 | 4 |
229604 | 229604 | 2020-06-11 | Sampson | North Carolina | 37163 | 642 | 4 |
232709 | 232709 | 2020-06-12 | Sampson | North Carolina | 37163 | 702 | 4 |
235814 | 235814 | 2020-06-13 | Sampson | North Carolina | 37163 | 728 | 4 |
238922 | 238922 | 2020-06-14 | Sampson | North Carolina | 37163 | 760 | 4 |
242031 | 242031 | 2020-06-15 | Sampson | North Carolina | 37163 | 779 | 4 |
245143 | 245143 | 2020-06-16 | Sampson | North Carolina | 37163 | 783 | 4 |
248256 | 248256 | 2020-06-17 | Sampson | North Carolina | 37163 | 791 | 4 |
251371 | 251371 | 2020-06-18 | Sampson | North Carolina | 37163 | 802 | 4 |
254486 | 254486 | 2020-06-19 | Sampson | North Carolina | 37163 | 835 | 4 |
257609 | 257609 | 2020-06-20 | Sampson | North Carolina | 37163 | 865 | 5 |
260736 | 260736 | 2020-06-21 | Sampson | North Carolina | 37163 | 877 | 5 |
263864 | 263864 | 2020-06-22 | Sampson | North Carolina | 37163 | 894 | 5 |
266992 | 266992 | 2020-06-23 | Sampson | North Carolina | 37163 | 907 | 5 |
270126 | 270126 | 2020-06-24 | Sampson | North Carolina | 37163 | 932 | 5 |
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);