ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 37037 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 ▼ |
---|---|---|---|---|---|---|---|
631 | 631 | 2020-03-06 | Chatham | North Carolina | 37037 | 1 | 0 |
720 | 720 | 2020-03-07 | Chatham | North Carolina | 37037 | 1 | 0 |
827 | 827 | 2020-03-08 | Chatham | North Carolina | 37037 | 1 | 0 |
954 | 954 | 2020-03-09 | Chatham | North Carolina | 37037 | 1 | 0 |
1105 | 1105 | 2020-03-10 | Chatham | North Carolina | 37037 | 1 | 0 |
1292 | 1292 | 2020-03-11 | Chatham | North Carolina | 37037 | 1 | 0 |
1530 | 1530 | 2020-03-12 | Chatham | North Carolina | 37037 | 1 | 0 |
1824 | 1824 | 2020-03-13 | Chatham | North Carolina | 37037 | 1 | 0 |
2176 | 2176 | 2020-03-14 | Chatham | North Carolina | 37037 | 1 | 0 |
2588 | 2588 | 2020-03-15 | Chatham | North Carolina | 37037 | 1 | 0 |
3049 | 3049 | 2020-03-16 | Chatham | North Carolina | 37037 | 1 | 0 |
3568 | 3568 | 2020-03-17 | Chatham | North Carolina | 37037 | 1 | 0 |
4171 | 4171 | 2020-03-18 | Chatham | North Carolina | 37037 | 3 | 0 |
4902 | 4902 | 2020-03-19 | Chatham | North Carolina | 37037 | 3 | 0 |
5754 | 5754 | 2020-03-20 | Chatham | North Carolina | 37037 | 3 | 0 |
6751 | 6751 | 2020-03-21 | Chatham | North Carolina | 37037 | 3 | 0 |
7847 | 7847 | 2020-03-22 | Chatham | North Carolina | 37037 | 3 | 0 |
9048 | 9048 | 2020-03-23 | Chatham | North Carolina | 37037 | 3 | 0 |
10356 | 10356 | 2020-03-24 | Chatham | North Carolina | 37037 | 3 | 0 |
11795 | 11795 | 2020-03-25 | Chatham | North Carolina | 37037 | 6 | 0 |
13399 | 13399 | 2020-03-26 | Chatham | North Carolina | 37037 | 9 | 0 |
15133 | 15133 | 2020-03-27 | Chatham | North Carolina | 37037 | 11 | 0 |
16964 | 16964 | 2020-03-28 | Chatham | North Carolina | 37037 | 12 | 0 |
18892 | 18892 | 2020-03-29 | Chatham | North Carolina | 37037 | 13 | 0 |
20932 | 20932 | 2020-03-30 | Chatham | North Carolina | 37037 | 14 | 0 |
23057 | 23057 | 2020-03-31 | Chatham | North Carolina | 37037 | 17 | 0 |
25251 | 25251 | 2020-04-01 | Chatham | North Carolina | 37037 | 17 | 0 |
27512 | 27512 | 2020-04-02 | Chatham | North Carolina | 37037 | 19 | 0 |
29837 | 29837 | 2020-04-03 | Chatham | North Carolina | 37037 | 19 | 0 |
32224 | 32224 | 2020-04-04 | Chatham | North Carolina | 37037 | 21 | 0 |
34655 | 34655 | 2020-04-05 | Chatham | North Carolina | 37037 | 21 | 0 |
37124 | 37124 | 2020-04-06 | Chatham | North Carolina | 37037 | 21 | 0 |
39639 | 39639 | 2020-04-07 | Chatham | North Carolina | 37037 | 21 | 0 |
42196 | 42196 | 2020-04-08 | Chatham | North Carolina | 37037 | 24 | 0 |
44779 | 44779 | 2020-04-09 | Chatham | North Carolina | 37037 | 26 | 0 |
47392 | 47392 | 2020-04-10 | Chatham | North Carolina | 37037 | 26 | 0 |
50047 | 50047 | 2020-04-11 | Chatham | North Carolina | 37037 | 37 | 0 |
52720 | 52720 | 2020-04-12 | Chatham | North Carolina | 37037 | 63 | 0 |
55403 | 55403 | 2020-04-13 | Chatham | North Carolina | 37037 | 69 | 0 |
58103 | 58103 | 2020-04-14 | Chatham | North Carolina | 37037 | 75 | 0 |
60817 | 60817 | 2020-04-15 | Chatham | North Carolina | 37037 | 77 | 0 |
63543 | 63543 | 2020-04-16 | Chatham | North Carolina | 37037 | 80 | 0 |
66286 | 66286 | 2020-04-17 | Chatham | North Carolina | 37037 | 85 | 0 |
69043 | 69043 | 2020-04-18 | Chatham | North Carolina | 37037 | 101 | 0 |
71809 | 71809 | 2020-04-19 | Chatham | North Carolina | 37037 | 119 | 0 |
74584 | 74584 | 2020-04-20 | Chatham | North Carolina | 37037 | 127 | 0 |
77365 | 77365 | 2020-04-21 | Chatham | North Carolina | 37037 | 131 | 1 |
80154 | 80154 | 2020-04-22 | Chatham | North Carolina | 37037 | 135 | 6 |
82953 | 82953 | 2020-04-23 | Chatham | North Carolina | 37037 | 156 | 6 |
85757 | 85757 | 2020-04-24 | Chatham | North Carolina | 37037 | 179 | 6 |
88569 | 88569 | 2020-04-25 | Chatham | North Carolina | 37037 | 211 | 6 |
91384 | 91384 | 2020-04-26 | Chatham | North Carolina | 37037 | 240 | 6 |
94210 | 94210 | 2020-04-27 | Chatham | North Carolina | 37037 | 262 | 6 |
97046 | 97046 | 2020-04-28 | Chatham | North Carolina | 37037 | 274 | 6 |
99893 | 99893 | 2020-04-29 | Chatham | North Carolina | 37037 | 287 | 6 |
102746 | 102746 | 2020-04-30 | Chatham | North Carolina | 37037 | 316 | 8 |
105608 | 105608 | 2020-05-01 | Chatham | North Carolina | 37037 | 343 | 9 |
108475 | 108475 | 2020-05-02 | Chatham | North Carolina | 37037 | 375 | 9 |
111348 | 111348 | 2020-05-03 | Chatham | North Carolina | 37037 | 378 | 9 |
114229 | 114229 | 2020-05-04 | Chatham | North Carolina | 37037 | 383 | 10 |
117109 | 117109 | 2020-05-05 | Chatham | North Carolina | 37037 | 403 | 11 |
120070 | 120070 | 2020-05-06 | Chatham | North Carolina | 37037 | 412 | 11 |
123045 | 123045 | 2020-05-07 | Chatham | North Carolina | 37037 | 421 | 11 |
126028 | 126028 | 2020-05-08 | Chatham | North Carolina | 37037 | 435 | 11 |
129017 | 129017 | 2020-05-09 | Chatham | North Carolina | 37037 | 447 | 11 |
132006 | 132006 | 2020-05-10 | Chatham | North Carolina | 37037 | 455 | 11 |
134997 | 134997 | 2020-05-11 | Chatham | North Carolina | 37037 | 458 | 11 |
137987 | 137987 | 2020-05-12 | Chatham | North Carolina | 37037 | 461 | 11 |
140983 | 140983 | 2020-05-13 | Chatham | North Carolina | 37037 | 468 | 11 |
143978 | 143978 | 2020-05-14 | Chatham | North Carolina | 37037 | 490 | 11 |
146979 | 146979 | 2020-05-15 | Chatham | North Carolina | 37037 | 495 | 24 |
149986 | 149986 | 2020-05-16 | Chatham | North Carolina | 37037 | 504 | 24 |
152996 | 152996 | 2020-05-17 | Chatham | North Carolina | 37037 | 507 | 24 |
156013 | 156013 | 2020-05-18 | Chatham | North Carolina | 37037 | 512 | 24 |
159032 | 159032 | 2020-05-19 | Chatham | North Carolina | 37037 | 541 | 24 |
162059 | 162059 | 2020-05-20 | Chatham | North Carolina | 37037 | 543 | 25 |
165088 | 165088 | 2020-05-21 | Chatham | North Carolina | 37037 | 546 | 25 |
168123 | 168123 | 2020-05-22 | Chatham | North Carolina | 37037 | 564 | 26 |
171162 | 171162 | 2020-05-23 | Chatham | North Carolina | 37037 | 573 | 26 |
174204 | 174204 | 2020-05-24 | Chatham | North Carolina | 37037 | 578 | 26 |
177248 | 177248 | 2020-05-25 | Chatham | North Carolina | 37037 | 588 | 26 |
180291 | 180291 | 2020-05-26 | Chatham | North Carolina | 37037 | 588 | 26 |
183339 | 183339 | 2020-05-27 | Chatham | North Carolina | 37037 | 588 | 26 |
186396 | 186396 | 2020-05-28 | Chatham | North Carolina | 37037 | 595 | 26 |
189456 | 189456 | 2020-05-29 | Chatham | North Carolina | 37037 | 610 | 26 |
192520 | 192520 | 2020-05-30 | Chatham | North Carolina | 37037 | 630 | 26 |
195590 | 195590 | 2020-05-31 | Chatham | North Carolina | 37037 | 634 | 26 |
198663 | 198663 | 2020-06-01 | Chatham | North Carolina | 37037 | 637 | 26 |
201737 | 201737 | 2020-06-02 | Chatham | North Carolina | 37037 | 638 | 26 |
204814 | 204814 | 2020-06-03 | Chatham | North Carolina | 37037 | 660 | 27 |
207895 | 207895 | 2020-06-04 | Chatham | North Carolina | 37037 | 677 | 27 |
210977 | 210977 | 2020-06-05 | Chatham | North Carolina | 37037 | 690 | 29 |
214061 | 214061 | 2020-06-06 | Chatham | North Carolina | 37037 | 720 | 29 |
217151 | 217151 | 2020-06-07 | Chatham | North Carolina | 37037 | 723 | 29 |
220243 | 220243 | 2020-06-08 | Chatham | North Carolina | 37037 | 733 | 36 |
223337 | 223337 | 2020-06-09 | Chatham | North Carolina | 37037 | 745 | 37 |
226437 | 226437 | 2020-06-10 | Chatham | North Carolina | 37037 | 749 | 37 |
229541 | 229541 | 2020-06-11 | Chatham | North Carolina | 37037 | 759 | 37 |
232646 | 232646 | 2020-06-12 | Chatham | North Carolina | 37037 | 780 | 37 |
235751 | 235751 | 2020-06-13 | Chatham | North Carolina | 37037 | 784 | 37 |
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);