exports[`command - apptrace 1`] = `
[
  {
    "TableName": "AppTraces",
    "Schema": "{\\"Name\\":\\"AppTraces\\",\\"OrderedColumns\\":[{\\"Name\\":\\"AppRoleInstance\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"AppRoleName\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"AppVersion\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"_BilledSize\\",\\"Type\\":\\"System.Double\\",\\"CslType\\":\\"real\\"},{\\"Name\\":\\"ClientBrowser\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"ClientCity\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"ClientCountryOrRegion\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"ClientIP\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"ClientModel\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"ClientOS\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"ClientStateOrProvince\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"ClientType\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"IKey\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"_IsBillable\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"ItemCount\\",\\"Type\\":\\"System.Double\\",\\"CslType\\":\\"real\\"},{\\"Name\\":\\"Measurements\\",\\"Type\\":\\"System.Object\\",\\"CslType\\":\\"dynamic\\"},{\\"Name\\":\\"Message\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"OperationId\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"OperationName\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"ParentId\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"Properties\\",\\"Type\\":\\"System.Object\\",\\"CslType\\":\\"dynamic\\"},{\\"Name\\":\\"ReferencedItemId\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"ReferencedType\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"ResourceGUID\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"_ResourceId\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"SDKVersion\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"SessionId\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"SeverityLevel\\",\\"Type\\":\\"System.Double\\",\\"CslType\\":\\"real\\"},{\\"Name\\":\\"SourceSystem\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"_SubscriptionId\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"SyntheticSource\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"TenantId\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"TimeGenerated\\",\\"Type\\":\\"System.Object\\",\\"CslType\\":\\"dynamic\\"},{\\"Name\\":\\"Type\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"UserAccountId\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"UserAuthenticatedId\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"UserId\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"}]}",
    "DatabaseName": "Test",
    "Folder": null,
    "DocString": null
  }
]
`;

exports[`command - apptrace 2`] = `
[
  {
    "TableName": "AppTraces",
    "Schema": "{\\"Name\\":\\"AppTraces\\",\\"OrderedColumns\\":[{\\"Name\\":\\"AppRoleInstance\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"AppRoleName\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"AppVersion\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"_BilledSize\\",\\"Type\\":\\"System.Double\\",\\"CslType\\":\\"real\\"},{\\"Name\\":\\"ClientBrowser\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"ClientCity\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"ClientCountryOrRegion\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"ClientIP\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"ClientModel\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"ClientOS\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"ClientStateOrProvince\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"ClientType\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"IKey\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"_IsBillable\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"ItemCount\\",\\"Type\\":\\"System.Double\\",\\"CslType\\":\\"real\\"},{\\"Name\\":\\"Measurements\\",\\"Type\\":\\"System.Object\\",\\"CslType\\":\\"dynamic\\"},{\\"Name\\":\\"Message\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"OperationId\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"OperationName\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"ParentId\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"Properties\\",\\"Type\\":\\"System.Object\\",\\"CslType\\":\\"dynamic\\"},{\\"Name\\":\\"ReferencedItemId\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"ReferencedType\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"ResourceGUID\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"_ResourceId\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"SDKVersion\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"SessionId\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"SeverityLevel\\",\\"Type\\":\\"System.Double\\",\\"CslType\\":\\"real\\"},{\\"Name\\":\\"SourceSystem\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"_SubscriptionId\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"SyntheticSource\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"TenantId\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"TimeGenerated\\",\\"Type\\":\\"System.Object\\",\\"CslType\\":\\"dynamic\\"},{\\"Name\\":\\"Type\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"UserAccountId\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"UserAuthenticatedId\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"UserId\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"}]}",
    "DatabaseName": "Test",
    "Folder": null,
    "DocString": null
  }
]
`;

exports[`command - apptrace 3`] = `
[
  {
    "Name": "JsonMapping",
    "Kind": "Json",
    "Mapping": "[{\\"column\\":\\"AppRoleInstance\\",\\"path\\":\\"$.AppRoleInstance\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"AppRoleName\\",\\"path\\":\\"$.AppRoleName\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"AppVersion\\",\\"path\\":\\"$.AppVersion\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"_BilledSize\\",\\"path\\":\\"$._BilledSize\\",\\"datatype\\":\\"real\\"},{\\"column\\":\\"ClientBrowser\\",\\"path\\":\\"$.ClientBrowser\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"ClientCity\\",\\"path\\":\\"$.ClientCity\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"ClientCountryOrRegion\\",\\"path\\":\\"$.ClientCountryOrRegion\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"ClientIP\\",\\"path\\":\\"$.ClientIP\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"ClientModel\\",\\"path\\":\\"$.ClientModel\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"ClientOS\\",\\"path\\":\\"$.ClientOS\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"ClientStateOrProvince\\",\\"path\\":\\"$.ClientStateOrProvince\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"ClientType\\",\\"path\\":\\"$.ClientType\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"IKey\\",\\"path\\":\\"$.IKey\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"_IsBillable\\",\\"path\\":\\"$._IsBillable\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"ItemCount\\",\\"path\\":\\"$.ItemCount\\",\\"datatype\\":\\"real\\"},{\\"column\\":\\"Measurements\\",\\"path\\":\\"$.Measurements\\",\\"datatype\\":\\"dynamic\\"},{\\"column\\":\\"Message\\",\\"path\\":\\"$.Message\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"OperationId\\",\\"path\\":\\"$.OperationId\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"OperationName\\",\\"path\\":\\"$.OperationName\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"ParentId\\",\\"path\\":\\"$.ParentId\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"Properties\\",\\"path\\":\\"$.Properties\\",\\"datatype\\":\\"dynamic\\"},{\\"column\\":\\"ReferencedItemId\\",\\"path\\":\\"$.ReferencedItemId\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"ReferencedType\\",\\"path\\":\\"$.ReferencedType\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"ResourceGUID\\",\\"path\\":\\"$.ResourceGUID\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"_ResourceId\\",\\"path\\":\\"$._ResourceId\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"SDKVersion\\",\\"path\\":\\"$.SDKVersion\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"SessionId\\",\\"path\\":\\"$.SessionId\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"SeverityLevel\\",\\"path\\":\\"$.SeverityLevel\\",\\"datatype\\":\\"real\\"},{\\"column\\":\\"SourceSystem\\",\\"path\\":\\"$.SourceSystem\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"_SubscriptionId\\",\\"path\\":\\"$._SubscriptionId\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"SyntheticSource\\",\\"path\\":\\"$.SyntheticSource\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"TenantId\\",\\"path\\":\\"$.TenantId\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"TimeGenerated\\",\\"path\\":\\"$.TimeGenerated\\",\\"datatype\\":\\"dynamic\\"},{\\"column\\":\\"Type\\",\\"path\\":\\"$.Type\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"UserAccountId\\",\\"path\\":\\"$.UserAccountId\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"UserAuthenticatedId\\",\\"path\\":\\"$.UserAuthenticatedId\\",\\"datatype\\":\\"string\\"},{\\"column\\":\\"UserId\\",\\"path\\":\\"$.UserId\\",\\"datatype\\":\\"string\\"}]",
    "LastUpdatedOn": "1899-12-31T00:00:00.000Z",
    "Database": "Test",
    "Table": "AppTraces"
  }
]
`;

exports[`command - apptrace 4`] = `
[
  {
    "ExtentId": "00000000-0000-0000-0000-000000000000",
    "ItemLoaded": "inproc:00000000-0000-0000-0000-000000000000",
    "Duration": 0,
    "HasErrors": false,
    "OperationId": "00000000-0000-0000-0000-000000000000"
  }
]
`;

exports[`command - apptrace 5`] = `
[
  {
    "Message": "8ne1_dRFxfpc1bERP748_"
  }
]
`;

exports[`command - apptrace 6`] = `
[]
`;

exports[`command - medium-guide 1`] = `
[
  {
    "EventType": "Wildfire",
    "State": "California",
    "DamageProperty": 2500000
  },
  {
    "EventType": "Flood",
    "State": "California",
    "DamageProperty": 1500000
  }
]
`;

exports[`command - medium-guide 10`] = `
[
  {
    "AvgDamage": [
      10,
      11,
      50,
      10.5,
      10.8
    ],
    "BeginTime": [
      "2024-01-01T00:00:00.0000000Z",
      "2024-01-02T00:00:00.0000000Z",
      "2024-01-03T00:00:00.0000000Z",
      "2024-01-04T00:00:00.0000000Z",
      "2024-01-05T00:00:00.0000000Z"
    ],
    "Anomalies": [
      0,
      0,
      1,
      0,
      0
    ]
  }
]
`;

exports[`command - medium-guide 2`] = `
[
  {
    "EventType": "Flood",
    "State": "California",
    "TotalDamage": 2000000,
    "EventCount": 2
  },
  {
    "EventType": "Flood",
    "State": "Florida",
    "TotalDamage": 900000,
    "EventCount": 1
  },
  {
    "EventType": "Hail",
    "State": "Texas",
    "TotalDamage": 500000,
    "EventCount": 2
  }
]
`;

exports[`command - medium-guide 3`] = `
[
  {
    "State": "California",
    "EventType": "Flood",
    "DamageProperty": 1500000
  },
  {
    "State": "Florida",
    "EventType": "Flood",
    "DamageProperty": 900000
  },
  {
    "State": "Texas",
    "EventType": "Hail",
    "DamageProperty": 500000
  }
]
`;

exports[`command - medium-guide 4`] = `
[
  {
    "EventId": 1,
    "State": "California",
    "Region": "West",
    "DamageProperty": 1500000
  },
  {
    "EventId": 2,
    "State": "Texas",
    "Region": "South",
    "DamageProperty": 500000
  },
  {
    "EventId": 3,
    "State": "Florida",
    "Region": "South",
    "DamageProperty": 900000
  }
]
`;

exports[`command - medium-guide 5`] = `
[
  {
    "EventType": "Flood",
    "DamageProperty": 1500000,
    "DamageCategory": "High"
  },
  {
    "EventType": "Hail",
    "DamageProperty": 700000,
    "DamageCategory": "Medium"
  },
  {
    "EventType": "Thunderstorm",
    "DamageProperty": 100000,
    "DamageCategory": "Low"
  }
]
`;

exports[`command - medium-guide 6`] = `
[
  {
    "LowerState": "california",
    "UpperEventType": "FLOOD WARNING"
  },
  {
    "LowerState": "florida",
    "UpperEventType": "FLOOD ADVISORY"
  }
]
`;

exports[`command - medium-guide 7`] = `
[
  {
    "EventId": 1,
    "EventType": "Flood",
    "Severity": "High"
  },
  {
    "EventId": 3,
    "EventType": "Flood",
    "Severity": "Medium"
  }
]
`;

exports[`command - medium-guide 8`] = `
[
  {
    "EventId": 1,
    "Tag": "flood"
  },
  {
    "EventId": 1,
    "Tag": "urgent"
  },
  {
    "EventId": 2,
    "Tag": "hail"
  },
  {
    "EventId": 3,
    "Tag": "coastal"
  },
  {
    "EventId": 3,
    "Tag": "flood"
  }
]
`;

exports[`command - medium-guide 9`] = `
[
  {
    "TotalDamage": 2000000,
    "AverageDamage": 1000000
  }
]
`;

exports[`command - print 1`] = `
[
  {
    "Message": "Test"
  }
]
`;

exports[`command - storm-events 1`] = `
[
  {
    "TableName": "StormEvents",
    "Schema": "{\\"Name\\":\\"StormEvents\\",\\"OrderedColumns\\":[{\\"Name\\":\\"EventId\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"State\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"Damage\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"}]}",
    "DatabaseName": "Test",
    "Folder": null,
    "DocString": null
  }
]
`;

exports[`command - storm-events 2`] = `
[
  {
    "ExtentId": "00000000-0000-0000-0000-000000000000",
    "ItemLoaded": "inproc:00000000-0000-0000-0000-000000000000",
    "Duration": 0,
    "HasErrors": false,
    "OperationId": "00000000-0000-0000-0000-000000000000"
  }
]
`;

exports[`command - storm-events 3`] = `
[
  {
    "EventId": 1,
    "State": "WA"
  },
  {
    "EventId": 3,
    "State": "WA"
  }
]
`;

exports[`command - storm-events 4`] = `
[]
`;

exports[`command - tutorial-aggregation 1`] = `
[
  {
    "TableName": "StormEvents",
    "Schema": "{\\"Name\\":\\"StormEvents\\",\\"OrderedColumns\\":[{\\"Name\\":\\"StartTime\\",\\"Type\\":\\"System.DateTime\\",\\"CslType\\":\\"datetime\\"},{\\"Name\\":\\"EndTime\\",\\"Type\\":\\"System.DateTime\\",\\"CslType\\":\\"datetime\\"},{\\"Name\\":\\"EpisodeId\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"EventId\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"State\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"EventType\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"InjuriesDirect\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"InjuriesIndirect\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"DeathsDirect\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"DeathsIndirect\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"DamageProperty\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"DamageCrops\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"Source\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"BeginLocation\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"EndLocation\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"BeginLat\\",\\"Type\\":\\"System.Double\\",\\"CslType\\":\\"real\\"},{\\"Name\\":\\"BeginLon\\",\\"Type\\":\\"System.Double\\",\\"CslType\\":\\"real\\"},{\\"Name\\":\\"EndLat\\",\\"Type\\":\\"System.Double\\",\\"CslType\\":\\"real\\"},{\\"Name\\":\\"EndLon\\",\\"Type\\":\\"System.Double\\",\\"CslType\\":\\"real\\"},{\\"Name\\":\\"EpisodeNarrative\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"EventNarrative\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"StormSummary\\",\\"Type\\":\\"System.Object\\",\\"CslType\\":\\"dynamic\\"}]}",
    "DatabaseName": "Test",
    "Folder": null,
    "DocString": null
  }
]
`;

