-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsummary.txt
176 lines (146 loc) · 4.93 KB
/
summary.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
1. "BIOGUIDE_ID"
Type of data: Text
Contains null values: True (excluded from calculations)
Unique values: 290
Longest value: 7 characters
Most common values: None (193x)
B001270 (14x)
P000601 (14x)
S001185 (12x)
B001283 (11x)
2. "OFFICE"
Type of data: Text
Contains null values: False
Unique values: 318
Longest value: 33 characters
Most common values: OFFICE OF THE SPEAKER (29x)
REPUBLICAN CONFERENCE (29x)
OFFICE OF THE MINORITY LEADER (25x)
DEMOCRATIC CAUCUS (17x)
HON. KAREN BASS (14x)
3. "QUARTER"
Type of data: Text
Contains null values: False
Unique values: 1
Longest value: 6 characters
Most common values: 2017Q1 (942x)
4. "PROGRAM"
Type of data: Text
Contains null values: False
Unique values: 10
Longest value: 30 characters
Most common values: OFFICIAL EXPENSES OF MEMBERS (749x)
GENERAL EXPENDITURES (174x)
FAMILY ROOM (4x)
CHILD CARE CENTER (4x)
RECEPTIONS (3x)
5. "CATEGORY"
Type of data: Text
Contains null values: False
Unique values: 1
Longest value: 22 characters
Most common values: SUPPLIES AND MATERIALS (942x)
6. "DATE"
Type of data: Date
Contains null values: False
Unique values: 68
Smallest value: 2017-01-03
Largest value: 2017-03-31
Most common values: 2017-03-21 (118x)
2017-01-19 (99x)
2017-02-17 (96x)
2017-01-17 (49x)
2017-03-28 (33x)
7. "TRANSCODE"
Type of data: Text
Contains null values: False
Unique values: 1
Longest value: 2 characters
Most common values: AP (942x)
8. "RECORDID"
Type of data: Text
Contains null values: False
Unique values: 521
Longest value: 8 characters
Most common values: 912200 (107x)
900647 (95x)
904174 (93x)
897454 (30x)
912383 (23x)
9. "PAYEE"
Type of data: Text
Contains null values: False
Unique values: 506
Longest value: 40 characters
Most common values: BOISE CASCADE COMPANY (122x)
CITIBANK GOV CARD SERVICE (35x)
CAPITOL HOST (29x)
FIRST CHOICE COFFEE SERVICES (15x)
ARAMARK REFRESHMENT SERVICES (15x)
10. "START DATE"
Type of data: Date
Contains null values: False
Unique values: 143
Smallest value: 2015-12-05
Largest value: 2017-03-18
Most common values: 2017-01-03 (112x)
2017-01-29 (108x)
2016-11-29 (97x)
2016-12-19 (20x)
2017-01-27 (17x)
11. "END DATE"
Type of data: Date
Contains null values: False
Unique values: 143
Smallest value: 2015-12-05
Largest value: 2017-12-31
Most common values: 2017-02-28 (125x)
2016-12-28 (98x)
2017-01-28 (93x)
2017-01-27 (20x)
2016-12-19 (20x)
12. "PURPOSE"
Type of data: Text
Contains null values: False
Unique values: 1
Longest value: 15 characters
Most common values: FOOD & BEVERAGE (942x)
13. "AMOUNT"
Type of data: Number
Contains null values: False
Unique values: 880
Smallest value: 100.1
Largest value: 19,135
Sum: 543,233.55
Mean: 576.681
Median: 204.345
StDev: 1,405.929
Most common values: 120 (9x)
110 (7x)
150 (5x)
300 (4x)
155 (4x)
14. "YEAR"
Type of data: Number
Contains null values: False
Unique values: 3
Smallest value: 2,015
Largest value: 2,017
Sum: 1,899,692
Mean: 2,016.658
Median: 2,017
StDev: 0.477
Most common values: 2,017 (621x)
2,016 (320x)
2,015 (1x)
15. "RECIP (orig.)"
Type of data: Text
Contains null values: False
Unique values: 506
Longest value: 40 characters
Most common values: BOISE CASCADE COMPANY (122x)
CITIBANK GOV CARD SERVICE (35x)
CAPITOL HOST (29x)
FIRST CHOICE COFFEE SERVICES (15x)
ARAMARK REFRESHMENT SERVICES (15x)
Row count: 942