ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Centre" and state = "Pennsylvania" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- …
state 1
- Pennsylvania · 785 ✖
fips 1
- 42027 785
county 1
- Centre · 785 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
5851 | 5851 | 2020-03-20 | Centre | Pennsylvania | 42027 | 1 | 0 |
6854 | 6854 | 2020-03-21 | Centre | Pennsylvania | 42027 | 1 | 0 |
7969 | 7969 | 2020-03-22 | Centre | Pennsylvania | 42027 | 1 | 0 |
9180 | 9180 | 2020-03-23 | Centre | Pennsylvania | 42027 | 3 | 0 |
10502 | 10502 | 2020-03-24 | Centre | Pennsylvania | 42027 | 7 | 0 |
11964 | 11964 | 2020-03-25 | Centre | Pennsylvania | 42027 | 8 | 0 |
13583 | 13583 | 2020-03-26 | Centre | Pennsylvania | 42027 | 9 | 0 |
15329 | 15329 | 2020-03-27 | Centre | Pennsylvania | 42027 | 11 | 0 |
17177 | 17177 | 2020-03-28 | Centre | Pennsylvania | 42027 | 15 | 0 |
19115 | 19115 | 2020-03-29 | Centre | Pennsylvania | 42027 | 22 | 0 |
21165 | 21165 | 2020-03-30 | Centre | Pennsylvania | 42027 | 24 | 0 |
23301 | 23301 | 2020-03-31 | Centre | Pennsylvania | 42027 | 26 | 0 |
25499 | 25499 | 2020-04-01 | Centre | Pennsylvania | 42027 | 27 | 0 |
27771 | 27771 | 2020-04-02 | Centre | Pennsylvania | 42027 | 28 | 0 |
30104 | 30104 | 2020-04-03 | Centre | Pennsylvania | 42027 | 32 | 0 |
32494 | 32494 | 2020-04-04 | Centre | Pennsylvania | 42027 | 39 | 0 |
34929 | 34929 | 2020-04-05 | Centre | Pennsylvania | 42027 | 43 | 0 |
37404 | 37404 | 2020-04-06 | Centre | Pennsylvania | 42027 | 44 | 0 |
39925 | 39925 | 2020-04-07 | Centre | Pennsylvania | 42027 | 55 | 0 |
42485 | 42485 | 2020-04-08 | Centre | Pennsylvania | 42027 | 57 | 0 |
45071 | 45071 | 2020-04-09 | Centre | Pennsylvania | 42027 | 59 | 0 |
47688 | 47688 | 2020-04-10 | Centre | Pennsylvania | 42027 | 61 | 0 |
50345 | 50345 | 2020-04-11 | Centre | Pennsylvania | 42027 | 69 | 0 |
53018 | 53018 | 2020-04-12 | Centre | Pennsylvania | 42027 | 70 | 0 |
55703 | 55703 | 2020-04-13 | Centre | Pennsylvania | 42027 | 70 | 0 |
58406 | 58406 | 2020-04-14 | Centre | Pennsylvania | 42027 | 70 | 0 |
61121 | 61121 | 2020-04-15 | Centre | Pennsylvania | 42027 | 72 | 0 |
63847 | 63847 | 2020-04-16 | Centre | Pennsylvania | 42027 | 73 | 0 |
66593 | 66593 | 2020-04-17 | Centre | Pennsylvania | 42027 | 73 | 1 |
69351 | 69351 | 2020-04-18 | Centre | Pennsylvania | 42027 | 73 | 1 |
72118 | 72118 | 2020-04-19 | Centre | Pennsylvania | 42027 | 73 | 1 |
74893 | 74893 | 2020-04-20 | Centre | Pennsylvania | 42027 | 73 | 1 |
77675 | 77675 | 2020-04-21 | Centre | Pennsylvania | 42027 | 77 | 2 |
80465 | 80465 | 2020-04-22 | Centre | Pennsylvania | 42027 | 76 | 2 |
83264 | 83264 | 2020-04-23 | Centre | Pennsylvania | 42027 | 76 | 2 |
86068 | 86068 | 2020-04-24 | Centre | Pennsylvania | 42027 | 77 | 2 |
88882 | 88882 | 2020-04-25 | Centre | Pennsylvania | 42027 | 81 | 2 |
91698 | 91698 | 2020-04-26 | Centre | Pennsylvania | 42027 | 81 | 2 |
94525 | 94525 | 2020-04-27 | Centre | Pennsylvania | 42027 | 87 | 2 |
97364 | 97364 | 2020-04-28 | Centre | Pennsylvania | 42027 | 93 | 2 |
100213 | 100213 | 2020-04-29 | Centre | Pennsylvania | 42027 | 95 | 2 |
103066 | 103066 | 2020-04-30 | Centre | Pennsylvania | 42027 | 96 | 2 |
105929 | 105929 | 2020-05-01 | Centre | Pennsylvania | 42027 | 96 | 2 |
108796 | 108796 | 2020-05-02 | Centre | Pennsylvania | 42027 | 96 | 2 |
111670 | 111670 | 2020-05-03 | Centre | Pennsylvania | 42027 | 102 | 2 |
114552 | 114552 | 2020-05-04 | Centre | Pennsylvania | 42027 | 105 | 2 |
117433 | 117433 | 2020-05-05 | Centre | Pennsylvania | 42027 | 106 | 2 |
120395 | 120395 | 2020-05-06 | Centre | Pennsylvania | 42027 | 113 | 2 |
123372 | 123372 | 2020-05-07 | Centre | Pennsylvania | 42027 | 116 | 2 |
126355 | 126355 | 2020-05-08 | Centre | Pennsylvania | 42027 | 117 | 2 |
129344 | 129344 | 2020-05-09 | Centre | Pennsylvania | 42027 | 117 | 2 |
132333 | 132333 | 2020-05-10 | Centre | Pennsylvania | 42027 | 119 | 2 |
135324 | 135324 | 2020-05-11 | Centre | Pennsylvania | 42027 | 119 | 2 |
138314 | 138314 | 2020-05-12 | Centre | Pennsylvania | 42027 | 122 | 2 |
141310 | 141310 | 2020-05-13 | Centre | Pennsylvania | 42027 | 126 | 4 |
144306 | 144306 | 2020-05-14 | Centre | Pennsylvania | 42027 | 128 | 6 |
147307 | 147307 | 2020-05-15 | Centre | Pennsylvania | 42027 | 129 | 6 |
150314 | 150314 | 2020-05-16 | Centre | Pennsylvania | 42027 | 129 | 6 |
153325 | 153325 | 2020-05-17 | Centre | Pennsylvania | 42027 | 131 | 6 |
156342 | 156342 | 2020-05-18 | Centre | Pennsylvania | 42027 | 133 | 5 |
159363 | 159363 | 2020-05-19 | Centre | Pennsylvania | 42027 | 132 | 5 |
162390 | 162390 | 2020-05-20 | Centre | Pennsylvania | 42027 | 133 | 5 |
165419 | 165419 | 2020-05-21 | Centre | Pennsylvania | 42027 | 136 | 5 |
168455 | 168455 | 2020-05-22 | Centre | Pennsylvania | 42027 | 138 | 5 |
171494 | 171494 | 2020-05-23 | Centre | Pennsylvania | 42027 | 143 | 6 |
174536 | 174536 | 2020-05-24 | Centre | Pennsylvania | 42027 | 146 | 6 |
177580 | 177580 | 2020-05-25 | Centre | Pennsylvania | 42027 | 147 | 6 |
180623 | 180623 | 2020-05-26 | Centre | Pennsylvania | 42027 | 148 | 6 |
183673 | 183673 | 2020-05-27 | Centre | Pennsylvania | 42027 | 149 | 6 |
186730 | 186730 | 2020-05-28 | Centre | Pennsylvania | 42027 | 150 | 6 |
189791 | 189791 | 2020-05-29 | Centre | Pennsylvania | 42027 | 151 | 6 |
192856 | 192856 | 2020-05-30 | Centre | Pennsylvania | 42027 | 152 | 7 |
195925 | 195925 | 2020-05-31 | Centre | Pennsylvania | 42027 | 153 | 7 |
198998 | 198998 | 2020-06-01 | Centre | Pennsylvania | 42027 | 154 | 7 |
202073 | 202073 | 2020-06-02 | Centre | Pennsylvania | 42027 | 154 | 7 |
205150 | 205150 | 2020-06-03 | Centre | Pennsylvania | 42027 | 154 | 7 |
208231 | 208231 | 2020-06-04 | Centre | Pennsylvania | 42027 | 154 | 7 |
211313 | 211313 | 2020-06-05 | Centre | Pennsylvania | 42027 | 154 | 7 |
214399 | 214399 | 2020-06-06 | Centre | Pennsylvania | 42027 | 155 | 7 |
217489 | 217489 | 2020-06-07 | Centre | Pennsylvania | 42027 | 156 | 7 |
220581 | 220581 | 2020-06-08 | Centre | Pennsylvania | 42027 | 157 | 7 |
223676 | 223676 | 2020-06-09 | Centre | Pennsylvania | 42027 | 157 | 7 |
226776 | 226776 | 2020-06-10 | Centre | Pennsylvania | 42027 | 158 | 7 |
229880 | 229880 | 2020-06-11 | Centre | Pennsylvania | 42027 | 158 | 7 |
232985 | 232985 | 2020-06-12 | Centre | Pennsylvania | 42027 | 165 | 7 |
236090 | 236090 | 2020-06-13 | Centre | Pennsylvania | 42027 | 167 | 7 |
239198 | 239198 | 2020-06-14 | Centre | Pennsylvania | 42027 | 169 | 7 |
242307 | 242307 | 2020-06-15 | Centre | Pennsylvania | 42027 | 171 | 6 |
245419 | 245419 | 2020-06-16 | Centre | Pennsylvania | 42027 | 177 | 6 |
248532 | 248532 | 2020-06-17 | Centre | Pennsylvania | 42027 | 172 | 6 |
251647 | 251647 | 2020-06-18 | Centre | Pennsylvania | 42027 | 172 | 6 |
254762 | 254762 | 2020-06-19 | Centre | Pennsylvania | 42027 | 176 | 6 |
257888 | 257888 | 2020-06-20 | Centre | Pennsylvania | 42027 | 180 | 6 |
261015 | 261015 | 2020-06-21 | Centre | Pennsylvania | 42027 | 180 | 6 |
264143 | 264143 | 2020-06-22 | Centre | Pennsylvania | 42027 | 184 | 6 |
267271 | 267271 | 2020-06-23 | Centre | Pennsylvania | 42027 | 195 | 6 |
270405 | 270405 | 2020-06-24 | Centre | Pennsylvania | 42027 | 196 | 6 |
273544 | 273544 | 2020-06-25 | Centre | Pennsylvania | 42027 | 197 | 6 |
276691 | 276691 | 2020-06-26 | Centre | Pennsylvania | 42027 | 198 | 6 |
279839 | 279839 | 2020-06-27 | Centre | Pennsylvania | 42027 | 200 | 7 |
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);