exports[`command - tutorial-aggregation 10`] = `
[
  {
    "State": "TEXAS",
    "StormTypesWithDeaths": [
      "Ice Storm",
      "Flash Flood",
      "Winter Weather",
      "Tornado",
      "Lightning",
      "Flood",
      "Thunderstorm Wind",
      "Rip Current",
      "Excessive Heat",
      "Hurricane (Typhoon)",
      "Cold/Wind Chill",
      "Dense Fog"
    ]
  },
  {
    "State": "CALIFORNIA",
    "StormTypesWithDeaths": [
      "Strong Wind",
      "Cold/Wind Chill",
      "Thunderstorm Wind",
      "High Surf",
      "Excessive Heat",
      "Rip Current",
      "Heat",
      "Dust Storm",
      "Wildfire",
      "Dense Fog",
      "Winter Weather",
      "Astronomical Low Tide"
    ]
  },
  {
    "State": "OKLAHOMA",
    "StormTypesWithDeaths": [
      "Cold/Wind Chill",
      "Winter Storm",
      "Heavy Snow",
      "Tornado",
      "Heat",
      "Excessive Heat",
      "Flash Flood",
      "Dense Fog",
      "Ice Storm",
      "Winter Weather"
    ]
  },
  {
    "State": "NEW YORK",
    "StormTypesWithDeaths": [
      "Winter Weather",
      "Ice Storm",
      "Extreme Cold/Wind Chill",
      "Winter Storm",
      "Flood",
      "Thunderstorm Wind",
      "Flash Flood",
      "Lightning",
      "Heavy Snow"
    ]
  },
  {
    "State": "KANSAS",
    "StormTypesWithDeaths": [
      "Heavy Snow",
      "Winter Weather",
      "Blizzard",
      "Heavy Rain",
      "Tornado",
      "Flash Flood",
      "Flood",
      "Lightning",
      "Thunderstorm Wind"
    ]
  },
  {
    "State": "ILLINOIS",
    "StormTypesWithDeaths": [
      "Ice Storm",
      "Extreme Cold/Wind Chill",
      "Winter Weather",
      "Winter Storm",
      "Blizzard",
      "Lightning",
      "Excessive Heat",
      "Thunderstorm Wind",
      "Heavy Snow"
    ]
  },
  {
    "State": "WASHINGTON",
    "StormTypesWithDeaths": [
      "Strong Wind",
      "Winter Weather",
      "Avalanche",
      "Rip Current",
      "High Wind",
      "Flood",
      "Debris Flow"
    ]
  },
  {
    "State": "NEW JERSEY",
    "StormTypesWithDeaths": [
      "Winter Weather",
      "Extreme Cold/Wind Chill",
      "Winter Storm",
      "Flood",
      "Heavy Rain",
      "Rip Current",
      "Lightning"
    ]
  },
  {
    "State": "MISSOURI",
    "StormTypesWithDeaths": [
      "Winter Storm",
      "Flood",
      "Tornado",
      "Lightning",
      "Flash Flood",
      "Excessive Heat",
      "Heat"
    ]
  },
  {
    "State": "MICHIGAN",
    "StormTypesWithDeaths": [
      "Cold/Wind Chill",
      "Winter Storm",
      "Winter Weather",
      "Strong Wind",
      "Lightning",
      "Rip Current",
      "Tornado"
    ]
  },
  {
    "State": "SOUTH CAROLINA",
    "StormTypesWithDeaths": [
      "Tornado",
      "High Wind",
      "High Surf",
      "Rip Current",
      "Lightning",
      "Excessive Heat"
    ]
  },
  {
    "State": "PENNSYLVANIA",
    "StormTypesWithDeaths": [
      "Extreme Cold/Wind Chill",
      "Winter Storm",
      "Lightning",
      "Excessive Heat",
      "Heat",
      "Strong Wind"
    ]
  },
  {
    "State": "ARKANSAS",
    "StormTypesWithDeaths": [
      "Heavy Rain",
      "Winter Weather",
      "Strong Wind",
      "Thunderstorm Wind",
      "Heat",
      "Lightning"
    ]
  },
  {
    "State": "WISCONSIN",
    "StormTypesWithDeaths": [
      "Cold/Wind Chill",
      "Winter Weather",
      "Winter Storm",
      "Flash Flood",
      "Lightning"
    ]
  },
  {
    "State": "NEVADA",
    "StormTypesWithDeaths": [
      "Ice Storm",
      "Cold/Wind Chill",
      "Strong Wind",
      "Excessive Heat",
      "Heat"
    ]
  },
  {
    "State": "MINNESOTA",
    "StormTypesWithDeaths": [
      "Lightning",
      "Heavy Rain",
      "Flash Flood",
      "Extreme Cold/Wind Chill",
      "Winter Weather"
    ]
  },
  {
    "State": "GEORGIA",
    "StormTypesWithDeaths": [
      "Tornado",
      "Lightning",
      "Thunderstorm Wind",
      "Excessive Heat",
      "Dense Fog"
    ]
  },
  {
    "State": "FLORIDA",
    "StormTypesWithDeaths": [
      "Rip Current",
      "Tornado",
      "Dense Fog",
      "High Surf",
      "Lightning"
    ]
  },
  {
    "State": "ARIZONA",
    "StormTypesWithDeaths": [
      "Heat",
      "Lightning",
      "Flash Flood",
      "Heavy Rain",
      "Heavy Snow"
    ]
  },
  {
    "State": "ALABAMA",
    "StormTypesWithDeaths": [
      "Tornado",
      "Rip Current",
      "Heavy Rain",
      "Lightning",
      "Heat"
    ]
  },
  {
    "State": "NORTH CAROLINA",
    "StormTypesWithDeaths": [
      "Winter Weather",
      "High Wind",
      "Rip Current",
      "Heat"
    ]
  },
  {
    "State": "LOUISIANA",
    "StormTypesWithDeaths": [
      "Tornado",
      "Dense Fog",
      "Thunderstorm Wind",
      "Lightning"
    ]
  },
  {
    "State": "KENTUCKY",
    "StormTypesWithDeaths": [
      "Strong Wind",
      "Lightning",
      "Heat",
      "Thunderstorm Wind"
    ]
  },
  {
    "State": "IOWA",
    "StormTypesWithDeaths": [
      "Winter Storm",
      "Winter Weather",
      "Flood",
      "Ice Storm"
    ]
  },
  {
    "State": "INDIANA",
    "StormTypesWithDeaths": [
      "Flood",
      "Winter Storm",
      "Ice Storm",
      "Thunderstorm Wind"
    ]
  },
  {
    "State": "COLORADO",
    "StormTypesWithDeaths": [
      "Avalanche",
      "Tornado",
      "Heavy Rain",
      "Lightning"
    ]
  },
  {
    "State": "VIRGINIA",
    "StormTypesWithDeaths": [
      "Strong Wind",
      "Cold/Wind Chill",
      "Lightning"
    ]
  },
  {
    "State": "UTAH",
    "StormTypesWithDeaths": [
      "Avalanche",
      "Wildfire",
      "Lightning"
    ]
  },
  {
    "State": "TENNESSEE",
    "StormTypesWithDeaths": [
      "Lightning",
      "Excessive Heat",
      "Heat"
    ]
  },
  {
    "State": "OREGON",
    "StormTypesWithDeaths": [
      "Heavy Snow",
      "High Surf",
      "Rip Current"
    ]
  },
  {
    "State": "OHIO",
    "StormTypesWithDeaths": [
      "Ice Storm",
      "Lightning",
      "Thunderstorm Wind"
    ]
  },
  {
    "State": "NORTH DAKOTA",
    "StormTypesWithDeaths": [
      "Winter Storm",
      "Blizzard",
      "Tornado"
    ]
  },
  {
    "State": "MARYLAND",
    "StormTypesWithDeaths": [
      "Extreme Cold/Wind Chill",
      "Lightning",
      "Freezing Fog"
    ]
  },
  {
    "State": "DELAWARE",
    "StormTypesWithDeaths": [
      "Cold/Wind Chill",
      "Extreme Cold/Wind Chill",
      "Winter Storm"
    ]
  },
  {
    "State": "NEW MEXICO",
    "StormTypesWithDeaths": [
      "Tornado",
      "Heavy Snow"
    ]
  },
  {
    "State": "NEW HAMPSHIRE",
    "StormTypesWithDeaths": [
      "Heavy Snow",
      "Winter Weather"
    ]
  },
  {
    "State": "MISSISSIPPI",
    "StormTypesWithDeaths": [
      "Heat",
      "Excessive Heat"
    ]
  },
  {
    "State": "MAINE",
    "StormTypesWithDeaths": [
      "Flood",
      "Lightning"
    ]
  },
  {
    "State": "WYOMING",
    "StormTypesWithDeaths": [
      "Avalanche"
    ]
  },
  {
    "State": "WEST VIRGINIA",
    "StormTypesWithDeaths": [
      "Flood"
    ]
  },
  {
    "State": "SOUTH DAKOTA",
    "StormTypesWithDeaths": [
      "Winter Storm"
    ]
  },
  {
    "State": "PUERTO RICO",
    "StormTypesWithDeaths": [
      "Debris Flow"
    ]
  },
  {
    "State": "NEBRASKA",
    "StormTypesWithDeaths": [
      "Winter Weather"
    ]
  },
  {
    "State": "MONTANA",
    "StormTypesWithDeaths": [
      "Lightning"
    ]
  },
  {
    "State": "MASSACHUSETTS",
    "StormTypesWithDeaths": [
      "Extreme Cold/Wind Chill"
    ]
  },
  {
    "State": "LAKE MICHIGAN",
    "StormTypesWithDeaths": [
      "Marine Strong Wind"
    ]
  },
  {
    "State": "IDAHO",
    "StormTypesWithDeaths": [
      "Avalanche"
    ]
  },
  {
    "State": "GUAM",
    "StormTypesWithDeaths": [
      "Rip Current"
    ]
  },
  {
    "State": "E PACIFIC",
    "StormTypesWithDeaths": [
      "Marine Strong Wind"
    ]
  },
  {
    "State": "ATLANTIC SOUTH",
    "StormTypesWithDeaths": [
      "Marine Thunderstorm Wind"
    ]
  },
  {
    "State": "ATLANTIC NORTH",
    "StormTypesWithDeaths": [
      "Marine Strong Wind"
    ]
  },
  {
    "State": "AMERICAN SAMOA",
    "StormTypesWithDeaths": [
      "Rip Current"
    ]
  }
]
`;

exports[`command - tutorial-aggregation 11`] = `
[
  {
    "State": "ALABAMA",
    "InjuriesCount": 494,
    "InjuriesBucket": "Large"
  },
  {
    "State": "ALASKA",
    "InjuriesCount": 0,
    "InjuriesBucket": "No injuries"
  },
  {
    "State": "AMERICAN SAMOA",
    "InjuriesCount": 0,
    "InjuriesBucket": "No injuries"
  },
  {
    "State": "ARIZONA",
    "InjuriesCount": 6,
    "InjuriesBucket": "Small"
  },
  {
    "State": "ARKANSAS",
    "InjuriesCount": 54,
    "InjuriesBucket": "Large"
  },
  {
    "State": "ATLANTIC NORTH",
    "InjuriesCount": 15,
    "InjuriesBucket": "Medium"
  },
  {
    "State": "ATLANTIC SOUTH",
    "InjuriesCount": 2,
    "InjuriesBucket": "Small"
  },
  {
    "State": "CALIFORNIA",
    "InjuriesCount": 221,
    "InjuriesBucket": "Large"
  },
  {
    "State": "COLORADO",
    "InjuriesCount": 22,
    "InjuriesBucket": "Medium"
  },
  {
    "State": "CONNECTICUT",
    "InjuriesCount": 1,
    "InjuriesBucket": "Small"
  },
  {
    "State": "DELAWARE",
    "InjuriesCount": 4,
    "InjuriesBucket": "Small"
  },
  {
    "State": "DISTRICT OF COLUMBIA",
    "InjuriesCount": 0,
    "InjuriesBucket": "No injuries"
  },
  {
    "State": "E PACIFIC",
    "InjuriesCount": 0,
    "InjuriesBucket": "No injuries"
  },
  {
    "State": "FLORIDA",
    "InjuriesCount": 174,
    "InjuriesBucket": "Large"
  },
  {
    "State": "GEORGIA",
    "InjuriesCount": 63,
    "InjuriesBucket": "Large"
  },
  {
    "State": "GUAM",
    "InjuriesCount": 0,
    "InjuriesBucket": "No injuries"
  },
  {
    "State": "GULF OF ALASKA",
    "InjuriesCount": 0,
    "InjuriesBucket": "No injuries"
  },
  {
    "State": "GULF OF MEXICO",
    "InjuriesCount": 0,
    "InjuriesBucket": "No injuries"
  },
  {
    "State": "HAWAII",
    "InjuriesCount": 5,
    "InjuriesBucket": "Small"
  },
  {
    "State": "HAWAII WATERS",
    "InjuriesCount": 0,
    "InjuriesBucket": "No injuries"
  },
  {
    "State": "IDAHO",
    "InjuriesCount": 6,
    "InjuriesBucket": "Small"
  },
  {
    "State": "ILLINOIS",
    "InjuriesCount": 126,
    "InjuriesBucket": "Large"
  },
  {
    "State": "INDIANA",
    "InjuriesCount": 4,
    "InjuriesBucket": "Small"
  },
  {
    "State": "IOWA",
    "InjuriesCount": 15,
    "InjuriesBucket": "Medium"
  },
  {
    "State": "KANSAS",
    "InjuriesCount": 96,
    "InjuriesBucket": "Large"
  },
  {
    "State": "KENTUCKY",
    "InjuriesCount": 80,
    "InjuriesBucket": "Large"
  },
  {
    "State": "LAKE ERIE",
    "InjuriesCount": 0,
    "InjuriesBucket": "No injuries"
  },
  {
    "State": "LAKE HURON",
    "InjuriesCount": 0,
    "InjuriesBucket": "No injuries"
  },
  {
    "State": "LAKE MICHIGAN",
    "InjuriesCount": 0,
    "InjuriesBucket": "No injuries"
  },
  {
    "State": "LAKE ONTARIO",
    "InjuriesCount": 0,
    "InjuriesBucket": "No injuries"
  },
  {
    "State": "LAKE ST CLAIR",
    "InjuriesCount": 0,
    "InjuriesBucket": "No injuries"
  },
  {
    "State": "LAKE SUPERIOR",
    "InjuriesCount": 0,
    "InjuriesBucket": "No injuries"
  },
  {
    "State": "LOUISIANA",
    "InjuriesCount": 60,
    "InjuriesBucket": "Large"
  },
  {
    "State": "MAINE",
    "InjuriesCount": 7,
    "InjuriesBucket": "Small"
  },
  {
    "State": "MARYLAND",
    "InjuriesCount": 5,
    "InjuriesBucket": "Small"
  },
  {
    "State": "MASSACHUSETTS",
    "InjuriesCount": 6,
    "InjuriesBucket": "Small"
  },
  {
    "State": "MICHIGAN",
    "InjuriesCount": 185,
    "InjuriesBucket": "Large"
  },
  {
    "State": "MINNESOTA",
    "InjuriesCount": 58,
    "InjuriesBucket": "Large"
  },
  {
    "State": "MISSISSIPPI",
    "InjuriesCount": 21,
    "InjuriesBucket": "Medium"
  },
  {
    "State": "MISSOURI",
    "InjuriesCount": 980,
    "InjuriesBucket": "Large"
  },
  {
    "State": "MONTANA",
    "InjuriesCount": 8,
    "InjuriesBucket": "Small"
  },
  {
    "State": "NEBRASKA",
    "InjuriesCount": 15,
    "InjuriesBucket": "Medium"
  },
  {
    "State": "NEVADA",
    "InjuriesCount": 5,
    "InjuriesBucket": "Small"
  },
  {
    "State": "NEW HAMPSHIRE",
    "InjuriesCount": 3,
    "InjuriesBucket": "Small"
  },
  {
    "State": "NEW JERSEY",
    "InjuriesCount": 14,
    "InjuriesBucket": "Medium"
  },
  {
    "State": "NEW MEXICO",
    "InjuriesCount": 45,
    "InjuriesBucket": "Medium"
  },
  {
    "State": "NEW YORK",
    "InjuriesCount": 27,
    "InjuriesBucket": "Medium"
  },
  {
    "State": "NORTH CAROLINA",
    "InjuriesCount": 20,
    "InjuriesBucket": "Medium"
  },
  {
    "State": "NORTH DAKOTA",
    "InjuriesCount": 23,
    "InjuriesBucket": "Medium"
  },
  {
    "State": "OHIO",
    "InjuriesCount": 4,
    "InjuriesBucket": "Small"
  },
  {
    "State": "OKLAHOMA",
    "InjuriesCount": 275,
    "InjuriesBucket": "Large"
  },
  {
    "State": "OREGON",
    "InjuriesCount": 4,
    "InjuriesBucket": "Small"
  },
  {
    "State": "PENNSYLVANIA",
    "InjuriesCount": 17,
    "InjuriesBucket": "Medium"
  },
  {
    "State": "PUERTO RICO",
    "InjuriesCount": 5,
    "InjuriesBucket": "Small"
  },
  {
    "State": "RHODE ISLAND",
    "InjuriesCount": 0,
    "InjuriesBucket": "No injuries"
  },
  {
    "State": "SOUTH CAROLINA",
    "InjuriesCount": 40,
    "InjuriesBucket": "Medium"
  },
  {
    "State": "SOUTH DAKOTA",
    "InjuriesCount": 1,
    "InjuriesBucket": "Small"
  },
  {
    "State": "TENNESSEE",
    "InjuriesCount": 211,
    "InjuriesBucket": "Large"
  },
  {
    "State": "TEXAS",
    "InjuriesCount": 264,
    "InjuriesBucket": "Large"
  },
  {
    "State": "UTAH",
    "InjuriesCount": 7,
    "InjuriesBucket": "Small"
  },
  {
    "State": "VERMONT",
    "InjuriesCount": 0,
    "InjuriesBucket": "No injuries"
  },
  {
    "State": "VIRGIN ISLANDS",
    "InjuriesCount": 0,
    "InjuriesBucket": "No injuries"
  },
  {
    "State": "VIRGINIA",
    "InjuriesCount": 4,
    "InjuriesBucket": "Small"
  },
  {
    "State": "WASHINGTON",
    "InjuriesCount": 19,
    "InjuriesBucket": "Medium"
  },
  {
    "State": "WEST VIRGINIA",
    "InjuriesCount": 1,
    "InjuriesBucket": "Small"
  },
  {
    "State": "WISCONSIN",
    "InjuriesCount": 6,
    "InjuriesBucket": "Small"
  },
  {
    "State": "WYOMING",
    "InjuriesCount": 9,
    "InjuriesBucket": "Small"
  }
]
`;

