ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Granville" 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 |
---|---|---|---|---|---|---|---|
7857 | 7857 | 2020-03-22 | Granville | North Carolina | 37077 | 1 | 0 |
9058 | 9058 | 2020-03-23 | Granville | North Carolina | 37077 | 1 | 0 |
10366 | 10366 | 2020-03-24 | Granville | North Carolina | 37077 | 1 | 0 |
11807 | 11807 | 2020-03-25 | Granville | North Carolina | 37077 | 1 | 0 |
13411 | 13411 | 2020-03-26 | Granville | North Carolina | 37077 | 1 | 0 |
15145 | 15145 | 2020-03-27 | Granville | North Carolina | 37077 | 3 | 0 |
16977 | 16977 | 2020-03-28 | Granville | North Carolina | 37077 | 4 | 0 |
18907 | 18907 | 2020-03-29 | Granville | North Carolina | 37077 | 6 | 0 |
20947 | 20947 | 2020-03-30 | Granville | North Carolina | 37077 | 7 | 0 |
23073 | 23073 | 2020-03-31 | Granville | North Carolina | 37077 | 9 | 0 |
25267 | 25267 | 2020-04-01 | Granville | North Carolina | 37077 | 9 | 0 |
27530 | 27530 | 2020-04-02 | Granville | North Carolina | 37077 | 20 | 0 |
29856 | 29856 | 2020-04-03 | Granville | North Carolina | 37077 | 22 | 0 |
32243 | 32243 | 2020-04-04 | Granville | North Carolina | 37077 | 24 | 0 |
34674 | 34674 | 2020-04-05 | Granville | North Carolina | 37077 | 37 | 0 |
37143 | 37143 | 2020-04-06 | Granville | North Carolina | 37077 | 70 | 0 |
39658 | 39658 | 2020-04-07 | Granville | North Carolina | 37077 | 76 | 0 |
42215 | 42215 | 2020-04-08 | Granville | North Carolina | 37077 | 83 | 0 |
44798 | 44798 | 2020-04-09 | Granville | North Carolina | 37077 | 83 | 0 |
47411 | 47411 | 2020-04-10 | Granville | North Carolina | 37077 | 87 | 0 |
50066 | 50066 | 2020-04-11 | Granville | North Carolina | 37077 | 88 | 0 |
52739 | 52739 | 2020-04-12 | Granville | North Carolina | 37077 | 89 | 0 |
55422 | 55422 | 2020-04-13 | Granville | North Carolina | 37077 | 92 | 0 |
58122 | 58122 | 2020-04-14 | Granville | North Carolina | 37077 | 97 | 4 |
60836 | 60836 | 2020-04-15 | Granville | North Carolina | 37077 | 98 | 4 |
63562 | 63562 | 2020-04-16 | Granville | North Carolina | 37077 | 104 | 4 |
66305 | 66305 | 2020-04-17 | Granville | North Carolina | 37077 | 108 | 4 |
69062 | 69062 | 2020-04-18 | Granville | North Carolina | 37077 | 109 | 5 |
71828 | 71828 | 2020-04-19 | Granville | North Carolina | 37077 | 110 | 5 |
74603 | 74603 | 2020-04-20 | Granville | North Carolina | 37077 | 112 | 5 |
77384 | 77384 | 2020-04-21 | Granville | North Carolina | 37077 | 114 | 5 |
80173 | 80173 | 2020-04-22 | Granville | North Carolina | 37077 | 118 | 5 |
82972 | 82972 | 2020-04-23 | Granville | North Carolina | 37077 | 123 | 5 |
85776 | 85776 | 2020-04-24 | Granville | North Carolina | 37077 | 121 | 5 |
88588 | 88588 | 2020-04-25 | Granville | North Carolina | 37077 | 126 | 5 |
91403 | 91403 | 2020-04-26 | Granville | North Carolina | 37077 | 133 | 5 |
94229 | 94229 | 2020-04-27 | Granville | North Carolina | 37077 | 133 | 5 |
97066 | 97066 | 2020-04-28 | Granville | North Carolina | 37077 | 133 | 5 |
99913 | 99913 | 2020-04-29 | Granville | North Carolina | 37077 | 136 | 5 |
102766 | 102766 | 2020-04-30 | Granville | North Carolina | 37077 | 136 | 5 |
105628 | 105628 | 2020-05-01 | Granville | North Carolina | 37077 | 137 | 5 |
108495 | 108495 | 2020-05-02 | Granville | North Carolina | 37077 | 157 | 6 |
111368 | 111368 | 2020-05-03 | Granville | North Carolina | 37077 | 159 | 6 |
114249 | 114249 | 2020-05-04 | Granville | North Carolina | 37077 | 160 | 6 |
117129 | 117129 | 2020-05-05 | Granville | North Carolina | 37077 | 160 | 8 |
120090 | 120090 | 2020-05-06 | Granville | North Carolina | 37077 | 161 | 8 |
123065 | 123065 | 2020-05-07 | Granville | North Carolina | 37077 | 164 | 8 |
126048 | 126048 | 2020-05-08 | Granville | North Carolina | 37077 | 159 | 6 |
129037 | 129037 | 2020-05-09 | Granville | North Carolina | 37077 | 164 | 6 |
132026 | 132026 | 2020-05-10 | Granville | North Carolina | 37077 | 165 | 6 |
135017 | 135017 | 2020-05-11 | Granville | North Carolina | 37077 | 167 | 6 |
138007 | 138007 | 2020-05-12 | Granville | North Carolina | 37077 | 170 | 6 |
141003 | 141003 | 2020-05-13 | Granville | North Carolina | 37077 | 171 | 6 |
143998 | 143998 | 2020-05-14 | Granville | North Carolina | 37077 | 178 | 6 |
146999 | 146999 | 2020-05-15 | Granville | North Carolina | 37077 | 181 | 6 |
150006 | 150006 | 2020-05-16 | Granville | North Carolina | 37077 | 190 | 6 |
153016 | 153016 | 2020-05-17 | Granville | North Carolina | 37077 | 196 | 6 |
156033 | 156033 | 2020-05-18 | Granville | North Carolina | 37077 | 201 | 6 |
159052 | 159052 | 2020-05-19 | Granville | North Carolina | 37077 | 202 | 6 |
162079 | 162079 | 2020-05-20 | Granville | North Carolina | 37077 | 208 | 6 |
165108 | 165108 | 2020-05-21 | Granville | North Carolina | 37077 | 222 | 6 |
168143 | 168143 | 2020-05-22 | Granville | North Carolina | 37077 | 226 | 7 |
171182 | 171182 | 2020-05-23 | Granville | North Carolina | 37077 | 239 | 7 |
174224 | 174224 | 2020-05-24 | Granville | North Carolina | 37077 | 240 | 7 |
177268 | 177268 | 2020-05-25 | Granville | North Carolina | 37077 | 247 | 7 |
180311 | 180311 | 2020-05-26 | Granville | North Carolina | 37077 | 254 | 7 |
183359 | 183359 | 2020-05-27 | Granville | North Carolina | 37077 | 258 | 8 |
186416 | 186416 | 2020-05-28 | Granville | North Carolina | 37077 | 269 | 8 |
189476 | 189476 | 2020-05-29 | Granville | North Carolina | 37077 | 277 | 8 |
192540 | 192540 | 2020-05-30 | Granville | North Carolina | 37077 | 294 | 10 |
195610 | 195610 | 2020-05-31 | Granville | North Carolina | 37077 | 306 | 10 |
198683 | 198683 | 2020-06-01 | Granville | North Carolina | 37077 | 307 | 10 |
201757 | 201757 | 2020-06-02 | Granville | North Carolina | 37077 | 309 | 10 |
204834 | 204834 | 2020-06-03 | Granville | North Carolina | 37077 | 315 | 11 |
207915 | 207915 | 2020-06-04 | Granville | North Carolina | 37077 | 321 | 12 |
210997 | 210997 | 2020-06-05 | Granville | North Carolina | 37077 | 348 | 13 |
214081 | 214081 | 2020-06-06 | Granville | North Carolina | 37077 | 462 | 13 |
217171 | 217171 | 2020-06-07 | Granville | North Carolina | 37077 | 501 | 13 |
220263 | 220263 | 2020-06-08 | Granville | North Carolina | 37077 | 513 | 13 |
223357 | 223357 | 2020-06-09 | Granville | North Carolina | 37077 | 557 | 13 |
226457 | 226457 | 2020-06-10 | Granville | North Carolina | 37077 | 610 | 14 |
229561 | 229561 | 2020-06-11 | Granville | North Carolina | 37077 | 624 | 14 |
232666 | 232666 | 2020-06-12 | Granville | North Carolina | 37077 | 646 | 15 |
235771 | 235771 | 2020-06-13 | Granville | North Carolina | 37077 | 657 | 15 |
238879 | 238879 | 2020-06-14 | Granville | North Carolina | 37077 | 668 | 15 |
241988 | 241988 | 2020-06-15 | Granville | North Carolina | 37077 | 680 | 15 |
245100 | 245100 | 2020-06-16 | Granville | North Carolina | 37077 | 688 | 16 |
248213 | 248213 | 2020-06-17 | Granville | North Carolina | 37077 | 693 | 16 |
251328 | 251328 | 2020-06-18 | Granville | North Carolina | 37077 | 701 | 17 |
254443 | 254443 | 2020-06-19 | Granville | North Carolina | 37077 | 713 | 17 |
257566 | 257566 | 2020-06-20 | Granville | North Carolina | 37077 | 723 | 17 |
260693 | 260693 | 2020-06-21 | Granville | North Carolina | 37077 | 735 | 17 |
263821 | 263821 | 2020-06-22 | Granville | North Carolina | 37077 | 738 | 17 |
266949 | 266949 | 2020-06-23 | Granville | North Carolina | 37077 | 742 | 17 |
270083 | 270083 | 2020-06-24 | Granville | North Carolina | 37077 | 755 | 17 |
273222 | 273222 | 2020-06-25 | Granville | North Carolina | 37077 | 767 | 19 |
276368 | 276368 | 2020-06-26 | Granville | North Carolina | 37077 | 771 | 19 |
279516 | 279516 | 2020-06-27 | Granville | North Carolina | 37077 | 779 | 19 |
282662 | 282662 | 2020-06-28 | Granville | North Carolina | 37077 | 786 | 19 |
285807 | 285807 | 2020-06-29 | Granville | North Carolina | 37077 | 788 | 19 |
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);