ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Orange" and fips = 12095 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 |
---|---|---|---|---|---|---|---|
1688 | 1688 | 2020-03-13 | Orange | Florida | 12095 | 1 | 0 |
2010 | 2010 | 2020-03-14 | Orange | Florida | 12095 | 1 | 0 |
2394 | 2394 | 2020-03-15 | Orange | Florida | 12095 | 2 | 0 |
2831 | 2831 | 2020-03-16 | Orange | Florida | 12095 | 4 | 1 |
3315 | 3315 | 2020-03-17 | Orange | Florida | 12095 | 6 | 1 |
3873 | 3873 | 2020-03-18 | Orange | Florida | 12095 | 11 | 1 |
4542 | 4542 | 2020-03-19 | Orange | Florida | 12095 | 19 | 1 |
5322 | 5322 | 2020-03-20 | Orange | Florida | 12095 | 23 | 1 |
6252 | 6252 | 2020-03-21 | Orange | Florida | 12095 | 29 | 1 |
7292 | 7292 | 2020-03-22 | Orange | Florida | 12095 | 32 | 1 |
8438 | 8438 | 2020-03-23 | Orange | Florida | 12095 | 47 | 1 |
9683 | 9683 | 2020-03-24 | Orange | Florida | 12095 | 50 | 1 |
11058 | 11058 | 2020-03-25 | Orange | Florida | 12095 | 87 | 2 |
12606 | 12606 | 2020-03-26 | Orange | Florida | 12095 | 118 | 3 |
14276 | 14276 | 2020-03-27 | Orange | Florida | 12095 | 174 | 4 |
16061 | 16061 | 2020-03-28 | Orange | Florida | 12095 | 213 | 4 |
17954 | 17954 | 2020-03-29 | Orange | Florida | 12095 | 267 | 4 |
19935 | 19935 | 2020-03-30 | Orange | Florida | 12095 | 299 | 4 |
22013 | 22013 | 2020-03-31 | Orange | Florida | 12095 | 373 | 4 |
24176 | 24176 | 2020-04-01 | Orange | Florida | 12095 | 458 | 3 |
26406 | 26406 | 2020-04-02 | Orange | Florida | 12095 | 540 | 4 |
28709 | 28709 | 2020-04-03 | Orange | Florida | 12095 | 601 | 6 |
31069 | 31069 | 2020-04-04 | Orange | Florida | 12095 | 656 | 7 |
33475 | 33475 | 2020-04-05 | Orange | Florida | 12095 | 712 | 7 |
35921 | 35921 | 2020-04-06 | Orange | Florida | 12095 | 753 | 8 |
38412 | 38412 | 2020-04-07 | Orange | Florida | 12095 | 767 | 9 |
40956 | 40956 | 2020-04-08 | Orange | Florida | 12095 | 823 | 10 |
43530 | 43530 | 2020-04-09 | Orange | Florida | 12095 | 859 | 12 |
46132 | 46132 | 2020-04-10 | Orange | Florida | 12095 | 901 | 11 |
48762 | 48762 | 2020-04-11 | Orange | Florida | 12095 | 922 | 12 |
51423 | 51423 | 2020-04-12 | Orange | Florida | 12095 | 948 | 12 |
54103 | 54103 | 2020-04-13 | Orange | Florida | 12095 | 1023 | 12 |
56795 | 56795 | 2020-04-14 | Orange | Florida | 12095 | 1037 | 17 |
59503 | 59503 | 2020-04-15 | Orange | Florida | 12095 | 1073 | 18 |
62222 | 62222 | 2020-04-16 | Orange | Florida | 12095 | 1113 | 20 |
64955 | 64955 | 2020-04-17 | Orange | Florida | 12095 | 1157 | 22 |
67703 | 67703 | 2020-04-18 | Orange | Florida | 12095 | 1179 | 22 |
70465 | 70465 | 2020-04-19 | Orange | Florida | 12095 | 1197 | 22 |
73234 | 73234 | 2020-04-20 | Orange | Florida | 12095 | 1215 | 26 |
76010 | 76010 | 2020-04-21 | Orange | Florida | 12095 | 1234 | 26 |
78794 | 78794 | 2020-04-22 | Orange | Florida | 12095 | 1250 | 27 |
81588 | 81588 | 2020-04-23 | Orange | Florida | 12095 | 1273 | 28 |
84388 | 84388 | 2020-04-24 | Orange | Florida | 12095 | 1289 | 29 |
87196 | 87196 | 2020-04-25 | Orange | Florida | 12095 | 1303 | 29 |
90013 | 90013 | 2020-04-26 | Orange | Florida | 12095 | 1321 | 29 |
92831 | 92831 | 2020-04-27 | Orange | Florida | 12095 | 1338 | 29 |
95663 | 95663 | 2020-04-28 | Orange | Florida | 12095 | 1362 | 31 |
98508 | 98508 | 2020-04-29 | Orange | Florida | 12095 | 1370 | 32 |
101358 | 101358 | 2020-04-30 | Orange | Florida | 12095 | 1384 | 33 |
104213 | 104213 | 2020-05-01 | Orange | Florida | 12095 | 1412 | 33 |
107078 | 107078 | 2020-05-02 | Orange | Florida | 12095 | 1421 | 34 |
109947 | 109947 | 2020-05-03 | Orange | Florida | 12095 | 1433 | 34 |
112822 | 112822 | 2020-05-04 | Orange | Florida | 12095 | 1437 | 34 |
115705 | 115705 | 2020-05-05 | Orange | Florida | 12095 | 1445 | 34 |
118665 | 118665 | 2020-05-06 | Orange | Florida | 12095 | 1459 | 35 |
121634 | 121634 | 2020-05-07 | Orange | Florida | 12095 | 1473 | 35 |
124613 | 124613 | 2020-05-08 | Orange | Florida | 12095 | 1477 | 34 |
127600 | 127600 | 2020-05-09 | Orange | Florida | 12095 | 1504 | 34 |
130591 | 130591 | 2020-05-10 | Orange | Florida | 12095 | 1504 | 34 |
133582 | 133582 | 2020-05-11 | Orange | Florida | 12095 | 1511 | 34 |
136571 | 136571 | 2020-05-12 | Orange | Florida | 12095 | 1536 | 34 |
139562 | 139562 | 2020-05-13 | Orange | Florida | 12095 | 1552 | 35 |
142558 | 142558 | 2020-05-14 | Orange | Florida | 12095 | 1576 | 35 |
145558 | 145558 | 2020-05-15 | Orange | Florida | 12095 | 1614 | 35 |
148561 | 148561 | 2020-05-16 | Orange | Florida | 12095 | 1628 | 37 |
151570 | 151570 | 2020-05-17 | Orange | Florida | 12095 | 1654 | 37 |
154582 | 154582 | 2020-05-18 | Orange | Florida | 12095 | 1678 | 37 |
157598 | 157598 | 2020-05-19 | Orange | Florida | 12095 | 1698 | 37 |
160624 | 160624 | 2020-05-20 | Orange | Florida | 12095 | 1707 | 37 |
163652 | 163652 | 2020-05-21 | Orange | Florida | 12095 | 1725 | 37 |
166685 | 166685 | 2020-05-22 | Orange | Florida | 12095 | 1743 | 37 |
169722 | 169722 | 2020-05-23 | Orange | Florida | 12095 | 1767 | 38 |
172763 | 172763 | 2020-05-24 | Orange | Florida | 12095 | 1807 | 38 |
175806 | 175806 | 2020-05-25 | Orange | Florida | 12095 | 1830 | 38 |
178850 | 178850 | 2020-05-26 | Orange | Florida | 12095 | 1848 | 38 |
181894 | 181894 | 2020-05-27 | Orange | Florida | 12095 | 1876 | 38 |
184948 | 184948 | 2020-05-28 | Orange | Florida | 12095 | 1901 | 39 |
188004 | 188004 | 2020-05-29 | Orange | Florida | 12095 | 1944 | 40 |
191069 | 191069 | 2020-05-30 | Orange | Florida | 12095 | 1975 | 40 |
194136 | 194136 | 2020-05-31 | Orange | Florida | 12095 | 2001 | 40 |
197206 | 197206 | 2020-06-01 | Orange | Florida | 12095 | 2030 | 40 |
200279 | 200279 | 2020-06-02 | Orange | Florida | 12095 | 2047 | 40 |
203355 | 203355 | 2020-06-03 | Orange | Florida | 12095 | 2120 | 40 |
206435 | 206435 | 2020-06-04 | Orange | Florida | 12095 | 2168 | 42 |
209516 | 209516 | 2020-06-05 | Orange | Florida | 12095 | 2209 | 42 |
212601 | 212601 | 2020-06-06 | Orange | Florida | 12095 | 2255 | 44 |
215688 | 215688 | 2020-06-07 | Orange | Florida | 12095 | 2315 | 44 |
218779 | 218779 | 2020-06-08 | Orange | Florida | 12095 | 2377 | 44 |
221874 | 221874 | 2020-06-09 | Orange | Florida | 12095 | 2448 | 44 |
224969 | 224969 | 2020-06-10 | Orange | Florida | 12095 | 2541 | 45 |
228071 | 228071 | 2020-06-11 | Orange | Florida | 12095 | 2677 | 45 |
231174 | 231174 | 2020-06-12 | Orange | Florida | 12095 | 2772 | 45 |
234280 | 234280 | 2020-06-13 | Orange | Florida | 12095 | 2936 | 45 |
237387 | 237387 | 2020-06-14 | Orange | Florida | 12095 | 3129 | 45 |
240495 | 240495 | 2020-06-15 | Orange | Florida | 12095 | 3281 | 45 |
243606 | 243606 | 2020-06-16 | Orange | Florida | 12095 | 3436 | 46 |
246719 | 246719 | 2020-06-17 | Orange | Florida | 12095 | 3583 | 47 |
249831 | 249831 | 2020-06-18 | Orange | Florida | 12095 | 3899 | 47 |
252946 | 252946 | 2020-06-19 | Orange | Florida | 12095 | 4273 | 47 |
256065 | 256065 | 2020-06-20 | Orange | Florida | 12095 | 4568 | 47 |
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);