exports[`command - tutorial-aggregation 12`] = `
[
  {
    "InjuriesBucket": "Medium",
    "InjuryBucketByState": 13
  },
  {
    "InjuriesBucket": "Small",
    "InjuryBucketByState": 22
  },
  {
    "InjuriesBucket": "No injuries",
    "InjuryBucketByState": 17
  },
  {
    "InjuriesBucket": "Large",
    "InjuryBucketByState": 15
  }
]
`;

exports[`command - tutorial-aggregation 13`] = `
[
  {
    "Timestamp": "2007-07-08T00:00:00.000Z",
    "EventType": "Flood",
    "min_DamageProperty": 0,
    "max_DamageProperty": 200000,
    "avg_DamageProperty": 9261
  },
  {
    "Timestamp": "2007-07-08T00:00:00.000Z",
    "EventType": "Wildfire",
    "min_DamageProperty": 0,
    "max_DamageProperty": 200000,
    "avg_DamageProperty": 14033
  },
  {
    "Timestamp": "2007-07-08T00:00:00.000Z",
    "EventType": "Tornado",
    "min_DamageProperty": 0,
    "max_DamageProperty": 30000,
    "avg_DamageProperty": 6905
  },
  {
    "Timestamp": "2007-07-09T00:00:00.000Z",
    "EventType": "Tornado",
    "min_DamageProperty": 0,
    "max_DamageProperty": 100000,
    "avg_DamageProperty": 14783
  },
  {
    "Timestamp": "2007-07-09T00:00:00.000Z",
    "EventType": "Wildfire",
    "min_DamageProperty": 0,
    "max_DamageProperty": 200000,
    "avg_DamageProperty": 14033
  },
  {
    "Timestamp": "2007-07-10T00:00:00.000Z",
    "EventType": "Wildfire",
    "min_DamageProperty": 0,
    "max_DamageProperty": 200000,
    "avg_DamageProperty": 11694
  },
  {
    "Timestamp": "2007-07-09T00:00:00.000Z",
    "EventType": "Flood",
    "min_DamageProperty": 0,
    "max_DamageProperty": 200000,
    "avg_DamageProperty": 12529
  },
  {
    "Timestamp": "2007-07-10T00:00:00.000Z",
    "EventType": "Flood",
    "min_DamageProperty": 0,
    "max_DamageProperty": 200000,
    "avg_DamageProperty": 12263
  },
  {
    "Timestamp": "2007-07-11T00:00:00.000Z",
    "EventType": "Flood",
    "min_DamageProperty": 0,
    "max_DamageProperty": 200000,
    "avg_DamageProperty": 13118
  },
  {
    "Timestamp": "2007-07-10T00:00:00.000Z",
    "EventType": "Tornado",
    "min_DamageProperty": 0,
    "max_DamageProperty": 100000,
    "avg_DamageProperty": 31400
  },
  {
    "Timestamp": "2007-07-11T00:00:00.000Z",
    "EventType": "Tornado",
    "min_DamageProperty": 0,
    "max_DamageProperty": 250000,
    "avg_DamageProperty": 44192
  },
  {
    "Timestamp": "2007-07-11T00:00:00.000Z",
    "EventType": "Wildfire",
    "min_DamageProperty": 0,
    "max_DamageProperty": 200000,
    "avg_DamageProperty": 14033
  },
  {
    "Timestamp": "2007-07-12T00:00:00.000Z",
    "EventType": "Wildfire",
    "min_DamageProperty": 0,
    "max_DamageProperty": 200000,
    "avg_DamageProperty": 12382
  },
  {
    "Timestamp": "2007-07-12T00:00:00.000Z",
    "EventType": "Flood",
    "min_DamageProperty": 0,
    "max_DamageProperty": 200000,
    "avg_DamageProperty": 26667
  },
  {
    "Timestamp": "2007-07-12T00:00:00.000Z",
    "EventType": "Tornado",
    "min_DamageProperty": 0,
    "max_DamageProperty": 250000,
    "avg_DamageProperty": 38893
  },
  {
    "Timestamp": "2007-07-13T00:00:00.000Z",
    "EventType": "Wildfire",
    "min_DamageProperty": 0,
    "max_DamageProperty": 200000,
    "avg_DamageProperty": 7426
  },
  {
    "Timestamp": "2007-07-13T00:00:00.000Z",
    "EventType": "Tornado",
    "min_DamageProperty": 0,
    "max_DamageProperty": 250000,
    "avg_DamageProperty": 40731
  },
  {
    "Timestamp": "2007-07-13T00:00:00.000Z",
    "EventType": "Flood",
    "min_DamageProperty": 0,
    "max_DamageProperty": 100000,
    "avg_DamageProperty": 6944
  },
  {
    "Timestamp": "2007-07-14T00:00:00.000Z",
    "EventType": "Flood",
    "min_DamageProperty": 0,
    "max_DamageProperty": 100000,
    "avg_DamageProperty": 7813
  },
  {
    "Timestamp": "2007-07-14T00:00:00.000Z",
    "EventType": "Wildfire",
    "min_DamageProperty": 0,
    "max_DamageProperty": 200000,
    "avg_DamageProperty": 7143
  },
  {
    "Timestamp": "2007-07-14T00:00:00.000Z",
    "EventType": "Tornado",
    "min_DamageProperty": 0,
    "max_DamageProperty": 250000,
    "avg_DamageProperty": 38292
  }
]
`;

exports[`command - tutorial-aggregation 14`] = `
[]
`;

exports[`command - tutorial-aggregation 2`] = `
[
  {
    "ExtentId": "00000000-0000-0000-0000-000000000000",
    "ItemLoaded": "inproc:00000000-0000-0000-0000-000000000000",
    "Duration": 0,
    "HasErrors": false,
    "OperationId": "00000000-0000-0000-0000-000000000000"
  }
]
`;

exports[`command - tutorial-aggregation 3`] = `
[
  {
    "State": "NORTH CAROLINA",
    "TotalStorms": 1721
  },
  {
    "State": "WISCONSIN",
    "TotalStorms": 1850
  },
  {
    "State": "NEW YORK",
    "TotalStorms": 1750
  },
  {
    "State": "ALASKA",
    "TotalStorms": 257
  },
  {
    "State": "DELAWARE",
    "TotalStorms": 200
  },
  {
    "State": "OKLAHOMA",
    "TotalStorms": 1716
  },
  {
    "State": "INDIANA",
    "TotalStorms": 1164
  },
  {
    "State": "ILLINOIS",
    "TotalStorms": 2022
  },
  {
    "State": "MINNESOTA",
    "TotalStorms": 1881
  },
  {
    "State": "TEXAS",
    "TotalStorms": 4701
  },
  {
    "State": "SOUTH DAKOTA",
    "TotalStorms": 1567
  },
  {
    "State": "UTAH",
    "TotalStorms": 360
  },
  {
    "State": "COLORADO",
    "TotalStorms": 1654
  },
  {
    "State": "VERMONT",
    "TotalStorms": 600
  },
  {
    "State": "NEW JERSEY",
    "TotalStorms": 1044
  },
  {
    "State": "VIRGINIA",
    "TotalStorms": 1647
  },
  {
    "State": "CALIFORNIA",
    "TotalStorms": 898
  },
  {
    "State": "PENNSYLVANIA",
    "TotalStorms": 1687
  },
  {
    "State": "MONTANA",
    "TotalStorms": 1230
  },
  {
    "State": "WASHINGTON",
    "TotalStorms": 261
  },
  {
    "State": "OREGON",
    "TotalStorms": 423
  },
  {
    "State": "HAWAII",
    "TotalStorms": 457
  },
  {
    "State": "IDAHO",
    "TotalStorms": 247
  },
  {
    "State": "PUERTO RICO",
    "TotalStorms": 192
  },
  {
    "State": "MICHIGAN",
    "TotalStorms": 1637
  },
  {
    "State": "FLORIDA",
    "TotalStorms": 1042
  },
  {
    "State": "WYOMING",
    "TotalStorms": 396
  },
  {
    "State": "GULF OF MEXICO",
    "TotalStorms": 577
  },
  {
    "State": "NEVADA",
    "TotalStorms": 163
  },
  {
    "State": "LOUISIANA",
    "TotalStorms": 463
  },
  {
    "State": "TENNESSEE",
    "TotalStorms": 1125
  },
  {
    "State": "KENTUCKY",
    "TotalStorms": 1391
  },
  {
    "State": "MISSISSIPPI",
    "TotalStorms": 1218
  },
  {
    "State": "ALABAMA",
    "TotalStorms": 1315
  },
  {
    "State": "GEORGIA",
    "TotalStorms": 1983
  },
  {
    "State": "SOUTH CAROLINA",
    "TotalStorms": 915
  },
  {
    "State": "OHIO",
    "TotalStorms": 1233
  },
  {
    "State": "NEW MEXICO",
    "TotalStorms": 527
  },
  {
    "State": "ATLANTIC SOUTH",
    "TotalStorms": 193
  },
  {
    "State": "NEW HAMPSHIRE",
    "TotalStorms": 394
  },
  {
    "State": "ATLANTIC NORTH",
    "TotalStorms": 188
  },
  {
    "State": "NORTH DAKOTA",
    "TotalStorms": 905
  },
  {
    "State": "IOWA",
    "TotalStorms": 2337
  },
  {
    "State": "NEBRASKA",
    "TotalStorms": 1766
  },
  {
    "State": "WEST VIRGINIA",
    "TotalStorms": 757
  },
  {
    "State": "MARYLAND",
    "TotalStorms": 673
  },
  {
    "State": "KANSAS",
    "TotalStorms": 3166
  },
  {
    "State": "MISSOURI",
    "TotalStorms": 2016
  },
  {
    "State": "ARKANSAS",
    "TotalStorms": 1028
  },
  {
    "State": "ARIZONA",
    "TotalStorms": 340
  },
  {
    "State": "MASSACHUSETTS",
    "TotalStorms": 416
  },
  {
    "State": "MAINE",
    "TotalStorms": 758
  },
  {
    "State": "CONNECTICUT",
    "TotalStorms": 148
  },
  {
    "State": "GUAM",
    "TotalStorms": 4
  },
  {
    "State": "HAWAII WATERS",
    "TotalStorms": 2
  },
  {
    "State": "AMERICAN SAMOA",
    "TotalStorms": 16
  },
  {
    "State": "LAKE HURON",
    "TotalStorms": 63
  },
  {
    "State": "DISTRICT OF COLUMBIA",
    "TotalStorms": 22
  },
  {
    "State": "RHODE ISLAND",
    "TotalStorms": 51
  },
  {
    "State": "VIRGIN ISLANDS",
    "TotalStorms": 12
  },
  {
    "State": "LAKE MICHIGAN",
    "TotalStorms": 182
  },
  {
    "State": "LAKE SUPERIOR",
    "TotalStorms": 34
  },
  {
    "State": "LAKE ST CLAIR",
    "TotalStorms": 32
  },
  {
    "State": "LAKE ERIE",
    "TotalStorms": 27
  },
  {
    "State": "LAKE ONTARIO",
    "TotalStorms": 8
  },
  {
    "State": "E PACIFIC",
    "TotalStorms": 10
  },
  {
    "State": "GULF OF ALASKA",
    "TotalStorms": 4
  }
]
`;

exports[`command - tutorial-aggregation 4`] = `
[
  {
    "State": "IOWA",
    "StormsWithCropDamage": 359
  },
  {
    "State": "NEBRASKA",
    "StormsWithCropDamage": 201
  },
  {
    "State": "MISSISSIPPI",
    "StormsWithCropDamage": 105
  },
  {
    "State": "NORTH CAROLINA",
    "StormsWithCropDamage": 82
  },
  {
    "State": "MISSOURI",
    "StormsWithCropDamage": 78
  }
]
`;

exports[`command - tutorial-aggregation 5`] = `
[
  {
    "StartTime": "2007-01-01T00:00:00.000Z",
    "EventCount": 16
  },
  {
    "StartTime": "2007-01-08T00:00:00.000Z",
    "EventCount": 20
  },
  {
    "StartTime": "2007-01-29T00:00:00.000Z",
    "EventCount": 8
  },
  {
    "StartTime": "2007-02-05T00:00:00.000Z",
    "EventCount": 1
  },
  {
    "StartTime": "2007-02-12T00:00:00.000Z",
    "EventCount": 3
  },
  {
    "StartTime": "2007-02-19T00:00:00.000Z",
    "EventCount": 4
  },
  {
    "StartTime": "2007-02-26T00:00:00.000Z",
    "EventCount": 3
  },
  {
    "StartTime": "2007-03-05T00:00:00.000Z",
    "EventCount": 1
  },
  {
    "StartTime": "2007-03-19T00:00:00.000Z",
    "EventCount": 2
  },
  {
    "StartTime": "2007-03-26T00:00:00.000Z",
    "EventCount": 2
  },
  {
    "StartTime": "2007-04-02T00:00:00.000Z",
    "EventCount": 216
  },
  {
    "StartTime": "2007-04-09T00:00:00.000Z",
    "EventCount": 17
  },
  {
    "StartTime": "2007-04-16T00:00:00.000Z",
    "EventCount": 45
  },
  {
    "StartTime": "2007-04-23T00:00:00.000Z",
    "EventCount": 11
  },
  {
    "StartTime": "2007-04-30T00:00:00.000Z",
    "EventCount": 91
  },
  {
    "StartTime": "2007-05-07T00:00:00.000Z",
    "EventCount": 18
  },
  {
    "StartTime": "2007-05-14T00:00:00.000Z",
    "EventCount": 22
  },
  {
    "StartTime": "2007-05-21T00:00:00.000Z",
    "EventCount": 33
  },
  {
    "StartTime": "2007-05-28T00:00:00.000Z",
    "EventCount": 107
  },
  {
    "StartTime": "2007-06-04T00:00:00.000Z",
    "EventCount": 17
  },
  {
    "StartTime": "2007-06-11T00:00:00.000Z",
    "EventCount": 28
  },
  {
    "StartTime": "2007-06-18T00:00:00.000Z",
    "EventCount": 118
  },
  {
    "StartTime": "2007-06-25T00:00:00.000Z",
    "EventCount": 30
  },
  {
    "StartTime": "2007-07-02T00:00:00.000Z",
    "EventCount": 21
  },
  {
    "StartTime": "2007-07-09T00:00:00.000Z",
    "EventCount": 59
  },
  {
    "StartTime": "2007-07-16T00:00:00.000Z",
    "EventCount": 75
  },
  {
    "StartTime": "2007-07-23T00:00:00.000Z",
    "EventCount": 17
  },
  {
    "StartTime": "2007-07-30T00:00:00.000Z",
    "EventCount": 11
  },
  {
    "StartTime": "2007-08-06T00:00:00.000Z",
    "EventCount": 42
  },
  {
    "StartTime": "2007-08-13T00:00:00.000Z",
    "EventCount": 93
  },
  {
    "StartTime": "2007-08-20T00:00:00.000Z",
    "EventCount": 135
  },
  {
    "StartTime": "2007-08-27T00:00:00.000Z",
    "EventCount": 90
  },
  {
    "StartTime": "2007-09-03T00:00:00.000Z",
    "EventCount": 9
  },
  {
    "StartTime": "2007-09-17T00:00:00.000Z",
    "EventCount": 13
  },
  {
    "StartTime": "2007-09-24T00:00:00.000Z",
    "EventCount": 27
  },
  {
    "StartTime": "2007-10-01T00:00:00.000Z",
    "EventCount": 12
  },
  {
    "StartTime": "2007-10-08T00:00:00.000Z",
    "EventCount": 15
  },
  {
    "StartTime": "2007-10-15T00:00:00.000Z",
    "EventCount": 33
  },
  {
    "StartTime": "2007-10-22T00:00:00.000Z",
    "EventCount": 3
  },
  {
    "StartTime": "2007-11-26T00:00:00.000Z",
    "EventCount": 4
  },
  {
    "StartTime": "2007-12-03T00:00:00.000Z",
    "EventCount": 5
  },
  {
    "StartTime": "2007-12-10T00:00:00.000Z",
    "EventCount": 5
  },
  {
    "StartTime": "2007-12-17T00:00:00.000Z",
    "EventCount": 5
  },
  {
    "StartTime": "2007-12-24T00:00:00.000Z",
    "EventCount": 4
  }
]
`;

