Skip to content

Instantly share code, notes, and snippets.

@grugnog

grugnog/testdata.csv

Last active May 4, 2025 17:42
Show Gist options
  • Save grugnog/2f2a294ba3912400a5b3f99f469dd9b7 to your computer and use it in GitHub Desktop.
Save grugnog/2f2a294ba3912400a5b3f99f469dd9b7 to your computer and use it in GitHub Desktop.
Download ZIP
Temp test files
Raw
testdata.csv
id string_value integer_value float_value date_value boolean_value null_value json_object mixed_case special_chars long_text currency percentage email url pattern negative quoted_string value final related_id
1 apple 100 10.5 2025-01-01 true {"0":"red","1":"green","2":"blue"} CamelCase Hello & World! This is a long text that can be used for LIKE and CONTAINS operations $100.50 75% [email protected] https://example.com ABC-123-xyz -25 quoted "value" 5
2 banana 200 20.25 2025-02-15 false NULL {"0":"yellow","1":"green"} snake_case Special @#$%^ Chars Another long text with some special words like datastore and search queries $250.75 80% [email protected] https://test.org XYZ-456-abc -50 another "quoted" string 8
3 cherry 300 30.75 2025-03-30 true {"0":"red","1":"purple"} UPPERCASE Ampersand & Symbol This text contains words like database resource CSV file and DKAN $300.00 65% [email protected] https://demo.net 123-DEF-789 -75 line 1 line 2 1
4 date 400 40.33 2025-04-15 false NULL {"0":"brown"} lowercase Percentage % Sign Short text $150.25 90% [email protected] http://domain.com 987-ZYX-321 -100 tabs    and    spaces 7
5 elderberry 500 50.80 2025-05-31 true {"0":"purple","1":"black"} Title Case Hash # Tag Medium length text with multiple sentences. This can be used for testing LIKE operators with partial matches. $500.99 45% [email protected] https://site.io/path?query=value AAA-111-bbb 0 special chars: !@#$% 10
6 fig 600 60.15 2025-06-15 false NULL {"0":"brown","1":"purple"} camelCase Plus + Sign Another paragraph of text. This one mentions CSV and JSON data formats for testing keyword search. $1200.50 30% [email protected] http://company.co/support QQQ-222-www 100 commas, inside, quotes 3
7 grape 700 70.90 2025-07-31 true {"0":"green","1":"purple"} PascalCase Equal = Sign This is text with numbers like 12345 and symbols like @#$%^ $350.75 10% [email protected] https://business.biz ZZZ-333-xxx 250 unicode: café résumé 9
8 honeydew 800 0.001 2025-08-15 false NULL {"0":"green"} kebab-case Slash / Backslash Very short text $0.01 100% [email protected] http://world.net PPP-444-yyy 500 HTML <tags>value</tags> 4
9 imbe 900 999.999 2025-09-30 true {"0":"orange"} SCREAMING_SNAKE_CASE Asterisk * Wildcard This text has words that could be used in search such as bike lanes and highways $999.99 55% [email protected] https://service.edu MMM-555-jjj 1000 JSON {"key": "value"} 2
10 jackfruit 1000 1000.001 2025-10-15 false NULL {"0":"yellow"} dot.case Parentheses ( ) Symbols The final text entry in this test data set which includes keywords and phrases. $1500.00 0% [email protected] http://institution.gov LLL-666-kkk -1500 trailing whitespace   6
11 0 0.0 1970-01-01 true NULL {} 0% -2 11
12 NULL 1 1 1960-01-01 false NULL {} NULL NULL NULL NULL NULL NULL NULL NULL 2000 NULL 12
Raw
testdata_dict.json
{
"data": {
"title": "Test Data Dictionary",
"fields": [
{
"name": "id",
"title": "ID",
"type": "integer",
"description": "Unique identifier for each record"
},
{
"name": "string_value",
"title": "String Value",
"type": "string",
"description": "Text field containing string values"
},
{
"name": "integer_value",
"title": "Integer Value",
"type": "integer",
"description": "Field containing whole number values"
},
{
"name": "float_value",
"title": "Float Value",
"type": "number",
"description": "Field containing decimal number values"
},
{
"name": "date_value",
"title": "Date Value",
"type": "date",
"format": "%Y-%m-%d",
"description": "Field containing date values in ISO format (YYYY-MM-DD)"
},
{
"name": "boolean_value",
"title": "Boolean Value",
"type": "boolean",
"description": "Field containing true/false values"
},
{
"name": "null_value",
"title": "Null Value",
"type": "string",
"description": "Field demonstrating NULL values"
},
{
"name": "json_object",
"title": "JSON Object",
"type": "array",
"description": "Field containing JSON objects"
},
{
"name": "mixed_case",
"title": "Mixed Case",
"type": "string",
"description": "Field demonstrating different text case styles"
},
{
"name": "special_chars",
"title": "Special Characters",
"type": "string",
"description": "Field containing special characters"
},
{
"name": "long_text",
"title": "Long Text",
"type": "string",
"description": "Field containing longer text passages for testing LIKE and CONTAINS operations"
},
{
"name": "currency",
"title": "Currency",
"type": "string",
"description": "Field containing monetary values with currency symbols"
},
{
"name": "percentage",
"title": "Percentage",
"type": "string",
"description": "Field containing percentage values"
},
{
"name": "email",
"title": "Email",
"type": "string",
"format": "email",
"description": "Field containing email addresses"
},
{
"name": "url",
"title": "URL",
"type": "string",
"format": "uri",
"description": "Field containing web URLs"
},
{
"name": "pattern",
"title": "Pattern",
"type": "string",
"description": "Field containing text with specific patterns"
},
{
"name": "negative",
"title": "Negative",
"type": "integer",
"description": "Field containing negative number values"
},
{
"name": "quoted_string",
"title": "Quoted String",
"type": "string",
"description": "Field containing strings with quoted content"
},
{
"name": "value",
"title": "Value",
"type": "string",
"description": "Generic value field"
},
{
"name": "final",
"title": "Final",
"type": "string",
"description": "Final field in the dataset"
},
{
"name": "related_id",
"title": "Related ID",
"type": "integer",
"description": "A related ID field for testing JOIN operations"
}
]
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment