ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 37145 and state = "North Carolina" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
15167 | 15167 | 2020-03-27 | Person | North Carolina | 37145 | 1 | 0 |
17000 | 17000 | 2020-03-28 | Person | North Carolina | 37145 | 1 | 0 |
18932 | 18932 | 2020-03-29 | Person | North Carolina | 37145 | 1 | 0 |
20972 | 20972 | 2020-03-30 | Person | North Carolina | 37145 | 1 | 0 |
23099 | 23099 | 2020-03-31 | Person | North Carolina | 37145 | 2 | 0 |
25293 | 25293 | 2020-04-01 | Person | North Carolina | 37145 | 2 | 0 |
27558 | 27558 | 2020-04-02 | Person | North Carolina | 37145 | 2 | 0 |
29885 | 29885 | 2020-04-03 | Person | North Carolina | 37145 | 2 | 0 |
32272 | 32272 | 2020-04-04 | Person | North Carolina | 37145 | 3 | 0 |
34704 | 34704 | 2020-04-05 | Person | North Carolina | 37145 | 4 | 0 |
37173 | 37173 | 2020-04-06 | Person | North Carolina | 37145 | 6 | 0 |
39688 | 39688 | 2020-04-07 | Person | North Carolina | 37145 | 7 | 0 |
42245 | 42245 | 2020-04-08 | Person | North Carolina | 37145 | 7 | 0 |
44829 | 44829 | 2020-04-09 | Person | North Carolina | 37145 | 8 | 0 |
47442 | 47442 | 2020-04-10 | Person | North Carolina | 37145 | 8 | 0 |
50097 | 50097 | 2020-04-11 | Person | North Carolina | 37145 | 8 | 0 |
52770 | 52770 | 2020-04-12 | Person | North Carolina | 37145 | 8 | 0 |
55454 | 55454 | 2020-04-13 | Person | North Carolina | 37145 | 8 | 0 |
58154 | 58154 | 2020-04-14 | Person | North Carolina | 37145 | 11 | 0 |
60868 | 60868 | 2020-04-15 | Person | North Carolina | 37145 | 11 | 0 |
63594 | 63594 | 2020-04-16 | Person | North Carolina | 37145 | 11 | 0 |
66337 | 66337 | 2020-04-17 | Person | North Carolina | 37145 | 14 | 0 |
69094 | 69094 | 2020-04-18 | Person | North Carolina | 37145 | 16 | 0 |
71860 | 71860 | 2020-04-19 | Person | North Carolina | 37145 | 15 | 0 |
74635 | 74635 | 2020-04-20 | Person | North Carolina | 37145 | 15 | 0 |
77416 | 77416 | 2020-04-21 | Person | North Carolina | 37145 | 18 | 0 |
80205 | 80205 | 2020-04-22 | Person | North Carolina | 37145 | 17 | 0 |
83004 | 83004 | 2020-04-23 | Person | North Carolina | 37145 | 19 | 0 |
85808 | 85808 | 2020-04-24 | Person | North Carolina | 37145 | 18 | 0 |
88621 | 88621 | 2020-04-25 | Person | North Carolina | 37145 | 18 | 0 |
91436 | 91436 | 2020-04-26 | Person | North Carolina | 37145 | 19 | 0 |
94262 | 94262 | 2020-04-27 | Person | North Carolina | 37145 | 19 | 0 |
97099 | 97099 | 2020-04-28 | Person | North Carolina | 37145 | 19 | 0 |
99947 | 99947 | 2020-04-29 | Person | North Carolina | 37145 | 20 | 1 |
102800 | 102800 | 2020-04-30 | Person | North Carolina | 37145 | 20 | 1 |
105662 | 105662 | 2020-05-01 | Person | North Carolina | 37145 | 21 | 1 |
108529 | 108529 | 2020-05-02 | Person | North Carolina | 37145 | 22 | 1 |
111402 | 111402 | 2020-05-03 | Person | North Carolina | 37145 | 23 | 1 |
114283 | 114283 | 2020-05-04 | Person | North Carolina | 37145 | 23 | 1 |
117163 | 117163 | 2020-05-05 | Person | North Carolina | 37145 | 23 | 1 |
120124 | 120124 | 2020-05-06 | Person | North Carolina | 37145 | 23 | 1 |
123099 | 123099 | 2020-05-07 | Person | North Carolina | 37145 | 27 | 1 |
126082 | 126082 | 2020-05-08 | Person | North Carolina | 37145 | 29 | 1 |
129071 | 129071 | 2020-05-09 | Person | North Carolina | 37145 | 30 | 1 |
132060 | 132060 | 2020-05-10 | Person | North Carolina | 37145 | 30 | 1 |
135051 | 135051 | 2020-05-11 | Person | North Carolina | 37145 | 31 | 1 |
138041 | 138041 | 2020-05-12 | Person | North Carolina | 37145 | 31 | 1 |
141037 | 141037 | 2020-05-13 | Person | North Carolina | 37145 | 31 | 1 |
144032 | 144032 | 2020-05-14 | Person | North Carolina | 37145 | 31 | 1 |
147033 | 147033 | 2020-05-15 | Person | North Carolina | 37145 | 32 | 1 |
150040 | 150040 | 2020-05-16 | Person | North Carolina | 37145 | 32 | 1 |
153050 | 153050 | 2020-05-17 | Person | North Carolina | 37145 | 31 | 1 |
156067 | 156067 | 2020-05-18 | Person | North Carolina | 37145 | 33 | 1 |
159086 | 159086 | 2020-05-19 | Person | North Carolina | 37145 | 34 | 1 |
162113 | 162113 | 2020-05-20 | Person | North Carolina | 37145 | 34 | 1 |
165142 | 165142 | 2020-05-21 | Person | North Carolina | 37145 | 34 | 1 |
168177 | 168177 | 2020-05-22 | Person | North Carolina | 37145 | 34 | 1 |
171216 | 171216 | 2020-05-23 | Person | North Carolina | 37145 | 37 | 1 |
174258 | 174258 | 2020-05-24 | Person | North Carolina | 37145 | 37 | 1 |
177302 | 177302 | 2020-05-25 | Person | North Carolina | 37145 | 37 | 1 |
180345 | 180345 | 2020-05-26 | Person | North Carolina | 37145 | 38 | 1 |
183393 | 183393 | 2020-05-27 | Person | North Carolina | 37145 | 39 | 1 |
186450 | 186450 | 2020-05-28 | Person | North Carolina | 37145 | 44 | 1 |
189510 | 189510 | 2020-05-29 | Person | North Carolina | 37145 | 45 | 1 |
192574 | 192574 | 2020-05-30 | Person | North Carolina | 37145 | 48 | 1 |
195644 | 195644 | 2020-05-31 | Person | North Carolina | 37145 | 48 | 1 |
198717 | 198717 | 2020-06-01 | Person | North Carolina | 37145 | 50 | 1 |
201791 | 201791 | 2020-06-02 | Person | North Carolina | 37145 | 50 | 1 |
204868 | 204868 | 2020-06-03 | Person | North Carolina | 37145 | 54 | 1 |
207949 | 207949 | 2020-06-04 | Person | North Carolina | 37145 | 55 | 1 |
211031 | 211031 | 2020-06-05 | Person | North Carolina | 37145 | 57 | 1 |
214115 | 214115 | 2020-06-06 | Person | North Carolina | 37145 | 57 | 1 |
217205 | 217205 | 2020-06-07 | Person | North Carolina | 37145 | 58 | 1 |
220297 | 220297 | 2020-06-08 | Person | North Carolina | 37145 | 61 | 1 |
223391 | 223391 | 2020-06-09 | Person | North Carolina | 37145 | 63 | 1 |
226491 | 226491 | 2020-06-10 | Person | North Carolina | 37145 | 65 | 1 |
229595 | 229595 | 2020-06-11 | Person | North Carolina | 37145 | 70 | 1 |
232700 | 232700 | 2020-06-12 | Person | North Carolina | 37145 | 72 | 1 |
235805 | 235805 | 2020-06-13 | Person | North Carolina | 37145 | 73 | 1 |
238913 | 238913 | 2020-06-14 | Person | North Carolina | 37145 | 79 | 1 |
242022 | 242022 | 2020-06-15 | Person | North Carolina | 37145 | 79 | 1 |
245134 | 245134 | 2020-06-16 | Person | North Carolina | 37145 | 82 | 1 |
248247 | 248247 | 2020-06-17 | Person | North Carolina | 37145 | 83 | 1 |
251362 | 251362 | 2020-06-18 | Person | North Carolina | 37145 | 86 | 1 |
254477 | 254477 | 2020-06-19 | Person | North Carolina | 37145 | 88 | 1 |
257600 | 257600 | 2020-06-20 | Person | North Carolina | 37145 | 91 | 1 |
260727 | 260727 | 2020-06-21 | Person | North Carolina | 37145 | 92 | 1 |
263855 | 263855 | 2020-06-22 | Person | North Carolina | 37145 | 92 | 1 |
266983 | 266983 | 2020-06-23 | Person | North Carolina | 37145 | 92 | 1 |
270117 | 270117 | 2020-06-24 | Person | North Carolina | 37145 | 97 | 1 |
273256 | 273256 | 2020-06-25 | Person | North Carolina | 37145 | 96 | 1 |
276402 | 276402 | 2020-06-26 | Person | North Carolina | 37145 | 100 | 1 |
279550 | 279550 | 2020-06-27 | Person | North Carolina | 37145 | 103 | 1 |
282696 | 282696 | 2020-06-28 | Person | North Carolina | 37145 | 104 | 1 |
285841 | 285841 | 2020-06-29 | Person | North Carolina | 37145 | 107 | 1 |
288991 | 288991 | 2020-06-30 | Person | North Carolina | 37145 | 106 | 1 |
292143 | 292143 | 2020-07-01 | Person | North Carolina | 37145 | 107 | 1 |
295298 | 295298 | 2020-07-02 | Person | North Carolina | 37145 | 107 | 1 |
298458 | 298458 | 2020-07-03 | Person | North Carolina | 37145 | 112 | 1 |
301621 | 301621 | 2020-07-04 | Person | North Carolina | 37145 | 114 | 1 |
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);