exports[`command - tutorial-aggregation 6`] = `
[
  {
    "EventType": "Frost/Freeze",
    "MaxCropDamage": 568600000,
    "MinCropDamage": 3000,
    "AvgCropDamage": 9106087.595419846
  },
  {
    "EventType": "Wildfire",
    "MaxCropDamage": 21000000,
    "MinCropDamage": 10000,
    "AvgCropDamage": 7268333.333333333
  },
  {
    "EventType": "Drought",
    "MaxCropDamage": 700000000,
    "MinCropDamage": 2000,
    "AvgCropDamage": 6763977.876106195
  },
  {
    "EventType": "Flood",
    "MaxCropDamage": 500000000,
    "MinCropDamage": 1000,
    "AvgCropDamage": 4844925.23364486
  },
  {
    "EventType": "Thunderstorm Wind",
    "MaxCropDamage": 22000000,
    "MinCropDamage": 100,
    "AvgCropDamage": 920328.3653846154
  },
  {
    "EventType": "Hail",
    "MaxCropDamage": 24000000,
    "MinCropDamage": 100,
    "AvgCropDamage": 416890.56603773584
  },
  {
    "EventType": "Flash Flood",
    "MaxCropDamage": 5000000,
    "MinCropDamage": 300,
    "AvgCropDamage": 266778.60962566844
  },
  {
    "EventType": "High Wind",
    "MaxCropDamage": 1000000,
    "MinCropDamage": 1000,
    "AvgCropDamage": 209800
  },
  {
    "EventType": "Cold/Wind Chill",
    "MaxCropDamage": 500000,
    "MinCropDamage": 100000,
    "AvgCropDamage": 200000
  },
  {
    "EventType": "Heavy Rain",
    "MaxCropDamage": 1150000,
    "MinCropDamage": 5000,
    "AvgCropDamage": 171000
  },
  {
    "EventType": "Tornado",
    "MaxCropDamage": 2000000,
    "MinCropDamage": 500,
    "AvgCropDamage": 118684.21052631579
  },
  {
    "EventType": "Winter Storm",
    "MaxCropDamage": 50000,
    "MinCropDamage": 20000,
    "AvgCropDamage": 32571.428571428572
  },
  {
    "EventType": "Lightning",
    "MaxCropDamage": 50000,
    "MinCropDamage": 1000,
    "AvgCropDamage": 15500
  },
  {
    "EventType": "Strong Wind",
    "MaxCropDamage": 10000,
    "MinCropDamage": 2000,
    "AvgCropDamage": 5147.058823529412
  },
  {
    "EventType": "Tropical Storm",
    "MaxCropDamage": 5000,
    "MinCropDamage": 5000,
    "AvgCropDamage": 5000
  }
]
`;

exports[`command - tutorial-aggregation 7`] = `
[
  {
    "StartTime": "2007-01-01T00:00:00.000Z",
    "CropDamage": 24738000
  },
  {
    "StartTime": "2007-01-08T00:00:00.000Z",
    "CropDamage": 1286670000
  },
  {
    "StartTime": "2007-01-29T00:00:00.000Z",
    "CropDamage": 682000
  },
  {
    "StartTime": "2007-02-05T00:00:00.000Z",
    "CropDamage": 1000
  },
  {
    "StartTime": "2007-02-12T00:00:00.000Z",
    "CropDamage": 50065000
  },
  {
    "StartTime": "2007-02-19T00:00:00.000Z",
    "CropDamage": 470000
  },
  {
    "StartTime": "2007-02-26T00:00:00.000Z",
    "CropDamage": 1450000
  },
  {
    "StartTime": "2007-03-05T00:00:00.000Z",
    "CropDamage": 500000
  },
  {
    "StartTime": "2007-03-19T00:00:00.000Z",
    "CropDamage": 253000
  },
  {
    "StartTime": "2007-03-26T00:00:00.000Z",
    "CropDamage": 50000
  },
  {
    "StartTime": "2007-04-02T00:00:00.000Z",
    "CropDamage": 1015813950
  },
  {
    "StartTime": "2007-04-09T00:00:00.000Z",
    "CropDamage": 10639000
  },
  {
    "StartTime": "2007-04-16T00:00:00.000Z",
    "CropDamage": 1555000
  },
  {
    "StartTime": "2007-04-23T00:00:00.000Z",
    "CropDamage": 810000
  },
  {
    "StartTime": "2007-04-30T00:00:00.000Z",
    "CropDamage": 36041000
  },
  {
    "StartTime": "2007-05-07T00:00:00.000Z",
    "CropDamage": 2380000
  },
  {
    "StartTime": "2007-05-14T00:00:00.000Z",
    "CropDamage": 907500
  },
  {
    "StartTime": "2007-05-21T00:00:00.000Z",
    "CropDamage": 1805000
  },
  {
    "StartTime": "2007-05-28T00:00:00.000Z",
    "CropDamage": 764362000
  },
  {
    "StartTime": "2007-06-04T00:00:00.000Z",
    "CropDamage": 957600
  },
  {
    "StartTime": "2007-06-11T00:00:00.000Z",
    "CropDamage": 30494000
  },
  {
    "StartTime": "2007-06-18T00:00:00.000Z",
    "CropDamage": 4895500
  },
  {
    "StartTime": "2007-06-25T00:00:00.000Z",
    "CropDamage": 508618000
  },
  {
    "StartTime": "2007-07-02T00:00:00.000Z",
    "CropDamage": 1436000
  },
  {
    "StartTime": "2007-07-09T00:00:00.000Z",
    "CropDamage": 232195000
  },
  {
    "StartTime": "2007-07-16T00:00:00.000Z",
    "CropDamage": 1411100
  },
  {
    "StartTime": "2007-07-23T00:00:00.000Z",
    "CropDamage": 2621400
  },
  {
    "StartTime": "2007-07-30T00:00:00.000Z",
    "CropDamage": 2857500
  },
  {
    "StartTime": "2007-08-06T00:00:00.000Z",
    "CropDamage": 4094000
  },
  {
    "StartTime": "2007-08-13T00:00:00.000Z",
    "CropDamage": 33194000
  },
  {
    "StartTime": "2007-08-20T00:00:00.000Z",
    "CropDamage": 50249000
  },
  {
    "StartTime": "2007-08-27T00:00:00.000Z",
    "CropDamage": 718067000
  },
  {
    "StartTime": "2007-09-03T00:00:00.000Z",
    "CropDamage": 6720000
  },
  {
    "StartTime": "2007-09-17T00:00:00.000Z",
    "CropDamage": 515000
  },
  {
    "StartTime": "2007-09-24T00:00:00.000Z",
    "CropDamage": 2961000
  },
  {
    "StartTime": "2007-10-01T00:00:00.000Z",
    "CropDamage": 10252000
  },
  {
    "StartTime": "2007-10-08T00:00:00.000Z",
    "CropDamage": 29111500
  },
  {
    "StartTime": "2007-10-15T00:00:00.000Z",
    "CropDamage": 21579200
  },
  {
    "StartTime": "2007-10-22T00:00:00.000Z",
    "CropDamage": 21600000
  },
  {
    "StartTime": "2007-11-26T00:00:00.000Z",
    "CropDamage": 110000
  },
  {
    "StartTime": "2007-12-03T00:00:00.000Z",
    "CropDamage": 270000
  },
  {
    "StartTime": "2007-12-10T00:00:00.000Z",
    "CropDamage": 27000
  },
  {
    "StartTime": "2007-12-17T00:00:00.000Z",
    "CropDamage": 141000
  },
  {
    "StartTime": "2007-12-24T00:00:00.000Z",
    "CropDamage": 20000
  }
]
`;

exports[`command - tutorial-aggregation 8`] = `
[
  {
    "State": "IOWA",
    "TotalStormsInState": 2337,
    "StormsWithCropDamage": 359,
    "PercentWithCropDamage": 15.36
  },
  {
    "State": "NEBRASKA",
    "TotalStormsInState": 1766,
    "StormsWithCropDamage": 201,
    "PercentWithCropDamage": 11.38
  },
  {
    "State": "MISSISSIPPI",
    "TotalStormsInState": 1218,
    "StormsWithCropDamage": 105,
    "PercentWithCropDamage": 8.62
  },
  {
    "State": "NORTH CAROLINA",
    "TotalStormsInState": 1721,
    "StormsWithCropDamage": 82,
    "PercentWithCropDamage": 4.76
  },
  {
    "State": "MISSOURI",
    "TotalStormsInState": 2016,
    "StormsWithCropDamage": 78,
    "PercentWithCropDamage": 3.87
  },
  {
    "State": "WISCONSIN",
    "TotalStormsInState": 1850,
    "StormsWithCropDamage": 75,
    "PercentWithCropDamage": 4.05
  },
  {
    "State": "TEXAS",
    "TotalStormsInState": 4701,
    "StormsWithCropDamage": 72,
    "PercentWithCropDamage": 1.53
  },
  {
    "State": "KANSAS",
    "TotalStormsInState": 3166,
    "StormsWithCropDamage": 70,
    "PercentWithCropDamage": 2.21
  },
  {
    "State": "NORTH DAKOTA",
    "TotalStormsInState": 905,
    "StormsWithCropDamage": 56,
    "PercentWithCropDamage": 6.19
  },
  {
    "State": "KENTUCKY",
    "TotalStormsInState": 1391,
    "StormsWithCropDamage": 49,
    "PercentWithCropDamage": 3.52
  },
  {
    "State": "CALIFORNIA",
    "TotalStormsInState": 898,
    "StormsWithCropDamage": 49,
    "PercentWithCropDamage": 5.46
  },
  {
    "State": "OHIO",
    "TotalStormsInState": 1233,
    "StormsWithCropDamage": 43,
    "PercentWithCropDamage": 3.49
  },
  {
    "State": "VIRGINIA",
    "TotalStormsInState": 1647,
    "StormsWithCropDamage": 39,
    "PercentWithCropDamage": 2.37
  },
  {
    "State": "MINNESOTA",
    "TotalStormsInState": 1881,
    "StormsWithCropDamage": 37,
    "PercentWithCropDamage": 1.97
  },
  {
    "State": "ILLINOIS",
    "TotalStormsInState": 2022,
    "StormsWithCropDamage": 35,
    "PercentWithCropDamage": 1.73
  },
  {
    "State": "INDIANA",
    "TotalStormsInState": 1164,
    "StormsWithCropDamage": 22,
    "PercentWithCropDamage": 1.89
  },
  {
    "State": "SOUTH CAROLINA",
    "TotalStormsInState": 915,
    "StormsWithCropDamage": 17,
    "PercentWithCropDamage": 1.86
  },
  {
    "State": "GEORGIA",
    "TotalStormsInState": 1983,
    "StormsWithCropDamage": 17,
    "PercentWithCropDamage": 0.86
  },
  {
    "State": "TENNESSEE",
    "TotalStormsInState": 1125,
    "StormsWithCropDamage": 16,
    "PercentWithCropDamage": 1.42
  },
  {
    "State": "NEW MEXICO",
    "TotalStormsInState": 527,
    "StormsWithCropDamage": 8,
    "PercentWithCropDamage": 1.52
  },
  {
    "State": "FLORIDA",
    "TotalStormsInState": 1042,
    "StormsWithCropDamage": 8,
    "PercentWithCropDamage": 0.77
  },
  {
    "State": "MICHIGAN",
    "TotalStormsInState": 1637,
    "StormsWithCropDamage": 7,
    "PercentWithCropDamage": 0.43
  },
  {
    "State": "LOUISIANA",
    "TotalStormsInState": 463,
    "StormsWithCropDamage": 5,
    "PercentWithCropDamage": 1.08
  },
  {
    "State": "MONTANA",
    "TotalStormsInState": 1230,
    "StormsWithCropDamage": 4,
    "PercentWithCropDamage": 0.33
  },
  {
    "State": "COLORADO",
    "TotalStormsInState": 1654,
    "StormsWithCropDamage": 4,
    "PercentWithCropDamage": 0.24
  },
  {
    "State": "WEST VIRGINIA",
    "TotalStormsInState": 757,
    "StormsWithCropDamage": 3,
    "PercentWithCropDamage": 0.4
  },
  {
    "State": "OKLAHOMA",
    "TotalStormsInState": 1716,
    "StormsWithCropDamage": 3,
    "PercentWithCropDamage": 0.17
  },
  {
    "State": "AMERICAN SAMOA",
    "TotalStormsInState": 16,
    "StormsWithCropDamage": 3,
    "PercentWithCropDamage": 18.75
  },
  {
    "State": "ALABAMA",
    "TotalStormsInState": 1315,
    "StormsWithCropDamage": 3,
    "PercentWithCropDamage": 0.23
  },
  {
    "State": "WYOMING",
    "TotalStormsInState": 396,
    "StormsWithCropDamage": 2,
    "PercentWithCropDamage": 0.51
  },
  {
    "State": "VERMONT",
    "TotalStormsInState": 600,
    "StormsWithCropDamage": 2,
    "PercentWithCropDamage": 0.33
  },
  {
    "State": "PUERTO RICO",
    "TotalStormsInState": 192,
    "StormsWithCropDamage": 2,
    "PercentWithCropDamage": 1.04
  },
  {
    "State": "OREGON",
    "TotalStormsInState": 423,
    "StormsWithCropDamage": 2,
    "PercentWithCropDamage": 0.47
  },
  {
    "State": "NEW JERSEY",
    "TotalStormsInState": 1044,
    "StormsWithCropDamage": 2,
    "PercentWithCropDamage": 0.19
  },
  {
    "State": "ARKANSAS",
    "TotalStormsInState": 1028,
    "StormsWithCropDamage": 2,
    "PercentWithCropDamage": 0.19
  },
  {
    "State": "WASHINGTON",
    "TotalStormsInState": 261,
    "StormsWithCropDamage": 1,
    "PercentWithCropDamage": 0.38
  },
  {
    "State": "VIRGIN ISLANDS",
    "TotalStormsInState": 12,
    "StormsWithCropDamage": 1,
    "PercentWithCropDamage": 8.33
  },
  {
    "State": "SOUTH DAKOTA",
    "TotalStormsInState": 1567,
    "StormsWithCropDamage": 1,
    "PercentWithCropDamage": 0.06
  },
  {
    "State": "PENNSYLVANIA",
    "TotalStormsInState": 1687,
    "StormsWithCropDamage": 1,
    "PercentWithCropDamage": 0.06
  },
  {
    "State": "NEW YORK",
    "TotalStormsInState": 1750,
    "StormsWithCropDamage": 1,
    "PercentWithCropDamage": 0.06
  },
  {
    "State": "NEVADA",
    "TotalStormsInState": 163,
    "StormsWithCropDamage": 1,
    "PercentWithCropDamage": 0.61
  },
  {
    "State": "MASSACHUSETTS",
    "TotalStormsInState": 416,
    "StormsWithCropDamage": 1,
    "PercentWithCropDamage": 0.24
  },
  {
    "State": "IDAHO",
    "TotalStormsInState": 247,
    "StormsWithCropDamage": 1,
    "PercentWithCropDamage": 0.4
  },
  {
    "State": "HAWAII",
    "TotalStormsInState": 457,
    "StormsWithCropDamage": 1,
    "PercentWithCropDamage": 0.22
  },
  {
    "State": "UTAH",
    "TotalStormsInState": 360,
    "StormsWithCropDamage": 0,
    "PercentWithCropDamage": 0
  },
  {
    "State": "RHODE ISLAND",
    "TotalStormsInState": 51,
    "StormsWithCropDamage": 0,
    "PercentWithCropDamage": 0
  },
  {
    "State": "NEW HAMPSHIRE",
    "TotalStormsInState": 394,
    "StormsWithCropDamage": 0,
    "PercentWithCropDamage": 0
  },
  {
    "State": "MARYLAND",
    "TotalStormsInState": 673,
    "StormsWithCropDamage": 0,
    "PercentWithCropDamage": 0
  },
  {
    "State": "MAINE",
    "TotalStormsInState": 758,
    "StormsWithCropDamage": 0,
    "PercentWithCropDamage": 0
  },
  {
    "State": "LAKE SUPERIOR",
    "TotalStormsInState": 34,
    "StormsWithCropDamage": 0,
    "PercentWithCropDamage": 0
  },
  {
    "State": "LAKE ST CLAIR",
    "TotalStormsInState": 32,
    "StormsWithCropDamage": 0,
    "PercentWithCropDamage": 0
  },
  {
    "State": "LAKE ONTARIO",
    "TotalStormsInState": 8,
    "StormsWithCropDamage": 0,
    "PercentWithCropDamage": 0
  },
  {
    "State": "LAKE MICHIGAN",
    "TotalStormsInState": 182,
    "StormsWithCropDamage": 0,
    "PercentWithCropDamage": 0
  },
  {
    "State": "LAKE HURON",
    "TotalStormsInState": 63,
    "StormsWithCropDamage": 0,
    "PercentWithCropDamage": 0
  },
  {
    "State": "LAKE ERIE",
    "TotalStormsInState": 27,
    "StormsWithCropDamage": 0,
    "PercentWithCropDamage": 0
  },
  {
    "State": "HAWAII WATERS",
    "TotalStormsInState": 2,
    "StormsWithCropDamage": 0,
    "PercentWithCropDamage": 0
  },
  {
    "State": "GULF OF MEXICO",
    "TotalStormsInState": 577,
    "StormsWithCropDamage": 0,
    "PercentWithCropDamage": 0
  },
  {
    "State": "GULF OF ALASKA",
    "TotalStormsInState": 4,
    "StormsWithCropDamage": 0,
    "PercentWithCropDamage": 0
  },
  {
    "State": "GUAM",
    "TotalStormsInState": 4,
    "StormsWithCropDamage": 0,
    "PercentWithCropDamage": 0
  },
  {
    "State": "E PACIFIC",
    "TotalStormsInState": 10,
    "StormsWithCropDamage": 0,
    "PercentWithCropDamage": 0
  },
  {
    "State": "DISTRICT OF COLUMBIA",
    "TotalStormsInState": 22,
    "StormsWithCropDamage": 0,
    "PercentWithCropDamage": 0
  },
  {
    "State": "DELAWARE",
    "TotalStormsInState": 200,
    "StormsWithCropDamage": 0,
    "PercentWithCropDamage": 0
  },
  {
    "State": "CONNECTICUT",
    "TotalStormsInState": 148,
    "StormsWithCropDamage": 0,
    "PercentWithCropDamage": 0
  },
  {
    "State": "ATLANTIC SOUTH",
    "TotalStormsInState": 193,
    "StormsWithCropDamage": 0,
    "PercentWithCropDamage": 0
  },
  {
    "State": "ATLANTIC NORTH",
    "TotalStormsInState": 188,
    "StormsWithCropDamage": 0,
    "PercentWithCropDamage": 0
  },
  {
    "State": "ARIZONA",
    "TotalStormsInState": 340,
    "StormsWithCropDamage": 0,
    "PercentWithCropDamage": 0
  },
  {
    "State": "ALASKA",
    "TotalStormsInState": 257,
    "StormsWithCropDamage": 0,
    "PercentWithCropDamage": 0
  }
]
`;

