ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,594 rows where county = "Hillsborough" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
412 | 412 | 2020-03-01 | Hillsborough | Florida | 12057 | 1 | 0 |
441 | 441 | 2020-03-02 | Hillsborough | Florida | 12057 | 1 | 0 |
475 | 475 | 2020-03-03 | Hillsborough | Florida | 12057 | 2 | 0 |
510 | 510 | 2020-03-04 | Hillsborough | Florida | 12057 | 2 | 0 |
551 | 551 | 2020-03-05 | Hillsborough | Florida | 12057 | 2 | 0 |
606 | 606 | 2020-03-06 | Hillsborough | Florida | 12057 | 2 | 0 |
686 | 686 | 2020-03-07 | Hillsborough | Florida | 12057 | 2 | 0 |
782 | 782 | 2020-03-08 | Hillsborough | Florida | 12057 | 2 | 0 |
899 | 899 | 2020-03-09 | Hillsborough | Florida | 12057 | 2 | 0 |
1036 | 1036 | 2020-03-10 | Hillsborough | Florida | 12057 | 2 | 0 |
1205 | 1205 | 2020-03-11 | Hillsborough | Florida | 12057 | 2 | 0 |
1416 | 1416 | 2020-03-12 | Hillsborough | Florida | 12057 | 3 | 0 |
1682 | 1682 | 2020-03-13 | Hillsborough | Florida | 12057 | 3 | 0 |
2004 | 2004 | 2020-03-14 | Hillsborough | Florida | 12057 | 3 | 0 |
2388 | 2388 | 2020-03-15 | Hillsborough | Florida | 12057 | 6 | 0 |
2546 | 2546 | 2020-03-15 | Hillsborough | New Hampshire | 33011 | 1 | 0 |
2824 | 2824 | 2020-03-16 | Hillsborough | Florida | 12057 | 6 | 0 |
3002 | 3002 | 2020-03-16 | Hillsborough | New Hampshire | 33011 | 1 | 0 |
3308 | 3308 | 2020-03-17 | Hillsborough | Florida | 12057 | 9 | 0 |
3514 | 3514 | 2020-03-17 | Hillsborough | New Hampshire | 33011 | 4 | 0 |
3865 | 3865 | 2020-03-18 | Hillsborough | Florida | 12057 | 14 | 0 |
4108 | 4108 | 2020-03-18 | Hillsborough | New Hampshire | 33011 | 8 | 0 |
4531 | 4531 | 2020-03-19 | Hillsborough | Florida | 12057 | 20 | 0 |
4834 | 4834 | 2020-03-19 | Hillsborough | New Hampshire | 33011 | 8 | 0 |
5310 | 5310 | 2020-03-20 | Hillsborough | Florida | 12057 | 32 | 0 |
5677 | 5677 | 2020-03-20 | Hillsborough | New Hampshire | 33011 | 11 | 0 |
6239 | 6239 | 2020-03-21 | Hillsborough | Florida | 12057 | 47 | 0 |
6669 | 6669 | 2020-03-21 | Hillsborough | New Hampshire | 33011 | 12 | 0 |
7279 | 7279 | 2020-03-22 | Hillsborough | Florida | 12057 | 58 | 0 |
7759 | 7759 | 2020-03-22 | Hillsborough | New Hampshire | 33011 | 16 | 0 |
8425 | 8425 | 2020-03-23 | Hillsborough | Florida | 12057 | 75 | 0 |
8955 | 8955 | 2020-03-23 | Hillsborough | New Hampshire | 33011 | 19 | 1 |
9670 | 9670 | 2020-03-24 | Hillsborough | Florida | 12057 | 95 | 0 |
10259 | 10259 | 2020-03-24 | Hillsborough | New Hampshire | 33011 | 20 | 1 |
11045 | 11045 | 2020-03-25 | Hillsborough | Florida | 12057 | 123 | 0 |
11691 | 11691 | 2020-03-25 | Hillsborough | New Hampshire | 33011 | 30 | 1 |
12593 | 12593 | 2020-03-26 | Hillsborough | Florida | 12057 | 151 | 1 |
13294 | 13294 | 2020-03-26 | Hillsborough | New Hampshire | 33011 | 35 | 1 |
14262 | 14262 | 2020-03-27 | Hillsborough | Florida | 12057 | 174 | 2 |
15026 | 15026 | 2020-03-27 | Hillsborough | New Hampshire | 33011 | 43 | 2 |
16047 | 16047 | 2020-03-28 | Hillsborough | Florida | 12057 | 206 | 2 |
16855 | 16855 | 2020-03-28 | Hillsborough | New Hampshire | 33011 | 53 | 2 |
17940 | 17940 | 2020-03-29 | Hillsborough | Florida | 12057 | 225 | 2 |
18779 | 18779 | 2020-03-29 | Hillsborough | New Hampshire | 33011 | 68 | 2 |
19920 | 19920 | 2020-03-30 | Hillsborough | Florida | 12057 | 272 | 2 |
20817 | 20817 | 2020-03-30 | Hillsborough | New Hampshire | 33011 | 91 | 2 |
21998 | 21998 | 2020-03-31 | Hillsborough | Florida | 12057 | 305 | 3 |
22940 | 22940 | 2020-03-31 | Hillsborough | New Hampshire | 33011 | 108 | 2 |
24159 | 24159 | 2020-04-01 | Hillsborough | Florida | 12057 | 362 | 3 |
25131 | 25131 | 2020-04-01 | Hillsborough | New Hampshire | 33011 | 129 | 2 |
26389 | 26389 | 2020-04-02 | Hillsborough | Florida | 12057 | 404 | 5 |
27391 | 27391 | 2020-04-02 | Hillsborough | New Hampshire | 33011 | 163 | 3 |
28692 | 28692 | 2020-04-03 | Hillsborough | Florida | 12057 | 463 | 5 |
29714 | 29714 | 2020-04-03 | Hillsborough | New Hampshire | 33011 | 194 | 5 |
31051 | 31051 | 2020-04-04 | Hillsborough | Florida | 12057 | 497 | 5 |
32098 | 32098 | 2020-04-04 | Hillsborough | New Hampshire | 33011 | 231 | 7 |
33457 | 33457 | 2020-04-05 | Hillsborough | Florida | 12057 | 536 | 5 |
34529 | 34529 | 2020-04-05 | Hillsborough | New Hampshire | 33011 | 249 | 7 |
35903 | 35903 | 2020-04-06 | Hillsborough | Florida | 12057 | 575 | 5 |
36999 | 36999 | 2020-04-06 | Hillsborough | New Hampshire | 33011 | 272 | 7 |
38394 | 38394 | 2020-04-07 | Hillsborough | Florida | 12057 | 608 | 7 |
39514 | 39514 | 2020-04-07 | Hillsborough | New Hampshire | 33011 | 288 | 9 |
40937 | 40937 | 2020-04-08 | Hillsborough | Florida | 12057 | 631 | 7 |
42071 | 42071 | 2020-04-08 | Hillsborough | New Hampshire | 33011 | 303 | 13 |
43511 | 43511 | 2020-04-09 | Hillsborough | Florida | 12057 | 657 | 9 |
44654 | 44654 | 2020-04-09 | Hillsborough | New Hampshire | 33011 | 318 | 14 |
46112 | 46112 | 2020-04-10 | Hillsborough | Florida | 12057 | 676 | 12 |
47266 | 47266 | 2020-04-10 | Hillsborough | New Hampshire | 33011 | 344 | 15 |
48742 | 48742 | 2020-04-11 | Hillsborough | Florida | 12057 | 698 | 15 |
49919 | 49919 | 2020-04-11 | Hillsborough | New Hampshire | 33011 | 367 | 15 |
51403 | 51403 | 2020-04-12 | Hillsborough | Florida | 12057 | 759 | 16 |
52592 | 52592 | 2020-04-12 | Hillsborough | New Hampshire | 33011 | 385 | 15 |
54083 | 54083 | 2020-04-13 | Hillsborough | Florida | 12057 | 813 | 16 |
55275 | 55275 | 2020-04-13 | Hillsborough | New Hampshire | 33011 | 398 | 15 |
56775 | 56775 | 2020-04-14 | Hillsborough | Florida | 12057 | 819 | 18 |
57975 | 57975 | 2020-04-14 | Hillsborough | New Hampshire | 33011 | 440 | 19 |
59483 | 59483 | 2020-04-15 | Hillsborough | Florida | 12057 | 870 | 18 |
60690 | 60690 | 2020-04-15 | Hillsborough | New Hampshire | 33011 | 458 | 21 |
62202 | 62202 | 2020-04-16 | Hillsborough | Florida | 12057 | 878 | 18 |
63415 | 63415 | 2020-04-16 | Hillsborough | New Hampshire | 33011 | 483 | 22 |
64935 | 64935 | 2020-04-17 | Hillsborough | Florida | 12057 | 924 | 19 |
66157 | 66157 | 2020-04-17 | Hillsborough | New Hampshire | 33011 | 525 | 23 |
67683 | 67683 | 2020-04-18 | Hillsborough | Florida | 12057 | 943 | 19 |
68913 | 68913 | 2020-04-18 | Hillsborough | New Hampshire | 33011 | 552 | 23 |
70445 | 70445 | 2020-04-19 | Hillsborough | Florida | 12057 | 960 | 19 |
71680 | 71680 | 2020-04-19 | Hillsborough | New Hampshire | 33011 | 581 | 24 |
73214 | 73214 | 2020-04-20 | Hillsborough | Florida | 12057 | 973 | 19 |
74455 | 74455 | 2020-04-20 | Hillsborough | New Hampshire | 33011 | 604 | 24 |
75990 | 75990 | 2020-04-21 | Hillsborough | Florida | 12057 | 979 | 20 |
77236 | 77236 | 2020-04-21 | Hillsborough | New Hampshire | 33011 | 626 | 24 |
78774 | 78774 | 2020-04-22 | Hillsborough | Florida | 12057 | 982 | 20 |
80025 | 80025 | 2020-04-22 | Hillsborough | New Hampshire | 33011 | 681 | 27 |
81568 | 81568 | 2020-04-23 | Hillsborough | Florida | 12057 | 1008 | 21 |
82823 | 82823 | 2020-04-23 | Hillsborough | New Hampshire | 33011 | 721 | 28 |
84368 | 84368 | 2020-04-24 | Hillsborough | Florida | 12057 | 1022 | 21 |
85627 | 85627 | 2020-04-24 | Hillsborough | New Hampshire | 33011 | 753 | 28 |
87176 | 87176 | 2020-04-25 | Hillsborough | Florida | 12057 | 1041 | 21 |
88438 | 88438 | 2020-04-25 | Hillsborough | New Hampshire | 33011 | 780 | 31 |
89993 | 89993 | 2020-04-26 | Hillsborough | Florida | 12057 | 1048 | 21 |
91253 | 91253 | 2020-04-26 | Hillsborough | New Hampshire | 33011 | 824 | 31 |
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);