us-states

Table actions

Data source: Big Local News · About: big-local-datasette

11,399 rows sorted by fips descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date (date)

Link rowid date state fips ▲ cases deaths
685 685 2020-03-14 Virgin Islands 78 1 0
738 738 2020-03-15 Virgin Islands 78 1 0
791 791 2020-03-16 Virgin Islands 78 2 0
844 844 2020-03-17 Virgin Islands 78 2 0
898 898 2020-03-18 Virgin Islands 78 3 0
952 952 2020-03-19 Virgin Islands 78 3 0
1006 1006 2020-03-20 Virgin Islands 78 6 0
1060 1060 2020-03-21 Virgin Islands 78 6 0
1114 1114 2020-03-22 Virgin Islands 78 17 0
1168 1168 2020-03-23 Virgin Islands 78 17 0
1222 1222 2020-03-24 Virgin Islands 78 17 0
1276 1276 2020-03-25 Virgin Islands 78 17 0
1330 1330 2020-03-26 Virgin Islands 78 17 0
1384 1384 2020-03-27 Virgin Islands 78 19 0
1439 1439 2020-03-28 Virgin Islands 78 19 0
1494 1494 2020-03-29 Virgin Islands 78 23 0
1549 1549 2020-03-30 Virgin Islands 78 30 0
1604 1604 2020-03-31 Virgin Islands 78 30 0
1659 1659 2020-04-01 Virgin Islands 78 30 0
1714 1714 2020-04-02 Virgin Islands 78 37 0
1769 1769 2020-04-03 Virgin Islands 78 38 0
1824 1824 2020-04-04 Virgin Islands 78 42 0
1879 1879 2020-04-05 Virgin Islands 78 42 0
1934 1934 2020-04-06 Virgin Islands 78 44 1
1989 1989 2020-04-07 Virgin Islands 78 45 1
2044 2044 2020-04-08 Virgin Islands 78 46 1
2099 2099 2020-04-09 Virgin Islands 78 50 1
2154 2154 2020-04-10 Virgin Islands 78 51 1
2209 2209 2020-04-11 Virgin Islands 78 51 1
2264 2264 2020-04-12 Virgin Islands 78 51 1
2319 2319 2020-04-13 Virgin Islands 78 51 1
2374 2374 2020-04-14 Virgin Islands 78 51 1
2429 2429 2020-04-15 Virgin Islands 78 51 1
2484 2484 2020-04-16 Virgin Islands 78 51 2
2539 2539 2020-04-17 Virgin Islands 78 53 3
2594 2594 2020-04-18 Virgin Islands 78 53 3
2649 2649 2020-04-19 Virgin Islands 78 53 3
2704 2704 2020-04-20 Virgin Islands 78 54 3
2759 2759 2020-04-21 Virgin Islands 78 54 3
2814 2814 2020-04-22 Virgin Islands 78 54 3
2869 2869 2020-04-23 Virgin Islands 78 54 3
2924 2924 2020-04-24 Virgin Islands 78 55 3
2979 2979 2020-04-25 Virgin Islands 78 57 4
3034 3034 2020-04-26 Virgin Islands 78 59 4
3089 3089 2020-04-27 Virgin Islands 78 59 4
3144 3144 2020-04-28 Virgin Islands 78 62 4
3199 3199 2020-04-29 Virgin Islands 78 66 4
3254 3254 2020-04-30 Virgin Islands 78 66 4
3309 3309 2020-05-01 Virgin Islands 78 66 4
3364 3364 2020-05-02 Virgin Islands 78 66 4
3419 3419 2020-05-03 Virgin Islands 78 66 4
3474 3474 2020-05-04 Virgin Islands 78 66 4
3529 3529 2020-05-05 Virgin Islands 78 66 4
3584 3584 2020-05-06 Virgin Islands 78 66 4
3639 3639 2020-05-07 Virgin Islands 78 68 4
3694 3694 2020-05-08 Virgin Islands 78 69 4
3749 3749 2020-05-09 Virgin Islands 78 69 4
3804 3804 2020-05-10 Virgin Islands 78 69 5
3859 3859 2020-05-11 Virgin Islands 78 69 6
3914 3914 2020-05-12 Virgin Islands 78 69 6
3969 3969 2020-05-13 Virgin Islands 78 69 6
4024 4024 2020-05-14 Virgin Islands 78 69 6
4079 4079 2020-05-15 Virgin Islands 78 69 6
4134 4134 2020-05-16 Virgin Islands 78 69 6
4189 4189 2020-05-17 Virgin Islands 78 69 6
4244 4244 2020-05-18 Virgin Islands 78 69 6
4299 4299 2020-05-19 Virgin Islands 78 69 6
4354 4354 2020-05-20 Virgin Islands 78 69 6
4409 4409 2020-05-21 Virgin Islands 78 69 6
4464 4464 2020-05-22 Virgin Islands 78 69 6
4519 4519 2020-05-23 Virgin Islands 78 69 6
4574 4574 2020-05-24 Virgin Islands 78 69 6
4629 4629 2020-05-25 Virgin Islands 78 69 6
4684 4684 2020-05-26 Virgin Islands 78 69 6
4739 4739 2020-05-27 Virgin Islands 78 69 6
4794 4794 2020-05-28 Virgin Islands 78 69 6
4849 4849 2020-05-29 Virgin Islands 78 69 6
4904 4904 2020-05-30 Virgin Islands 78 70 6
4959 4959 2020-05-31 Virgin Islands 78 70 6
5014 5014 2020-06-01 Virgin Islands 78 70 6
5069 5069 2020-06-02 Virgin Islands 78 70 6
5124 5124 2020-06-03 Virgin Islands 78 71 6
5179 5179 2020-06-04 Virgin Islands 78 71 6
5234 5234 2020-06-05 Virgin Islands 78 71 6
5289 5289 2020-06-06 Virgin Islands 78 71 6
5344 5344 2020-06-07 Virgin Islands 78 71 6
5399 5399 2020-06-08 Virgin Islands 78 71 6
5454 5454 2020-06-09 Virgin Islands 78 72 6
5509 5509 2020-06-10 Virgin Islands 78 72 6
5564 5564 2020-06-11 Virgin Islands 78 72 6
5619 5619 2020-06-12 Virgin Islands 78 72 6
5674 5674 2020-06-13 Virgin Islands 78 72 6
5729 5729 2020-06-14 Virgin Islands 78 73 6
5784 5784 2020-06-15 Virgin Islands 78 73 6
5839 5839 2020-06-16 Virgin Islands 78 73 6
5894 5894 2020-06-17 Virgin Islands 78 73 6
5949 5949 2020-06-18 Virgin Islands 78 74 6
6004 6004 2020-06-19 Virgin Islands 78 74 6
6059 6059 2020-06-20 Virgin Islands 78 76 6
6114 6114 2020-06-21 Virgin Islands 78 76 6

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [us-states] (
   [date] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);