exports[`command - tutorial-aggregation 9`] = `
[
  {
    "EventType": "Thunderstorm Wind",
    "EventCount": 13015,
    "Percentage": 22.034673077574237
  },
  {
    "EventType": "Winter Storm",
    "EventCount": 3010,
    "Percentage": 5.0959943114482105
  },
  {
    "EventType": "Winter Weather",
    "EventCount": 3349,
    "Percentage": 5.669928554498358
  },
  {
    "EventType": "Blizzard",
    "EventCount": 496,
    "Percentage": 0.8397385975011005
  },
  {
    "EventType": "Heavy Rain",
    "EventCount": 836,
    "Percentage": 1.4153658619171774
  },
  {
    "EventType": "Drought",
    "EventCount": 3616,
    "Percentage": 6.121965259201572
  },
  {
    "EventType": "Flood",
    "EventCount": 1787,
    "Percentage": 3.0254291809162632
  },
  {
    "EventType": "Lightning",
    "EventCount": 721,
    "Percentage": 1.220668404835269
  },
  {
    "EventType": "High Wind",
    "EventCount": 2289,
    "Percentage": 3.8753259066129413
  },
  {
    "EventType": "Flash Flood",
    "EventCount": 3688,
    "Percentage": 6.2438627975485055
  },
  {
    "EventType": "Coastal Flood",
    "EventCount": 241,
    "Percentage": 0.4080181491890427
  },
  {
    "EventType": "Dense Fog",
    "EventCount": 776,
    "Percentage": 1.3137845799613992
  },
  {
    "EventType": "High Surf",
    "EventCount": 400,
    "Percentage": 0.6772085463718552
  },
  {
    "EventType": "Extreme Cold/Wind Chill",
    "EventCount": 506,
    "Percentage": 0.8566688111603968
  },
  {
    "EventType": "Strong Wind",
    "EventCount": 825,
    "Percentage": 1.3967426268919514
  },
  {
    "EventType": "Debris Flow",
    "EventCount": 66,
    "Percentage": 0.1117394101513561
  },
  {
    "EventType": "Heavy Snow",
    "EventCount": 2589,
    "Percentage": 4.383232316391833
  },
  {
    "EventType": "Wildfire",
    "EventCount": 274,
    "Percentage": 0.46388785426472084
  },
  {
    "EventType": "Frost/Freeze",
    "EventCount": 1851,
    "Percentage": 3.1337825483357595
  },
  {
    "EventType": "Rip Current",
    "EventCount": 61,
    "Percentage": 0.10327430332170792
  },
  {
    "EventType": "Marine Thunderstorm Wind",
    "EventCount": 963,
    "Percentage": 1.6303795753902415
  },
  {
    "EventType": "Ice Storm",
    "EventCount": 1071,
    "Percentage": 1.8132258829106425
  },
  {
    "EventType": "Tornado",
    "EventCount": 1238,
    "Percentage": 2.095960451020892
  },
  {
    "EventType": "Hail",
    "EventCount": 12711,
    "Percentage": 21.519994582331627
  },
  {
    "EventType": "Avalanche",
    "EventCount": 27,
    "Percentage": 0.045711576880100226
  },
  {
    "EventType": "Funnel Cloud",
    "EventCount": 340,
    "Percentage": 0.5756272644160769
  },
  {
    "EventType": "Lake-Effect Snow",
    "EventCount": 238,
    "Percentage": 0.4029390850912538
  },
  {
    "EventType": "Waterspout",
    "EventCount": 288,
    "Percentage": 0.48759015338773576
  },
  {
    "EventType": "Cold/Wind Chill",
    "EventCount": 453,
    "Percentage": 0.766938678766126
  },
  {
    "EventType": "Sleet",
    "EventCount": 33,
    "Percentage": 0.05586970507567805
  },
  {
    "EventType": "Astronomical Low Tide",
    "EventCount": 66,
    "Percentage": 0.1117394101513561
  },
  {
    "EventType": "Heat",
    "EventCount": 464,
    "Percentage": 0.785561913791352
  },
  {
    "EventType": "Dust Storm",
    "EventCount": 56,
    "Percentage": 0.09480919649205972
  },
  {
    "EventType": "Freezing Fog",
    "EventCount": 11,
    "Percentage": 0.018623235025226018
  },
  {
    "EventType": "Volcanic Ash",
    "EventCount": 1,
    "Percentage": 0.001693021365929638
  },
  {
    "EventType": "Marine Hail",
    "EventCount": 60,
    "Percentage": 0.10158128195577829
  },
  {
    "EventType": "Marine Strong Wind",
    "EventCount": 8,
    "Percentage": 0.013544170927437104
  },
  {
    "EventType": "Tropical Storm",
    "EventCount": 32,
    "Percentage": 0.054176683709748416
  },
  {
    "EventType": "Dust Devil",
    "EventCount": 6,
    "Percentage": 0.010158128195577827
  },
  {
    "EventType": "Lakeshore Flood",
    "EventCount": 6,
    "Percentage": 0.010158128195577827
  },
  {
    "EventType": "Excessive Heat",
    "EventCount": 488,
    "Percentage": 0.8261944265736634
  },
  {
    "EventType": "Storm Surge/Tide",
    "EventCount": 11,
    "Percentage": 0.018623235025226018
  },
  {
    "EventType": "Tropical Depression",
    "EventCount": 46,
    "Percentage": 0.07787898283276334
  },
  {
    "EventType": "Dense Smoke",
    "EventCount": 3,
    "Percentage": 0.005079064097788914
  },
  {
    "EventType": "Hurricane (Typhoon)",
    "EventCount": 49,
    "Percentage": 0.08295804693055227
  },
  {
    "EventType": "Marine High Wind",
    "EventCount": 1,
    "Percentage": 0.001693021365929638
  }
]
`;

exports[`command - tutorial-common 1`] = `
[
  {
    "TableName": "StormEvents",
    "Schema": "{\\"Name\\":\\"StormEvents\\",\\"OrderedColumns\\":[{\\"Name\\":\\"StartTime\\",\\"Type\\":\\"System.DateTime\\",\\"CslType\\":\\"datetime\\"},{\\"Name\\":\\"EndTime\\",\\"Type\\":\\"System.DateTime\\",\\"CslType\\":\\"datetime\\"},{\\"Name\\":\\"EpisodeId\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"EventId\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"State\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"EventType\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"InjuriesDirect\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"InjuriesIndirect\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"DeathsDirect\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"DeathsIndirect\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"DamageProperty\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"DamageCrops\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"Source\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"BeginLocation\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"EndLocation\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"BeginLat\\",\\"Type\\":\\"System.Double\\",\\"CslType\\":\\"real\\"},{\\"Name\\":\\"BeginLon\\",\\"Type\\":\\"System.Double\\",\\"CslType\\":\\"real\\"},{\\"Name\\":\\"EndLat\\",\\"Type\\":\\"System.Double\\",\\"CslType\\":\\"real\\"},{\\"Name\\":\\"EndLon\\",\\"Type\\":\\"System.Double\\",\\"CslType\\":\\"real\\"},{\\"Name\\":\\"EpisodeNarrative\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"EventNarrative\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"StormSummary\\",\\"Type\\":\\"System.Object\\",\\"CslType\\":\\"dynamic\\"}]}",
    "DatabaseName": "Test",
    "Folder": null,
    "DocString": null
  }
]
`;

exports[`command - tutorial-common 10`] = `
[
  {
    "StartTime": "2007-08-18T21:30:00.000Z",
    "EndTime": "2007-08-19T23:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 5000000
  },
  {
    "StartTime": "2007-06-27T00:00:00.000Z",
    "EndTime": "2007-06-27T12:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 1200000
  },
  {
    "StartTime": "2007-06-28T18:00:00.000Z",
    "EndTime": "2007-06-28T23:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 1000000
  },
  {
    "StartTime": "2007-06-26T20:00:00.000Z",
    "EndTime": "2007-06-26T23:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 750000
  },
  {
    "StartTime": "2007-06-27T00:00:00.000Z",
    "EndTime": "2007-06-27T08:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 750000
  }
]
`;

exports[`command - tutorial-common 11`] = `
[
  {
    "StartTime": "2007-08-18T21:30:00.000Z",
    "EndTime": "2007-08-19T23:00:00.000Z",
    "Duration": 0,
    "DamageProperty": 5000000
  },
  {
    "StartTime": "2007-06-27T00:00:00.000Z",
    "EndTime": "2007-06-27T12:00:00.000Z",
    "Duration": 0,
    "DamageProperty": 1200000
  },
  {
    "StartTime": "2007-06-28T18:00:00.000Z",
    "EndTime": "2007-06-28T23:00:00.000Z",
    "Duration": 0,
    "DamageProperty": 1000000
  },
  {
    "StartTime": "2007-06-26T20:00:00.000Z",
    "EndTime": "2007-06-26T23:00:00.000Z",
    "Duration": 0,
    "DamageProperty": 750000
  },
  {
    "StartTime": "2007-06-27T00:00:00.000Z",
    "EndTime": "2007-06-27T08:00:00.000Z",
    "Duration": 0,
    "DamageProperty": 750000
  }
]
`;

