Capital Program Test Data

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.illinois.gov
Id ta5w-2j59
Name Capital Program Test Data
Created 2013-12-10T17:30:29Z
Publication Date 2013-12-17T23:41:56Z

Description

Socrata dataset

Columns

| Included | Schema Type    | Field Name   | Name         | Data Type | Render Type |
| ======== | ============== | ============ | ============ | ========= | =========== |
| No       | time           | :updated_at  | updated_at   | meta_data | meta_data   |
| Yes      | series tag     | program_name | Program Name | text      | text        |
| Yes      | series tag     | program_type | Program Type | text      | text        |
| Yes      | series tag     | county       | County       | text      | text        |
| Yes      | numeric metric | amount_spent | Amount Spent | number    | number      |
| Yes      | series tag     | image        | Image        | photo     | photo       |

Time Field

Value = updated_at
Format & Zone = seconds

Data Commands

series e:ta5w-2j59 d:2013-12-10T09:30:47.000Z t:program_type=Finance t:county=Winnebago t:program_name=Lorem m:amount_spent=23532

series e:ta5w-2j59 d:2013-12-10T09:30:47.000Z t:program_type=Revenue t:county=Winnebago t:program_name=Ipsum m:amount_spent=143

series e:ta5w-2j59 d:2013-12-10T09:30:47.000Z t:program_type=Environment t:county=Winnebago t:program_name=Dolor m:amount_spent=2342

Meta Commands

metric m:amount_spent p:integer l:"Amount Spent" t:dataTypeName=number

entity e:ta5w-2j59 l:"Capital Program Test Data" t:url=https://data.illinois.gov/api/views/ta5w-2j59

property e:ta5w-2j59 t:meta.view v:id=ta5w-2j59 v:averageRating=0 v:name="Capital Program Test Data"

property e:ta5w-2j59 t:meta.view.owner v:id=vcvp-yass v:profileImageUrlMedium=/api/users/vcvp-yass/profile_images/THUMB v:profileImageUrlLarge=/api/users/vcvp-yass/profile_images/LARGE v:screenName="Dylan Bussone" v:profileImageUrlSmall=/api/users/vcvp-yass/profile_images/TINY v:displayName="Dylan Bussone"

property e:ta5w-2j59 t:meta.view.tableauthor v:id=vcvp-yass v:profileImageUrlMedium=/api/users/vcvp-yass/profile_images/THUMB v:profileImageUrlLarge=/api/users/vcvp-yass/profile_images/LARGE v:screenName="Dylan Bussone" v:profileImageUrlSmall=/api/users/vcvp-yass/profile_images/TINY v:displayName="Dylan Bussone"

Top Records

| :updated_at | program_name | program_type   | county    | amount_spent | image | 
| =========== | ============ | ============== | ========= | ============ | ===== | 
| 1386667847  | Lorem        | Finance        | Winnebago | 23532        |       | 
| 1386667847  | Ipsum        | Revenue        | Winnebago | 143          |       | 
| 1386667847  | Dolor        | Environment    | Winnebago | 2342         |       | 
| 1386667847  | Sit Amet     | Transportation | Winnebago | 231          |       | 
| 1386667847  | Consectetur  | Finance        | Champaign | 454564       |       | 
| 1386667847  | Adipiscing   | Revenue        | Champaign | 4324         |       | 
| 1386667847  | Vestibulum   | Environment    | Champaign | 332          |       | 
| 1386667847  | Tortor Risus | Transportation | Champaign | 234123       |       | 
| 1386667847  | Laoreet Ut   | Finance        | St. Clair | 1234         |       | 
| 1386667847  | Ante         | Revenue        | St. Clair | 23455        |       |