ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Susquehanna" and state = "Pennsylvania" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
13614 | 13614 | 2020-03-26 | Susquehanna | Pennsylvania | 42115 | 1 | 0 |
15361 | 15361 | 2020-03-27 | Susquehanna | Pennsylvania | 42115 | 1 | 0 |
17214 | 17214 | 2020-03-28 | Susquehanna | Pennsylvania | 42115 | 1 | 0 |
19153 | 19153 | 2020-03-29 | Susquehanna | Pennsylvania | 42115 | 1 | 0 |
21203 | 21203 | 2020-03-30 | Susquehanna | Pennsylvania | 42115 | 1 | 0 |
23339 | 23339 | 2020-03-31 | Susquehanna | Pennsylvania | 42115 | 1 | 0 |
25537 | 25537 | 2020-04-01 | Susquehanna | Pennsylvania | 42115 | 2 | 0 |
27810 | 27810 | 2020-04-02 | Susquehanna | Pennsylvania | 42115 | 3 | 0 |
30144 | 30144 | 2020-04-03 | Susquehanna | Pennsylvania | 42115 | 4 | 0 |
32535 | 32535 | 2020-04-04 | Susquehanna | Pennsylvania | 42115 | 5 | 0 |
34971 | 34971 | 2020-04-05 | Susquehanna | Pennsylvania | 42115 | 6 | 0 |
37446 | 37446 | 2020-04-06 | Susquehanna | Pennsylvania | 42115 | 6 | 0 |
39969 | 39969 | 2020-04-07 | Susquehanna | Pennsylvania | 42115 | 11 | 0 |
42529 | 42529 | 2020-04-08 | Susquehanna | Pennsylvania | 42115 | 14 | 0 |
45115 | 45115 | 2020-04-09 | Susquehanna | Pennsylvania | 42115 | 16 | 1 |
47732 | 47732 | 2020-04-10 | Susquehanna | Pennsylvania | 42115 | 22 | 2 |
50389 | 50389 | 2020-04-11 | Susquehanna | Pennsylvania | 42115 | 23 | 2 |
53062 | 53062 | 2020-04-12 | Susquehanna | Pennsylvania | 42115 | 25 | 1 |
55747 | 55747 | 2020-04-13 | Susquehanna | Pennsylvania | 42115 | 31 | 1 |
58450 | 58450 | 2020-04-14 | Susquehanna | Pennsylvania | 42115 | 32 | 1 |
61165 | 61165 | 2020-04-15 | Susquehanna | Pennsylvania | 42115 | 40 | 1 |
63891 | 63891 | 2020-04-16 | Susquehanna | Pennsylvania | 42115 | 49 | 1 |
66637 | 66637 | 2020-04-17 | Susquehanna | Pennsylvania | 42115 | 58 | 1 |
69395 | 69395 | 2020-04-18 | Susquehanna | Pennsylvania | 42115 | 59 | 1 |
72162 | 72162 | 2020-04-19 | Susquehanna | Pennsylvania | 42115 | 63 | 3 |
74937 | 74937 | 2020-04-20 | Susquehanna | Pennsylvania | 42115 | 66 | 4 |
77719 | 77719 | 2020-04-21 | Susquehanna | Pennsylvania | 42115 | 71 | 4 |
80509 | 80509 | 2020-04-22 | Susquehanna | Pennsylvania | 42115 | 71 | 4 |
83308 | 83308 | 2020-04-23 | Susquehanna | Pennsylvania | 42115 | 72 | 4 |
86112 | 86112 | 2020-04-24 | Susquehanna | Pennsylvania | 42115 | 76 | 4 |
88926 | 88926 | 2020-04-25 | Susquehanna | Pennsylvania | 42115 | 77 | 4 |
91742 | 91742 | 2020-04-26 | Susquehanna | Pennsylvania | 42115 | 79 | 4 |
94569 | 94569 | 2020-04-27 | Susquehanna | Pennsylvania | 42115 | 81 | 4 |
97408 | 97408 | 2020-04-28 | Susquehanna | Pennsylvania | 42115 | 82 | 4 |
100257 | 100257 | 2020-04-29 | Susquehanna | Pennsylvania | 42115 | 82 | 8 |
103110 | 103110 | 2020-04-30 | Susquehanna | Pennsylvania | 42115 | 84 | 8 |
105973 | 105973 | 2020-05-01 | Susquehanna | Pennsylvania | 42115 | 84 | 8 |
108840 | 108840 | 2020-05-02 | Susquehanna | Pennsylvania | 42115 | 84 | 9 |
111714 | 111714 | 2020-05-03 | Susquehanna | Pennsylvania | 42115 | 85 | 9 |
114596 | 114596 | 2020-05-04 | Susquehanna | Pennsylvania | 42115 | 86 | 9 |
117477 | 117477 | 2020-05-05 | Susquehanna | Pennsylvania | 42115 | 86 | 11 |
120439 | 120439 | 2020-05-06 | Susquehanna | Pennsylvania | 42115 | 87 | 11 |
123416 | 123416 | 2020-05-07 | Susquehanna | Pennsylvania | 42115 | 86 | 11 |
126399 | 126399 | 2020-05-08 | Susquehanna | Pennsylvania | 42115 | 86 | 13 |
129388 | 129388 | 2020-05-09 | Susquehanna | Pennsylvania | 42115 | 82 | 13 |
132377 | 132377 | 2020-05-10 | Susquehanna | Pennsylvania | 42115 | 82 | 13 |
135368 | 135368 | 2020-05-11 | Susquehanna | Pennsylvania | 42115 | 82 | 13 |
138358 | 138358 | 2020-05-12 | Susquehanna | Pennsylvania | 42115 | 82 | 13 |
141354 | 141354 | 2020-05-13 | Susquehanna | Pennsylvania | 42115 | 82 | 13 |
144350 | 144350 | 2020-05-14 | Susquehanna | Pennsylvania | 42115 | 82 | 14 |
147351 | 147351 | 2020-05-15 | Susquehanna | Pennsylvania | 42115 | 82 | 14 |
150358 | 150358 | 2020-05-16 | Susquehanna | Pennsylvania | 42115 | 83 | 14 |
153369 | 153369 | 2020-05-17 | Susquehanna | Pennsylvania | 42115 | 83 | 14 |
156386 | 156386 | 2020-05-18 | Susquehanna | Pennsylvania | 42115 | 85 | 15 |
159407 | 159407 | 2020-05-19 | Susquehanna | Pennsylvania | 42115 | 85 | 15 |
162434 | 162434 | 2020-05-20 | Susquehanna | Pennsylvania | 42115 | 87 | 15 |
165463 | 165463 | 2020-05-21 | Susquehanna | Pennsylvania | 42115 | 90 | 15 |
168499 | 168499 | 2020-05-22 | Susquehanna | Pennsylvania | 42115 | 93 | 15 |
171538 | 171538 | 2020-05-23 | Susquehanna | Pennsylvania | 42115 | 95 | 15 |
174580 | 174580 | 2020-05-24 | Susquehanna | Pennsylvania | 42115 | 96 | 15 |
177624 | 177624 | 2020-05-25 | Susquehanna | Pennsylvania | 42115 | 96 | 15 |
180667 | 180667 | 2020-05-26 | Susquehanna | Pennsylvania | 42115 | 97 | 15 |
183717 | 183717 | 2020-05-27 | Susquehanna | Pennsylvania | 42115 | 98 | 15 |
186774 | 186774 | 2020-05-28 | Susquehanna | Pennsylvania | 42115 | 99 | 15 |
189835 | 189835 | 2020-05-29 | Susquehanna | Pennsylvania | 42115 | 109 | 15 |
192900 | 192900 | 2020-05-30 | Susquehanna | Pennsylvania | 42115 | 109 | 15 |
195969 | 195969 | 2020-05-31 | Susquehanna | Pennsylvania | 42115 | 109 | 15 |
199042 | 199042 | 2020-06-01 | Susquehanna | Pennsylvania | 42115 | 110 | 15 |
202117 | 202117 | 2020-06-02 | Susquehanna | Pennsylvania | 42115 | 110 | 15 |
205194 | 205194 | 2020-06-03 | Susquehanna | Pennsylvania | 42115 | 111 | 15 |
208275 | 208275 | 2020-06-04 | Susquehanna | Pennsylvania | 42115 | 123 | 15 |
211357 | 211357 | 2020-06-05 | Susquehanna | Pennsylvania | 42115 | 124 | 16 |
214443 | 214443 | 2020-06-06 | Susquehanna | Pennsylvania | 42115 | 133 | 16 |
217533 | 217533 | 2020-06-07 | Susquehanna | Pennsylvania | 42115 | 148 | 16 |
220625 | 220625 | 2020-06-08 | Susquehanna | Pennsylvania | 42115 | 154 | 16 |
223720 | 223720 | 2020-06-09 | Susquehanna | Pennsylvania | 42115 | 154 | 16 |
226820 | 226820 | 2020-06-10 | Susquehanna | Pennsylvania | 42115 | 155 | 16 |
229924 | 229924 | 2020-06-11 | Susquehanna | Pennsylvania | 42115 | 164 | 17 |
233029 | 233029 | 2020-06-12 | Susquehanna | Pennsylvania | 42115 | 166 | 17 |
236134 | 236134 | 2020-06-13 | Susquehanna | Pennsylvania | 42115 | 169 | 17 |
239242 | 239242 | 2020-06-14 | Susquehanna | Pennsylvania | 42115 | 170 | 17 |
242351 | 242351 | 2020-06-15 | Susquehanna | Pennsylvania | 42115 | 171 | 17 |
245463 | 245463 | 2020-06-16 | Susquehanna | Pennsylvania | 42115 | 172 | 17 |
248576 | 248576 | 2020-06-17 | Susquehanna | Pennsylvania | 42115 | 172 | 18 |
251691 | 251691 | 2020-06-18 | Susquehanna | Pennsylvania | 42115 | 173 | 18 |
254806 | 254806 | 2020-06-19 | Susquehanna | Pennsylvania | 42115 | 178 | 20 |
257932 | 257932 | 2020-06-20 | Susquehanna | Pennsylvania | 42115 | 178 | 20 |
261059 | 261059 | 2020-06-21 | Susquehanna | Pennsylvania | 42115 | 178 | 20 |
264187 | 264187 | 2020-06-22 | Susquehanna | Pennsylvania | 42115 | 178 | 20 |
267315 | 267315 | 2020-06-23 | Susquehanna | Pennsylvania | 42115 | 178 | 20 |
270449 | 270449 | 2020-06-24 | Susquehanna | Pennsylvania | 42115 | 178 | 21 |
273588 | 273588 | 2020-06-25 | Susquehanna | Pennsylvania | 42115 | 178 | 22 |
276735 | 276735 | 2020-06-26 | Susquehanna | Pennsylvania | 42115 | 179 | 22 |
279883 | 279883 | 2020-06-27 | Susquehanna | Pennsylvania | 42115 | 181 | 22 |
283029 | 283029 | 2020-06-28 | Susquehanna | Pennsylvania | 42115 | 181 | 22 |
286174 | 286174 | 2020-06-29 | Susquehanna | Pennsylvania | 42115 | 182 | 22 |
289325 | 289325 | 2020-06-30 | Susquehanna | Pennsylvania | 42115 | 182 | 23 |
292477 | 292477 | 2020-07-01 | Susquehanna | Pennsylvania | 42115 | 182 | 23 |
295633 | 295633 | 2020-07-02 | Susquehanna | Pennsylvania | 42115 | 183 | 24 |
298792 | 298792 | 2020-07-03 | Susquehanna | Pennsylvania | 42115 | 185 | 24 |
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);