exports[`command - tutorial-common 12`] = `
[
  {
    "StartTime": "2007-08-18T21:30:00.000Z",
    "EndTime": "2007-08-19T23:00:00.000Z",
    "EpisodeId": 9226,
    "EventId": 52007,
    "State": "TEXAS",
    "EventType": "Flood",
    "InjuriesDirect": 0,
    "InjuriesIndirect": 0,
    "DeathsDirect": 0,
    "DeathsIndirect": 0,
    "DamageProperty": 5000000,
    "DamageCrops": 0,
    "Source": "Emergency Manager",
    "BeginLocation": "ABILENE",
    "EndLocation": "ABILENE",
    "BeginLat": 32.45,
    "BeginLon": -99.73,
    "EndLat": 32.45,
    "EndLon": -99.73,
    "EpisodeNarrative": "Excessive rainfall from the remnants of Tropical Storm Erin caused flooding of many rivers, streams, and lakes across portions of the Texas Big Country. Rainfall amounts of 3 to 9 inches were reported, resulting in several road closures. Many streets, homes, and businesses were flooded in the town of Hamlin and around the city of Abilene, prompting emergency management to call for a mandatory evacuation of residents along Elm Creek. Many lakes flowed over their spillways, with the Oak Creek Reservoir and Lake Sweetwater rising 15 and 30 feet, respectively, within days of the heavy rainfall.",
    "EventNarrative": "Excessive rainfall from heavy rains Friday night into Saturday morning across southwest Taylor County caused water to spill over the main spillway at Lake Abilene. This water flowed into Elm Creek and flooded several streets, homes, and businesses in the City of Abilene Sunday morning, prompting the Abilene Emergency Operations Center to call for a mandatory evacuation of the affected locations.",
    "StormSummary": {
      "TotalDamages": 5000000,
      "StartTime": "2007-08-18T21:30:00.0000000Z",
      "EndTime": "2007-08-19T23:00:00.0000000Z",
      "Details": {
        "Description": "Excessive rainfall from heavy rains Friday night into Saturday morning across southwest Taylor County caused water to spill over the main spillway at Lake Abilene. This water flowed into Elm Creek and flooded several streets, homes, and businesses in the City of Abilene Sunday morning, prompting the Abilene Emergency Operations Center to call for a mandatory evacuation of the affected locations.",
        "Location": "TEXAS"
      }
    },
    "Duration": 0
  },
  {
    "StartTime": "2007-06-27T00:00:00.000Z",
    "EndTime": "2007-06-27T12:00:00.000Z",
    "EpisodeId": 6403,
    "EventId": 38449,
    "State": "TEXAS",
    "EventType": "Flood",
    "InjuriesDirect": 0,
    "InjuriesIndirect": 0,
    "DeathsDirect": 0,
    "DeathsIndirect": 0,
    "DamageProperty": 1200000,
    "DamageCrops": 0,
    "Source": "Newspaper",
    "BeginLocation": "OLDEN",
    "EndLocation": "OLDEN",
    "BeginLat": 32.3996,
    "BeginLon": -98.7258,
    "EndLat": 32.3996,
    "EndLon": -98.7258,
    "EpisodeNarrative": "An upper low remained over the area triggering several rounds of showers and thunderstorms.  A very moist environment encouraged flash flooding.",
    "EventNarrative": "Flooding of residences around Lake Leon continued from residual floodwaters flowing into the lake.  Over 200 homes sustained flood damage.",
    "StormSummary": {
      "TotalDamages": 1200000,
      "StartTime": "2007-06-27T00:00:00.0000000Z",
      "EndTime": "2007-06-27T12:00:00.0000000Z",
      "Details": {
        "Description": "Flooding of residences around Lake Leon continued from residual floodwaters flowing into the lake.  Over 200 homes sustained flood damage.",
        "Location": "TEXAS"
      }
    },
    "Duration": 0
  },
  {
    "StartTime": "2007-06-28T18:00:00.000Z",
    "EndTime": "2007-06-28T23:00:00.000Z",
    "EpisodeId": 6508,
    "EventId": 48106,
    "State": "TEXAS",
    "EventType": "Flood",
    "InjuriesDirect": 0,
    "InjuriesIndirect": 0,
    "DeathsDirect": 0,
    "DeathsIndirect": 0,
    "DamageProperty": 1000000,
    "DamageCrops": 0,
    "Source": "Newspaper",
    "BeginLocation": "GATESVILLE",
    "EndLocation": "MOUND",
    "BeginLat": 31.43,
    "BeginLon": -97.75,
    "EndLat": 31.35,
    "EndLon": -97.65,
    "EpisodeNarrative": "An upper low remained over the area triggering several rounds of showers and thunderstorms.  A very moist environment encouraged flash flooding on top of already saturated grounds.",
    "EventNarrative": "Numerous residents were evacuated, and at least 24 homes were affected by floodwaters from the Leon River.",
    "StormSummary": {
      "TotalDamages": 1000000,
      "StartTime": "2007-06-28T18:00:00.0000000Z",
      "EndTime": "2007-06-28T23:00:00.0000000Z",
      "Details": {
        "Description": "Numerous residents were evacuated, and at least 24 homes were affected by floodwaters from the Leon River.",
        "Location": "TEXAS"
      }
    },
    "Duration": 0
  },
  {
    "StartTime": "2007-06-26T20:00:00.000Z",
    "EndTime": "2007-06-26T23:00:00.000Z",
    "EpisodeId": 6403,
    "EventId": 37850,
    "State": "TEXAS",
    "EventType": "Flood",
    "InjuriesDirect": 0,
    "InjuriesIndirect": 0,
    "DeathsDirect": 0,
    "DeathsIndirect": 0,
    "DamageProperty": 750000,
    "DamageCrops": 0,
    "Source": "Trained Spotter",
    "BeginLocation": "LAKE GRANBURY NORTH",
    "EndLocation": "LAKE GRANBURY SOUTH",
    "BeginLat": 32.48,
    "BeginLon": -97.82,
    "EndLat": 32.4,
    "EndLon": -97.7,
    "EpisodeNarrative": "An upper low remained over the area triggering several rounds of showers and thunderstorms.  A very moist environment encouraged flash flooding.",
    "EventNarrative": "Multiple high water rescues were required in Lake Granbury Harbor near Robinson Creek.  Several people were stranded in their homes and some were stuck in trees.  About fifty homes sustained flood damage.",
    "StormSummary": {
      "TotalDamages": 750000,
      "StartTime": "2007-06-26T20:00:00.0000000Z",
      "EndTime": "2007-06-26T23:00:00.0000000Z",
      "Details": {
        "Description": "Multiple high water rescues were required in Lake Granbury Harbor near Robinson Creek.  Several people were stranded in their homes and some were stuck in trees.  About fifty homes sustained flood damage.",
        "Location": "TEXAS"
      }
    },
    "Duration": 0
  },
  {
    "StartTime": "2007-06-27T00:00:00.000Z",
    "EndTime": "2007-06-27T08:00:00.000Z",
    "EpisodeId": 6403,
    "EventId": 38672,
    "State": "TEXAS",
    "EventType": "Flood",
    "InjuriesDirect": 0,
    "InjuriesIndirect": 0,
    "DeathsDirect": 0,
    "DeathsIndirect": 0,
    "DamageProperty": 750000,
    "DamageCrops": 0,
    "Source": "Newspaper",
    "BeginLocation": "SALADO",
    "EndLocation": "LITTLE RIVER",
    "BeginLat": 30.93,
    "BeginLon": -97.53,
    "EndLat": 30.98,
    "EndLon": -97.37,
    "EpisodeNarrative": "An upper low remained over the area triggering several rounds of showers and thunderstorms.  A very moist environment encouraged flash flooding.",
    "EventNarrative": "Runoff from heavy rains caused Mills Creek to flood portions of Salado, including Mill Creek Drive and Smith Bluff.  About 30 homes were evacuated and one man had to be rescued from his rooftop.  A water rescue was required on the Little River, and Salado Creek flooded the Interstate 35 access roads and the bridge on Main Street by four feet of water.  One vehicle was washed off the road and a high water rescue was needed.",
    "StormSummary": {
      "TotalDamages": 750000,
      "StartTime": "2007-06-27T00:00:00.0000000Z",
      "EndTime": "2007-06-27T08:00:00.0000000Z",
      "Details": {
        "Description": "Runoff from heavy rains caused Mills Creek to flood portions of Salado, including Mill Creek Drive and Smith Bluff.  About 30 homes were evacuated and one man had to be rescued from his rooftop.  A water rescue was required on the Little River, and Salado Creek flooded the Interstate 35 access roads and the bridge on Main Street by four feet of water.  One vehicle was washed off the road and a high water rescue was needed.",
        "Location": "TEXAS"
      }
    },
    "Duration": 0
  }
]
`;

exports[`command - tutorial-common 13`] = `
[
  {
    "EventId": 12689,
    "Source": "Emergency Manager",
    "FriendlyName": "Public"
  },
  {
    "EventId": 12680,
    "Source": "Emergency Manager",
    "FriendlyName": "Public"
  },
  {
    "EventId": 12700,
    "Source": "Emergency Manager",
    "FriendlyName": "Public"
  },
  {
    "EventId": 12704,
    "Source": "Emergency Manager",
    "FriendlyName": "Public"
  },
  {
    "EventId": 12683,
    "Source": "Emergency Manager",
    "FriendlyName": "Public"
  },
  {
    "EventId": 12685,
    "Source": "Emergency Manager",
    "FriendlyName": "Public"
  },
  {
    "EventId": 12697,
    "Source": "Emergency Manager",
    "FriendlyName": "Public"
  },
  {
    "EventId": 12698,
    "Source": "Emergency Manager",
    "FriendlyName": "Public"
  },
  {
    "EventId": 12705,
    "Source": "Emergency Manager",
    "FriendlyName": "Public"
  },
  {
    "EventId": 12684,
    "Source": "Emergency Manager",
    "FriendlyName": "Public"
  },
  {
    "EventId": 12686,
    "Source": "Emergency Manager",
    "FriendlyName": "Public"
  },
  {
    "EventId": 12687,
    "Source": "Emergency Manager",
    "FriendlyName": "Public"
  },
  {
    "EventId": 12688,
    "Source": "Emergency Manager",
    "FriendlyName": "Public"
  },
  {
    "EventId": 12695,
    "Source": "Emergency Manager",
    "FriendlyName": "Public"
  },
  {
    "EventId": 12699,
    "Source": "Emergency Manager",
    "FriendlyName": "Public"
  },
  {
    "EventId": 12694,
    "Source": "Emergency Manager",
    "FriendlyName": "Public"
  },
  {
    "EventId": 12681,
    "Source": "Emergency Manager",
    "FriendlyName": "Public"
  },
  {
    "EventId": 12679,
    "Source": "Emergency Manager",
    "FriendlyName": "Public"
  },
  {
    "EventId": 12682,
    "Source": "Emergency Manager",
    "FriendlyName": "Public"
  },
  {
    "EventId": 12691,
    "Source": "Emergency Manager",
    "FriendlyName": "Public"
  }
]
`;

exports[`command - tutorial-common 14`] = `
[]
`;

exports[`command - tutorial-common 2`] = `
[
  {
    "ExtentId": "00000000-0000-0000-0000-000000000000",
    "ItemLoaded": "inproc:00000000-0000-0000-0000-000000000000",
    "Duration": 0,
    "HasErrors": false,
    "OperationId": "00000000-0000-0000-0000-000000000000"
  }
]
`;

exports[`command - tutorial-common 3`] = `
[
  {
    "Count": 59066
  }
]
`;

exports[`command - tutorial-common 4`] = `
[
  {
    "StartTime": "2007-01-01T00:00:00.000Z",
    "EndTime": "2007-01-01T00:00:00.000Z",
    "EpisodeId": 2592,
    "EventId": 13208,
    "State": "NORTH CAROLINA",
    "EventType": "Thunderstorm Wind",
    "InjuriesDirect": 0,
    "InjuriesIndirect": 0,
    "DeathsDirect": 0,
    "DeathsIndirect": 0,
    "DamageProperty": 0,
    "DamageCrops": 0,
    "Source": "Public",
    "BeginLocation": "CASAR",
    "EndLocation": "CASAR",
    "BeginLat": 35.52,
    "BeginLon": -81.63,
    "EndLat": 35.52,
    "EndLon": -81.63,
    "EpisodeNarrative": "A small cluster of thunderstorms moved rapidly across the foothills and piedmont of western North Carolina, producing scattered wind damage.",
    "EventNarrative": "Several trees down.",
    "StormSummary": {
      "TotalDamages": 0,
      "StartTime": "2007-01-01T00:00:00.0000000Z",
      "EndTime": "2007-01-01T00:00:00.0000000Z",
      "Details": {
        "Description": "Several trees down.",
        "Location": "NORTH CAROLINA"
      }
    }
  },
  {
    "StartTime": "2007-01-01T00:00:00.000Z",
    "EndTime": "2007-01-01T05:00:00.000Z",
    "EpisodeId": 4171,
    "EventId": 23358,
    "State": "WISCONSIN",
    "EventType": "Winter Storm",
    "InjuriesDirect": 0,
    "InjuriesIndirect": 0,
    "DeathsDirect": 0,
    "DeathsIndirect": 0,
    "DamageProperty": 0,
    "DamageCrops": 0,
    "Source": "COOP Observer",
    "BeginLocation": "",
    "EndLocation": "",
    "BeginLat": null,
    "BeginLon": null,
    "EndLat": null,
    "EndLon": null,
    "EpisodeNarrative": "A powerful storm system moved from the southern plains through eastern Wisconsin, bringing copious amounts of precipitation to northwest Wisconsin from December 30th through the morning of January 1st. Deep tropical moisture out ahead of the storm brought heavy rains to the area on December 30th and 31st. Many areas saw over 1 inch of rain. Cold air wrapped around the system and changed the rain over to snow New Year's Eve. The snow finally ended during the early morning hours of New Year's Day, with the heaviest amounts of 6 to 12 inches reported across Ashland and Iron counties.",
    "EventNarrative": "",
    "StormSummary": {
      "TotalDamages": 0,
      "StartTime": "2007-01-01T00:00:00.0000000Z",
      "EndTime": "2007-01-01T05:00:00.0000000Z",
      "Details": {
        "Description": "",
        "Location": "WISCONSIN"
      }
    }
  },
  {
    "StartTime": "2007-01-01T00:00:00.000Z",
    "EndTime": "2007-01-01T05:00:00.000Z",
    "EpisodeId": 4171,
    "EventId": 23357,
    "State": "WISCONSIN",
    "EventType": "Winter Storm",
    "InjuriesDirect": 0,
    "InjuriesIndirect": 0,
    "DeathsDirect": 0,
    "DeathsIndirect": 0,
    "DamageProperty": 0,
    "DamageCrops": 0,
    "Source": "COOP Observer",
    "BeginLocation": "",
    "EndLocation": "",
    "BeginLat": null,
    "BeginLon": null,
    "EndLat": null,
    "EndLon": null,
    "EpisodeNarrative": "A powerful storm system moved from the southern plains through eastern Wisconsin, bringing copious amounts of precipitation to northwest Wisconsin from December 30th through the morning of January 1st. Deep tropical moisture out ahead of the storm brought heavy rains to the area on December 30th and 31st. Many areas saw over 1 inch of rain. Cold air wrapped around the system and changed the rain over to snow New Year's Eve. The snow finally ended during the early morning hours of New Year's Day, with the heaviest amounts of 6 to 12 inches reported across Ashland and Iron counties.",
    "EventNarrative": "",
    "StormSummary": {
      "TotalDamages": 0,
      "StartTime": "2007-01-01T00:00:00.0000000Z",
      "EndTime": "2007-01-01T05:00:00.0000000Z",
      "Details": {
        "Description": "",
        "Location": "WISCONSIN"
      }
    }
  },
  {
    "StartTime": "2007-01-01T00:00:00.000Z",
    "EndTime": "2007-01-01T06:00:00.000Z",
    "EpisodeId": 1930,
    "EventId": 9494,
    "State": "NEW YORK",
    "EventType": "Winter Weather",
    "InjuriesDirect": 0,
    "InjuriesIndirect": 0,
    "DeathsDirect": 0,
    "DeathsIndirect": 0,
    "DamageProperty": 2000,
    "DamageCrops": 0,
    "Source": "Department of Highways",
    "BeginLocation": "",
    "EndLocation": "",
    "BeginLat": null,
    "BeginLon": null,
    "EndLat": null,
    "EndLon": null,
    "EpisodeNarrative": "A weak area of low pressure moved across Ontario and Quebec provinces in Canada during the morning and afternoon of the 1st. Mild, moist air traveled over a seasonably cool airmass across New York and this resulted in a period of freezing rain from around Midnight to just before dawn. Freezing rain accumulated up to 1/4 of an inch across northern New York resulting in slick roads and several vehicle accidents.",
    "EventNarrative": "",
    "StormSummary": {
      "TotalDamages": 2000,
      "StartTime": "2007-01-01T00:00:00.0000000Z",
      "EndTime": "2007-01-01T06:00:00.0000000Z",
      "Details": {
        "Description": "",
        "Location": "NEW YORK"
      }
    }
  },
  {
    "StartTime": "2007-01-01T00:00:00.000Z",
    "EndTime": "2007-01-01T06:00:00.000Z",
    "EpisodeId": 1930,
    "EventId": 9488,
    "State": "NEW YORK",
    "EventType": "Winter Weather",
    "InjuriesDirect": 0,
    "InjuriesIndirect": 0,
    "DeathsDirect": 0,
    "DeathsIndirect": 0,
    "DamageProperty": 2000,
    "DamageCrops": 0,
    "Source": "Department of Highways",
    "BeginLocation": "",
    "EndLocation": "",
    "BeginLat": null,
    "BeginLon": null,
    "EndLat": null,
    "EndLon": null,
    "EpisodeNarrative": "A weak area of low pressure moved across Ontario and Quebec provinces in Canada during the morning and afternoon of the 1st. Mild, moist air traveled over a seasonably cool airmass across New York and this resulted in a period of freezing rain from around Midnight to just before dawn. Freezing rain accumulated up to 1/4 of an inch across northern New York resulting in slick roads and several vehicle accidents.",
    "EventNarrative": "",
    "StormSummary": {
      "TotalDamages": 2000,
      "StartTime": "2007-01-01T00:00:00.0000000Z",
      "EndTime": "2007-01-01T06:00:00.0000000Z",
      "Details": {
        "Description": "",
        "Location": "NEW YORK"
      }
    }
  }
]
`;

exports[`command - tutorial-common 5`] = `
[
  {
    "State": "NORTH CAROLINA",
    "EventType": "Thunderstorm Wind",
    "DamageProperty": 0
  },
  {
    "State": "WISCONSIN",
    "EventType": "Winter Storm",
    "DamageProperty": 0
  },
  {
    "State": "WISCONSIN",
    "EventType": "Winter Storm",
    "DamageProperty": 0
  },
  {
    "State": "NEW YORK",
    "EventType": "Winter Weather",
    "DamageProperty": 2000
  },
  {
    "State": "NEW YORK",
    "EventType": "Winter Weather",
    "DamageProperty": 2000
  }
]
`;

exports[`command - tutorial-common 6`] = `
[
  {
    "EventType": "Thunderstorm Wind"
  },
  {
    "EventType": "Winter Storm"
  },
  {
    "EventType": "Winter Weather"
  },
  {
    "EventType": "Blizzard"
  },
  {
    "EventType": "Heavy Rain"
  },
  {
    "EventType": "Drought"
  },
  {
    "EventType": "Flood"
  },
  {
    "EventType": "Lightning"
  },
  {
    "EventType": "High Wind"
  },
  {
    "EventType": "Flash Flood"
  },
  {
    "EventType": "Coastal Flood"
  },
  {
    "EventType": "Dense Fog"
  },
  {
    "EventType": "High Surf"
  },
  {
    "EventType": "Extreme Cold/Wind Chill"
  },
  {
    "EventType": "Strong Wind"
  },
  {
    "EventType": "Debris Flow"
  },
  {
    "EventType": "Heavy Snow"
  },
  {
    "EventType": "Wildfire"
  },
  {
    "EventType": "Frost/Freeze"
  },
  {
    "EventType": "Rip Current"
  },
  {
    "EventType": "Marine Thunderstorm Wind"
  },
  {
    "EventType": "Ice Storm"
  },
  {
    "EventType": "Tornado"
  },
  {
    "EventType": "Hail"
  },
  {
    "EventType": "Avalanche"
  },
  {
    "EventType": "Funnel Cloud"
  },
  {
    "EventType": "Lake-Effect Snow"
  },
  {
    "EventType": "Waterspout"
  },
  {
    "EventType": "Cold/Wind Chill"
  },
  {
    "EventType": "Sleet"
  },
  {
    "EventType": "Astronomical Low Tide"
  },
  {
    "EventType": "Heat"
  },
  {
    "EventType": "Dust Storm"
  },
  {
    "EventType": "Freezing Fog"
  },
  {
    "EventType": "Volcanic Ash"
  },
  {
    "EventType": "Marine Hail"
  },
  {
    "EventType": "Marine Strong Wind"
  },
  {
    "EventType": "Tropical Storm"
  },
  {
    "EventType": "Dust Devil"
  },
  {
    "EventType": "Lakeshore Flood"
  },
  {
    "EventType": "Excessive Heat"
  },
  {
    "EventType": "Storm Surge/Tide"
  },
  {
    "EventType": "Tropical Depression"
  },
  {
    "EventType": "Dense Smoke"
  },
  {
    "EventType": "Hurricane (Typhoon)"
  },
  {
    "EventType": "Marine High Wind"
  }
]
`;

exports[`command - tutorial-common 7`] = `
[
  {
    "StartTime": "2007-08-18T21:30:00.000Z",
    "EndTime": "2007-08-19T23:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 5000000
  },
  {
    "StartTime": "2007-06-27T00:00:00.000Z",
    "EndTime": "2007-06-27T12:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 1200000
  },
  {
    "StartTime": "2007-06-28T18:00:00.000Z",
    "EndTime": "2007-06-28T23:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 1000000
  },
  {
    "StartTime": "2007-06-27T00:00:00.000Z",
    "EndTime": "2007-06-27T08:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 750000
  },
  {
    "StartTime": "2007-06-26T20:00:00.000Z",
    "EndTime": "2007-06-26T23:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 750000
  },
  {
    "StartTime": "2007-06-27T00:00:00.000Z",
    "EndTime": "2007-06-27T10:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 500000
  },
  {
    "StartTime": "2007-06-26T18:00:00.000Z",
    "EndTime": "2007-06-27T18:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 500000
  },
  {
    "StartTime": "2007-06-26T07:30:00.000Z",
    "EndTime": "2007-06-26T13:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 500000
  },
  {
    "StartTime": "2007-06-28T17:28:00.000Z",
    "EndTime": "2007-06-28T20:28:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 300000
  },
  {
    "StartTime": "2007-05-24T06:00:00.000Z",
    "EndTime": "2007-05-25T11:33:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 220000
  },
  {
    "StartTime": "2007-07-06T03:00:00.000Z",
    "EndTime": "2007-07-06T06:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 200000
  },
  {
    "StartTime": "2007-07-01T18:00:00.000Z",
    "EndTime": "2007-07-01T23:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 200000
  },
  {
    "StartTime": "2007-06-26T18:00:00.000Z",
    "EndTime": "2007-06-26T22:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 200000
  },
  {
    "StartTime": "2007-07-12T09:00:00.000Z",
    "EndTime": "2007-07-12T12:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 100000
  },
  {
    "StartTime": "2007-06-29T08:00:00.000Z",
    "EndTime": "2007-06-29T14:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 100000
  },
  {
    "StartTime": "2007-06-28T21:30:00.000Z",
    "EndTime": "2007-06-29T00:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 100000
  },
  {
    "StartTime": "2007-05-08T12:53:00.000Z",
    "EndTime": "2007-05-08T17:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 100000
  },
  {
    "StartTime": "2007-06-16T10:05:00.000Z",
    "EndTime": "2007-06-16T12:05:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 40000
  },
  {
    "StartTime": "2007-06-30T06:00:00.000Z",
    "EndTime": "2007-06-30T12:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 20000
  },
  {
    "StartTime": "2007-05-08T09:00:00.000Z",
    "EndTime": "2007-05-08T17:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 20000
  }
]
`;

exports[`command - tutorial-common 8`] = `
[
  {
    "StartTime": "2007-01-13T08:45:00.000Z",
    "EndTime": "2007-01-13T10:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-01-13T09:30:00.000Z",
    "EndTime": "2007-01-13T21:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-01-13T09:30:00.000Z",
    "EndTime": "2007-01-13T21:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-01-15T22:00:00.000Z",
    "EndTime": "2007-01-16T22:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 20000
  },
  {
    "StartTime": "2007-03-12T02:30:00.000Z",
    "EndTime": "2007-03-12T06:45:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-03-12T03:00:00.000Z",
    "EndTime": "2007-03-13T11:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-03-13T00:30:00.000Z",
    "EndTime": "2007-03-15T08:15:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-03-13T18:00:00.000Z",
    "EndTime": "2007-03-15T06:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-03-13T20:00:00.000Z",
    "EndTime": "2007-03-14T17:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-03-13T22:00:00.000Z",
    "EndTime": "2007-03-17T13:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-03-14T19:30:00.000Z",
    "EndTime": "2007-03-16T11:15:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-03-26T03:45:00.000Z",
    "EndTime": "2007-03-26T21:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-03-29T10:00:00.000Z",
    "EndTime": "2007-03-29T16:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 18000
  },
  {
    "StartTime": "2007-03-29T16:00:00.000Z",
    "EndTime": "2007-03-29T20:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-03-29T18:00:00.000Z",
    "EndTime": "2007-03-29T21:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-03-29T18:30:00.000Z",
    "EndTime": "2007-03-29T23:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 20000
  },
  {
    "StartTime": "2007-03-30T14:00:00.000Z",
    "EndTime": "2007-03-30T15:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 9000
  },
  {
    "StartTime": "2007-03-30T14:00:00.000Z",
    "EndTime": "2007-03-30T18:50:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-03-30T20:50:00.000Z",
    "EndTime": "2007-03-30T22:50:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-03-30T22:48:00.000Z",
    "EndTime": "2007-03-31T00:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-03-31T10:30:00.000Z",
    "EndTime": "2007-03-31T23:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-04-22T22:07:00.000Z",
    "EndTime": "2007-04-22T22:32:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-05-01T00:00:00.000Z",
    "EndTime": "2007-05-02T09:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-05-07T05:15:00.000Z",
    "EndTime": "2007-05-07T10:15:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-05-08T03:30:00.000Z",
    "EndTime": "2007-05-08T05:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 15000
  },
  {
    "StartTime": "2007-05-08T09:00:00.000Z",
    "EndTime": "2007-05-08T17:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 20000
  },
  {
    "StartTime": "2007-05-08T11:00:00.000Z",
    "EndTime": "2007-05-08T17:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-05-08T11:00:00.000Z",
    "EndTime": "2007-05-08T17:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-05-08T12:53:00.000Z",
    "EndTime": "2007-05-08T17:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 100000
  },
  {
    "StartTime": "2007-05-08T14:04:00.000Z",
    "EndTime": "2007-05-08T17:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-05-10T01:45:00.000Z",
    "EndTime": "2007-05-10T22:45:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-05-10T13:45:00.000Z",
    "EndTime": "2007-05-10T20:15:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-05-10T16:40:00.000Z",
    "EndTime": "2007-05-10T21:15:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-05-24T01:15:00.000Z",
    "EndTime": "2007-05-31T23:59:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-05-24T06:00:00.000Z",
    "EndTime": "2007-05-25T11:33:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 220000
  },
  {
    "StartTime": "2007-05-24T12:55:00.000Z",
    "EndTime": "2007-05-24T13:55:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-05-25T00:15:00.000Z",
    "EndTime": "2007-05-25T20:15:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-05-25T01:00:00.000Z",
    "EndTime": "2007-05-26T13:45:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-05-25T02:00:00.000Z",
    "EndTime": "2007-05-25T05:15:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-05-25T02:15:00.000Z",
    "EndTime": "2007-05-25T09:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-05-26T00:56:00.000Z",
    "EndTime": "2007-05-26T04:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-05-27T22:45:00.000Z",
    "EndTime": "2007-05-28T16:45:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-05-28T05:25:00.000Z",
    "EndTime": "2007-05-28T07:25:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 10000
  },
  {
    "StartTime": "2007-05-29T16:30:00.000Z",
    "EndTime": "2007-05-29T18:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-05-29T18:00:00.000Z",
    "EndTime": "2007-05-29T20:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-01T00:00:00.000Z",
    "EndTime": "2007-06-05T13:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-03T20:40:00.000Z",
    "EndTime": "2007-06-03T23:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-03T21:40:00.000Z",
    "EndTime": "2007-06-04T00:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 15000
  },
  {
    "StartTime": "2007-06-09T18:23:00.000Z",
    "EndTime": "2007-06-09T21:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-10T07:15:00.000Z",
    "EndTime": "2007-06-10T23:45:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-16T10:05:00.000Z",
    "EndTime": "2007-06-16T12:05:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 40000
  },
  {
    "StartTime": "2007-06-17T02:50:00.000Z",
    "EndTime": "2007-06-17T04:50:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-17T11:00:00.000Z",
    "EndTime": "2007-06-17T12:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-17T11:04:00.000Z",
    "EndTime": "2007-06-17T13:04:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-17T11:04:00.000Z",
    "EndTime": "2007-06-17T13:04:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-20T20:00:00.000Z",
    "EndTime": "2007-06-21T04:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-25T05:00:00.000Z",
    "EndTime": "2007-06-25T20:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-26T02:00:00.000Z",
    "EndTime": "2007-06-27T06:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-26T03:30:00.000Z",
    "EndTime": "2007-06-27T18:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-26T07:30:00.000Z",
    "EndTime": "2007-06-26T13:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 500000
  },
  {
    "StartTime": "2007-06-26T09:30:00.000Z",
    "EndTime": "2007-06-26T12:45:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-26T11:36:00.000Z",
    "EndTime": "2007-06-26T11:36:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-26T12:10:00.000Z",
    "EndTime": "2007-06-26T12:10:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-26T13:47:00.000Z",
    "EndTime": "2007-06-26T13:47:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 10000
  },
  {
    "StartTime": "2007-06-26T14:00:00.000Z",
    "EndTime": "2007-06-26T19:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-26T14:06:00.000Z",
    "EndTime": "2007-06-26T14:06:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-26T18:00:00.000Z",
    "EndTime": "2007-06-26T22:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 200000
  },
  {
    "StartTime": "2007-06-26T18:00:00.000Z",
    "EndTime": "2007-06-27T18:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 500000
  },
  {
    "StartTime": "2007-06-26T18:50:00.000Z",
    "EndTime": "2007-06-26T21:50:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-26T20:00:00.000Z",
    "EndTime": "2007-06-26T23:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 750000
  },
  {
    "StartTime": "2007-06-26T20:10:00.000Z",
    "EndTime": "2007-06-26T21:45:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-26T20:10:00.000Z",
    "EndTime": "2007-06-26T21:45:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-26T20:30:00.000Z",
    "EndTime": "2007-06-26T21:45:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-26T21:00:00.000Z",
    "EndTime": "2007-06-27T00:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 5000
  },
  {
    "StartTime": "2007-06-27T00:00:00.000Z",
    "EndTime": "2007-06-27T08:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 10000
  },
  {
    "StartTime": "2007-06-27T00:00:00.000Z",
    "EndTime": "2007-06-27T08:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 750000
  },
  {
    "StartTime": "2007-06-27T00:00:00.000Z",
    "EndTime": "2007-06-27T10:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 500000
  },
  {
    "StartTime": "2007-06-27T00:00:00.000Z",
    "EndTime": "2007-06-27T12:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 1200000
  },
  {
    "StartTime": "2007-06-27T01:30:00.000Z",
    "EndTime": "2007-06-27T17:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-27T03:00:00.000Z",
    "EndTime": "2007-06-27T06:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-27T05:15:00.000Z",
    "EndTime": "2007-06-27T15:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-27T06:00:00.000Z",
    "EndTime": "2007-06-27T10:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-27T07:05:00.000Z",
    "EndTime": "2007-06-27T07:05:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-27T07:05:00.000Z",
    "EndTime": "2007-06-27T07:05:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-27T07:05:00.000Z",
    "EndTime": "2007-06-27T07:05:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-27T07:05:00.000Z",
    "EndTime": "2007-06-27T07:05:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-27T08:00:00.000Z",
    "EndTime": "2007-06-27T15:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-27T08:30:00.000Z",
    "EndTime": "2007-06-27T11:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-28T11:10:00.000Z",
    "EndTime": "2007-06-28T13:10:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-28T12:30:00.000Z",
    "EndTime": "2007-06-28T14:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-28T17:28:00.000Z",
    "EndTime": "2007-06-28T20:28:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 300000
  },
  {
    "StartTime": "2007-06-28T18:00:00.000Z",
    "EndTime": "2007-06-28T23:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 1000000
  },
  {
    "StartTime": "2007-06-28T18:00:00.000Z",
    "EndTime": "2007-06-30T01:15:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-28T19:30:00.000Z",
    "EndTime": "2007-06-29T03:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-28T21:30:00.000Z",
    "EndTime": "2007-06-29T00:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 100000
  },
  {
    "StartTime": "2007-06-28T23:00:00.000Z",
    "EndTime": "2007-06-29T15:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-29T00:00:00.000Z",
    "EndTime": "2007-06-29T12:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-29T05:45:00.000Z",
    "EndTime": "2007-06-29T14:15:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-06-29T08:00:00.000Z",
    "EndTime": "2007-06-29T14:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 100000
  },
  {
    "StartTime": "2007-06-30T06:00:00.000Z",
    "EndTime": "2007-06-30T12:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 20000
  },
  {
    "StartTime": "2007-07-01T00:00:00.000Z",
    "EndTime": "2007-07-31T23:59:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-01T00:00:00.000Z",
    "EndTime": "2007-07-31T23:59:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-01T18:00:00.000Z",
    "EndTime": "2007-07-01T23:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 200000
  },
  {
    "StartTime": "2007-07-02T13:30:00.000Z",
    "EndTime": "2007-07-02T15:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-02T13:30:00.000Z",
    "EndTime": "2007-07-02T18:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-04T22:00:00.000Z",
    "EndTime": "2007-07-05T02:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 10000
  },
  {
    "StartTime": "2007-07-05T08:00:00.000Z",
    "EndTime": "2007-07-05T12:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-05T11:41:00.000Z",
    "EndTime": "2007-07-05T12:41:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-06T03:00:00.000Z",
    "EndTime": "2007-07-06T06:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 200000
  },
  {
    "StartTime": "2007-07-07T10:00:00.000Z",
    "EndTime": "2007-07-07T10:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-08T12:00:00.000Z",
    "EndTime": "2007-07-08T12:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-08T12:00:00.000Z",
    "EndTime": "2007-07-08T12:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-12T09:00:00.000Z",
    "EndTime": "2007-07-12T12:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 100000
  },
  {
    "StartTime": "2007-07-14T18:00:00.000Z",
    "EndTime": "2007-07-14T18:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-16T20:52:00.000Z",
    "EndTime": "2007-07-16T23:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-20T13:30:00.000Z",
    "EndTime": "2007-07-21T20:45:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-20T16:00:00.000Z",
    "EndTime": "2007-07-23T20:15:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-21T03:55:00.000Z",
    "EndTime": "2007-07-21T06:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-21T04:15:00.000Z",
    "EndTime": "2007-07-21T22:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-21T05:30:00.000Z",
    "EndTime": "2007-07-21T10:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-21T06:30:00.000Z",
    "EndTime": "2007-07-22T22:45:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-21T07:15:00.000Z",
    "EndTime": "2007-07-21T09:15:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-21T07:45:00.000Z",
    "EndTime": "2007-07-21T19:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-21T08:00:00.000Z",
    "EndTime": "2007-07-21T18:15:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-21T08:45:00.000Z",
    "EndTime": "2007-07-21T14:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-21T10:45:00.000Z",
    "EndTime": "2007-07-21T18:15:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-21T13:30:00.000Z",
    "EndTime": "2007-07-21T22:45:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-21T17:15:00.000Z",
    "EndTime": "2007-07-22T08:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-21T19:30:00.000Z",
    "EndTime": "2007-07-24T01:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-22T17:30:00.000Z",
    "EndTime": "2007-07-28T05:45:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-23T00:15:00.000Z",
    "EndTime": "2007-07-31T23:45:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-23T10:45:00.000Z",
    "EndTime": "2007-07-29T19:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-24T08:15:00.000Z",
    "EndTime": "2007-07-28T05:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-26T06:30:00.000Z",
    "EndTime": "2007-07-29T03:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-26T08:00:00.000Z",
    "EndTime": "2007-07-26T12:05:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-07-30T11:45:00.000Z",
    "EndTime": "2007-07-31T23:45:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-08-18T15:00:00.000Z",
    "EndTime": "2007-08-19T01:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-08-18T17:00:00.000Z",
    "EndTime": "2007-08-19T03:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-08-18T17:00:00.000Z",
    "EndTime": "2007-08-19T03:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-08-18T17:30:00.000Z",
    "EndTime": "2007-08-19T03:30:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-08-18T21:30:00.000Z",
    "EndTime": "2007-08-19T23:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 5000000
  },
  {
    "StartTime": "2007-09-05T09:00:00.000Z",
    "EndTime": "2007-09-05T12:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-09-09T05:02:00.000Z",
    "EndTime": "2007-09-09T05:58:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-10-10T18:15:00.000Z",
    "EndTime": "2007-10-10T23:10:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-10-10T19:00:00.000Z",
    "EndTime": "2007-10-11T10:00:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  },
  {
    "StartTime": "2007-10-15T08:10:00.000Z",
    "EndTime": "2007-10-15T13:10:00.000Z",
    "State": "TEXAS",
    "EventType": "Flood",
    "DamageProperty": 0
  }
]
`;

exports[`command - tutorial-common 9`] = `
[
  {
    "State": "NORTH DAKOTA",
    "EventType": "Flood",
    "StartTime": "2007-08-01T00:00:00.000Z",
    "EndTime": "2007-08-17T23:59:00.000Z"
  },
  {
    "State": "CALIFORNIA",
    "EventType": "Wildfire",
    "StartTime": "2007-08-01T00:00:00.000Z",
    "EndTime": "2007-08-31T23:59:00.000Z"
  },
  {
    "State": "KENTUCKY",
    "EventType": "Drought",
    "StartTime": "2007-08-01T00:00:00.000Z",
    "EndTime": "2007-08-31T23:59:00.000Z"
  },
  {
    "State": "KENTUCKY",
    "EventType": "Drought",
    "StartTime": "2007-08-01T00:00:00.000Z",
    "EndTime": "2007-08-31T23:59:00.000Z"
  },
  {
    "State": "KENTUCKY",
    "EventType": "Drought",
    "StartTime": "2007-08-01T00:00:00.000Z",
    "EndTime": "2007-08-31T23:59:00.000Z"
  },
  {
    "State": "KENTUCKY",
    "EventType": "Drought",
    "StartTime": "2007-08-01T00:00:00.000Z",
    "EndTime": "2007-08-31T23:59:00.000Z"
  },
  {
    "State": "OHIO",
    "EventType": "Drought",
    "StartTime": "2007-08-01T00:00:00.000Z",
    "EndTime": "2007-08-31T23:59:00.000Z"
  },
  {
    "State": "OHIO",
    "EventType": "Drought",
    "StartTime": "2007-08-01T00:00:00.000Z",
    "EndTime": "2007-08-31T23:59:00.000Z"
  },
  {
    "State": "WEST VIRGINIA",
    "EventType": "Drought",
    "StartTime": "2007-08-01T00:00:00.000Z",
    "EndTime": "2007-08-31T23:59:00.000Z"
  },
  {
    "State": "WEST VIRGINIA",
    "EventType": "Drought",
    "StartTime": "2007-08-01T00:00:00.000Z",
    "EndTime": "2007-08-31T23:59:00.000Z"
  },
  {
    "State": "WEST VIRGINIA",
    "EventType": "Drought",
    "StartTime": "2007-08-01T00:00:00.000Z",
    "EndTime": "2007-08-31T23:59:00.000Z"
  },
  {
    "State": "WEST VIRGINIA",
    "EventType": "Drought",
    "StartTime": "2007-08-01T00:00:00.000Z",
    "EndTime": "2007-08-31T23:59:00.000Z"
  },
  {
    "State": "WEST VIRGINIA",
    "EventType": "Drought",
    "StartTime": "2007-08-01T00:00:00.000Z",
    "EndTime": "2007-08-31T23:59:00.000Z"
  },
  {
    "State": "WEST VIRGINIA",
    "EventType": "Drought",
    "StartTime": "2007-08-01T00:00:00.000Z",
    "EndTime": "2007-08-31T23:59:00.000Z"
  },
  {
    "State": "WEST VIRGINIA",
    "EventType": "Drought",
    "StartTime": "2007-08-01T00:00:00.000Z",
    "EndTime": "2007-08-31T23:59:00.000Z"
  },
  {
    "State": "WEST VIRGINIA",
    "EventType": "Drought",
    "StartTime": "2007-08-01T00:00:00.000Z",
    "EndTime": "2007-08-31T23:59:00.000Z"
  },
  {
    "State": "WEST VIRGINIA",
    "EventType": "Drought",
    "StartTime": "2007-08-01T00:00:00.000Z",
    "EndTime": "2007-08-31T23:59:00.000Z"
  },
  {
    "State": "WEST VIRGINIA",
    "EventType": "Drought",
    "StartTime": "2007-08-01T00:00:00.000Z",
    "EndTime": "2007-08-31T23:59:00.000Z"
  },
  {
    "State": "VIRGINIA",
    "EventType": "Drought",
    "StartTime": "2007-08-01T00:00:00.000Z",
    "EndTime": "2007-08-31T23:59:00.000Z"
  },
  {
    "State": "VIRGINIA",
    "EventType": "Drought",
    "StartTime": "2007-08-01T00:00:00.000Z",
    "EndTime": "2007-08-31T23:59:00.000Z"
  }
]
`;

exports[`command - tutorial-join 1`] = `
[
  {
    "TableName": "StormEvents",
    "Schema": "{\\"Name\\":\\"StormEvents\\",\\"OrderedColumns\\":[{\\"Name\\":\\"StartTime\\",\\"Type\\":\\"System.DateTime\\",\\"CslType\\":\\"datetime\\"},{\\"Name\\":\\"EndTime\\",\\"Type\\":\\"System.DateTime\\",\\"CslType\\":\\"datetime\\"},{\\"Name\\":\\"EpisodeId\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"EventId\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"State\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"EventType\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"InjuriesDirect\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"InjuriesIndirect\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"DeathsDirect\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"DeathsIndirect\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"DamageProperty\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"DamageCrops\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"},{\\"Name\\":\\"Source\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"BeginLocation\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"EndLocation\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"BeginLat\\",\\"Type\\":\\"System.Double\\",\\"CslType\\":\\"real\\"},{\\"Name\\":\\"BeginLon\\",\\"Type\\":\\"System.Double\\",\\"CslType\\":\\"real\\"},{\\"Name\\":\\"EndLat\\",\\"Type\\":\\"System.Double\\",\\"CslType\\":\\"real\\"},{\\"Name\\":\\"EndLon\\",\\"Type\\":\\"System.Double\\",\\"CslType\\":\\"real\\"},{\\"Name\\":\\"EpisodeNarrative\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"EventNarrative\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"StormSummary\\",\\"Type\\":\\"System.Object\\",\\"CslType\\":\\"dynamic\\"}]}",
    "DatabaseName": "Test",
    "Folder": null,
    "DocString": null
  }
]
`;

exports[`command - tutorial-join 2`] = `
[
  {
    "ExtentId": "00000000-0000-0000-0000-000000000000",
    "ItemLoaded": "inproc:00000000-0000-0000-0000-000000000000",
    "Duration": 0,
    "HasErrors": false,
    "OperationId": "00000000-0000-0000-0000-000000000000"
  }
]
`;

exports[`command - tutorial-join 3`] = `
[
  {
    "TableName": "PopulationData",
    "Schema": "{\\"Name\\":\\"PopulationData\\",\\"OrderedColumns\\":[{\\"Name\\":\\"State\\",\\"Type\\":\\"System.String\\",\\"CslType\\":\\"string\\"},{\\"Name\\":\\"Population\\",\\"Type\\":\\"System.Int32\\",\\"CslType\\":\\"int\\"}]}",
    "DatabaseName": "Test",
    "Folder": null,
    "DocString": null
  }
]
`;

exports[`command - tutorial-join 4`] = `
[
  {
    "ExtentId": "00000000-0000-0000-0000-000000000000",
    "ItemLoaded": "inproc:00000000-0000-0000-0000-000000000000",
    "Duration": 0,
    "HasErrors": false,
    "OperationId": "00000000-0000-0000-0000-000000000000"
  }
]
`;

exports[`command - tutorial-join 5`] = `
[
  {
    "State": "KANSAS",
    "PropertyDamagePerCapita": 236
  },
  {
    "State": "OKLAHOMA",
    "PropertyDamagePerCapita": 230
  },
  {
    "State": "NORTH DAKOTA",
    "PropertyDamagePerCapita": 142
  },
  {
    "State": "MISSOURI",
    "PropertyDamagePerCapita": 66
  },
  {
    "State": "ALABAMA",
    "PropertyDamagePerCapita": 60
  },
  {
    "State": "MAINE",
    "PropertyDamagePerCapita": 56
  },
  {
    "State": "MINNESOTA",
    "PropertyDamagePerCapita": 40
  },
  {
    "State": "IOWA",
    "PropertyDamagePerCapita": 39
  },
  {
    "State": "WISCONSIN",
    "PropertyDamagePerCapita": 37
  },
  {
    "State": "CALIFORNIA",
    "PropertyDamagePerCapita": 36
  },
  {
    "State": "OHIO",
    "PropertyDamagePerCapita": 32
  },
  {
    "State": "VERMONT",
    "PropertyDamagePerCapita": 30
  },
  {
    "State": "WASHINGTON",
    "PropertyDamagePerCapita": 23
  },
  {
    "State": "OREGON",
    "PropertyDamagePerCapita": 20
  },
  {
    "State": "GEORGIA",
    "PropertyDamagePerCapita": 20
  },
  {
    "State": "ARKANSAS",
    "PropertyDamagePerCapita": 19
  },
  {
    "State": "TEXAS",
    "PropertyDamagePerCapita": 18
  },
  {
    "State": "NEBRASKA",
    "PropertyDamagePerCapita": 16
  },
  {
    "State": "MICHIGAN",
    "PropertyDamagePerCapita": 16
  },
  {
    "State": "NEW JERSEY",
    "PropertyDamagePerCapita": 15
  },
  {
    "State": "FLORIDA",
    "PropertyDamagePerCapita": 15
  },
  {
    "State": "SOUTH DAKOTA",
    "PropertyDamagePerCapita": 14
  },
  {
    "State": "MONTANA",
    "PropertyDamagePerCapita": 12
  },
  {
    "State": "NEW MEXICO",
    "PropertyDamagePerCapita": 11
  },
  {
    "State": "NEW HAMPSHIRE",
    "PropertyDamagePerCapita": 11
  },
  {
    "State": "MISSISSIPPI",
    "PropertyDamagePerCapita": 7
  },
  {
    "State": "KENTUCKY",
    "PropertyDamagePerCapita": 5
  },
  {
    "State": "ALASKA",
    "PropertyDamagePerCapita": 5
  },
  {
    "State": "WYOMING",
    "PropertyDamagePerCapita": 4
  },
  {
    "State": "NEW YORK",
    "PropertyDamagePerCapita": 4
  },
  {
    "State": "LOUISIANA",
    "PropertyDamagePerCapita": 4
  },
  {
    "State": "INDIANA",
    "PropertyDamagePerCapita": 4
  },
  {
    "State": "SOUTH CAROLINA",
    "PropertyDamagePerCapita": 3
  },
  {
    "State": "PENNSYLVANIA",
    "PropertyDamagePerCapita": 3
  },
  {
    "State": "ARIZONA",
    "PropertyDamagePerCapita": 3
  },
  {
    "State": "WEST VIRGINIA",
    "PropertyDamagePerCapita": 2
  },
  {
    "State": "NORTH CAROLINA",
    "PropertyDamagePerCapita": 2
  },
  {
    "State": "NEVADA",
    "PropertyDamagePerCapita": 2
  },
  {
    "State": "ILLINOIS",
    "PropertyDamagePerCapita": 2
  },
  {
    "State": "UTAH",
    "PropertyDamagePerCapita": 1
  },
  {
    "State": "TENNESSEE",
    "PropertyDamagePerCapita": 1
  },
  {
    "State": "DELAWARE",
    "PropertyDamagePerCapita": 1
  },
  {
    "State": "COLORADO",
    "PropertyDamagePerCapita": 1
  },
  {
    "State": "VIRGINIA",
    "PropertyDamagePerCapita": 0
  },
  {
    "State": "RHODE ISLAND",
    "PropertyDamagePerCapita": 0
  },
  {
    "State": "PUERTO RICO",
    "PropertyDamagePerCapita": 0
  },
  {
    "State": "MASSACHUSETTS",
    "PropertyDamagePerCapita": 0
  },
  {
    "State": "MARYLAND",
    "PropertyDamagePerCapita": 0
  },
  {
    "State": "IDAHO",
    "PropertyDamagePerCapita": 0
  },
  {
    "State": "HAWAII",
    "PropertyDamagePerCapita": 0
  },
  {
    "State": "DISTRICT OF COLUMBIA",
    "PropertyDamagePerCapita": 0
  },
  {
    "State": "CONNECTICUT",
    "PropertyDamagePerCapita": 0
  }
]
`;

exports[`command - tutorial-join 6`] = `
[
  {
    "State": "WYOMING"
  },
  {
    "State": "COLORADO"
  },
  {
    "State": "NEVADA"
  },
  {
    "State": "IDAHO"
  },
  {
    "State": "UTAH"
  },
  {
    "State": "WASHINGTON"
  },
  {
    "State": "OREGON"
  }
]
`;

exports[`command - tutorial-join 7`] = `
[
  {
    "TableName": "StormEvents",
    "DatabaseName": "Test",
    "Folder": null,
    "DocString": null
  }
]
`;

exports[`command - tutorial-join 8`] = `
[]
`;

exports[`sdk query parameters 1`] = `
[
  {
    "print_0": "Your age is: 56"
  }
]
`;