home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

2,332 rows where station_code = "CA002Q" sorted by created_at descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: created_at (date), updated_at (date)

Link rowid meteor_unique_trajectory_identifier station_code created_at ▲ updated_at
5964216 5964216 20250121032449_bDGkE CA002Q 2025-01-22T14:14:32.386Z 2025-01-29T14:36:23.659Z
5964180 5964180 20250121025108_eZIaC CA002Q 2025-01-22T14:14:20.524Z 2025-01-29T14:36:20.895Z
5964107 5964107 20250121020917_XVwSl CA002Q 2025-01-22T14:13:48.589Z 2025-01-29T14:36:17.940Z
5963802 5963802 20250120231653_aGtEb CA002Q 2025-01-22T14:12:28.188Z 2025-01-29T14:36:13.202Z
5960578 5960578 20250121042259_vXlsY CA002Q 2025-01-22T14:00:31.444Z 2025-01-22T14:00:31.444Z
5496036 5496036 20241106224442_LqntB CA002Q 2024-11-08T14:11:25.690Z 2024-11-15T14:24:54.980Z
5491443 5491443 20241106031656_IWAM2 CA002Q 2024-11-07T14:16:09.086Z 2024-11-14T14:23:25.699Z
5491094 5491094 20241106015436_HVOSH CA002Q 2024-11-07T14:15:18.453Z 2024-11-14T14:23:23.716Z
5490867 5490867 20241106010046_Wqrnp CA002Q 2024-11-07T14:15:01.214Z 2024-11-14T14:23:22.669Z
5490756 5490756 20241106003058_y6Cvx CA002Q 2024-11-07T14:14:50.442Z 2024-11-14T14:23:21.625Z
5490659 5490659 20241105235859_lffEh CA002Q 2024-11-07T14:14:25.365Z 2024-11-14T14:23:21.174Z
5490423 5490423 20241105224145_628ZW CA002Q 2024-11-07T14:14:00.302Z 2024-11-14T14:23:19.601Z
5485759 5485759 20241106072109_HZ2aJ CA002Q 2024-11-07T14:00:31.067Z 2024-11-15T14:24:23.073Z
5478840 5478840 20241104063950_R2pH3 CA002Q 2024-11-05T14:18:54.911Z 2024-11-12T14:28:17.086Z
5478809 5478809 20241104061932_1961T CA002Q 2024-11-05T14:18:52.829Z 2024-11-12T14:28:17.036Z
5478784 5478784 20241104060331_DQawB CA002Q 2024-11-05T14:18:50.399Z 2024-11-12T14:28:16.994Z
5478775 5478775 20241104055911_oZHS9 CA002Q 2024-11-05T14:18:49.363Z 2024-11-12T14:28:16.965Z
5478755 5478755 20241104054419_5W2S2 CA002Q 2024-11-05T14:18:47.217Z 2024-11-12T14:28:16.905Z
5478700 5478700 20241104051221_3k2Vr CA002Q 2024-11-05T14:18:43.129Z 2024-11-12T14:28:16.581Z
5478690 5478690 20241104050815_pL1kw CA002Q 2024-11-05T14:18:41.955Z 2024-11-12T14:28:16.563Z
5478686 5478686 20241104050721_u5Xrv CA002Q 2024-11-05T14:18:41.783Z 2024-11-12T14:28:16.561Z
5478651 5478651 20241104045136_fWHb2 CA002Q 2024-11-05T14:18:37.797Z 2024-11-12T14:28:16.461Z
5478650 5478650 20241104045111_ow52B CA002Q 2024-11-05T14:18:37.615Z 2024-11-12T14:28:16.461Z
5478642 5478642 20241104044946_0tz3q CA002Q 2024-11-05T14:18:37.062Z 2024-11-12T14:28:16.458Z
5478634 5478634 20241104044716_1Dfyv CA002Q 2024-11-05T14:18:36.464Z 2024-11-12T14:28:16.433Z
5478616 5478616 20241104044357_WEKAe CA002Q 2024-11-05T14:18:34.660Z 2024-11-12T14:28:16.405Z
5478358 5478358 20241104035538_65i9L CA002Q 2024-11-05T14:18:15.420Z 2024-11-12T14:28:15.011Z
5478199 5478199 20241104033509_9vggK CA002Q 2024-11-05T14:18:03.507Z 2024-11-12T14:28:14.545Z
5478139 5478139 20241104032511_8IrNt CA002Q 2024-11-05T14:17:58.570Z 2024-11-12T14:28:14.428Z
5478081 5478081 20241104031844_23r23 CA002Q 2024-11-05T14:17:53.127Z 2024-11-12T14:28:14.158Z
5477992 5477992 20241104030505_ILOpD CA002Q 2024-11-05T14:17:43.314Z 2024-11-12T14:28:13.738Z
5476919 5476919 20241104004217_jT6gS CA002Q 2024-11-05T14:16:12.389Z 2024-11-12T14:28:07.892Z
5470352 5470352 20241104073055_OtAKT CA002Q 2024-11-05T14:00:21.064Z 2024-11-13T14:27:21.810Z
5470328 5470328 20241104071131_KLXNg CA002Q 2024-11-05T14:00:15.747Z 2024-11-13T14:27:21.741Z
5451903 5451903 20241101012352_J83av CA002Q 2024-11-02T12:18:05.141Z 2024-11-09T14:24:26.618Z
5451164 5451164 20241031225500_k0h2Q CA002Q 2024-11-02T12:16:40.664Z 2024-11-09T14:24:22.052Z
5441982 5441982 20241030001245_vwG7l CA002Q 2024-11-01T12:19:16.008Z 2024-11-07T14:26:44.481Z
5433087 5433087 20241029063559_6cJeL CA002Q 2024-10-31T12:21:45.401Z 2024-11-06T14:27:30.000Z
5433085 5433085 20241029063122_h5aDT CA002Q 2024-10-31T12:21:45.366Z 2024-11-06T14:27:29.997Z
5433083 5433083 20241029062619_zyG0J CA002Q 2024-10-31T12:21:45.317Z 2024-11-06T14:27:29.985Z
5433039 5433039 20241029055201_Qdc1I CA002Q 2024-10-31T12:21:44.037Z 2024-11-06T14:27:29.730Z
5433028 5433028 20241029054844_3wHEx CA002Q 2024-10-31T12:21:43.460Z 2024-11-06T14:27:29.643Z
5433025 5433025 20241029054700_uBC62 CA002Q 2024-10-31T12:21:43.294Z 2024-11-06T14:27:29.622Z
5432999 5432999 20241029054058_fJ0En CA002Q 2024-10-31T12:21:42.551Z 2024-11-06T14:27:29.515Z
5432968 5432968 20241029053052_G5jUD CA002Q 2024-10-31T12:21:41.450Z 2024-11-06T14:27:29.400Z
5432928 5432928 20241029051812_DsQEX CA002Q 2024-10-31T12:21:39.156Z 2024-11-06T14:27:29.306Z
5432822 5432822 20241029045054_wEAtF CA002Q 2024-10-31T12:21:36.142Z 2024-11-06T14:27:28.814Z
5432560 5432560 20241029035346_0LhJv CA002Q 2024-10-31T12:21:27.072Z 2024-11-06T14:27:27.839Z
5432528 5432528 20241029034640_jBmjp CA002Q 2024-10-31T12:21:26.235Z 2024-11-06T14:27:27.784Z
5432492 5432492 20241029034143_emNZP CA002Q 2024-10-31T12:21:24.561Z 2024-11-06T14:27:27.638Z
5432490 5432490 20241029034129_2Erhu CA002Q 2024-10-31T12:21:24.373Z 2024-11-06T14:27:27.616Z
5432476 5432476 20241029033826_4njQH CA002Q 2024-10-31T12:21:24.015Z 2024-11-06T14:27:27.604Z
5432373 5432373 20241029032407_B9eZr CA002Q 2024-10-31T12:21:19.867Z 2024-11-06T14:27:26.772Z
5432001 5432001 20241029022901_7sX01 CA002Q 2024-10-31T12:20:55.940Z 2024-11-06T14:27:25.684Z
5431899 5431899 20241029021357_nnb4o CA002Q 2024-10-31T12:20:47.911Z 2024-11-06T14:27:25.204Z
5431813 5431813 20241029020133_rDfxR CA002Q 2024-10-31T12:20:41.829Z 2024-11-06T14:27:24.933Z
5431786 5431786 20241029015811_BVp6u CA002Q 2024-10-31T12:20:38.841Z 2024-11-06T14:27:24.838Z
5431724 5431724 20241029015207_V68dU CA002Q 2024-10-31T12:20:34.938Z 2024-11-06T14:27:24.633Z
5431715 5431715 20241029015109_vkOZA CA002Q 2024-10-31T12:20:34.375Z 2024-11-06T14:27:24.606Z
5431646 5431646 20241029014129_HbDoI CA002Q 2024-10-31T12:20:28.395Z 2024-11-06T14:27:24.362Z
5431451 5431451 20241029011446_GqVhu CA002Q 2024-10-31T12:20:10.171Z 2024-11-06T14:27:23.768Z
5430619 5430619 20241028231240_zayqC CA002Q 2024-10-31T12:18:43.665Z 2024-11-06T14:27:20.730Z
5430589 5430589 20241028231013_XBaoS CA002Q 2024-10-31T12:18:41.157Z 2024-11-06T14:27:20.621Z
5430557 5430557 20241028230357_KWtcg CA002Q 2024-10-31T12:18:35.712Z 2024-11-06T14:27:20.588Z
5430538 5430538 20241028225730_r243I CA002Q 2024-10-31T12:18:33.925Z 2024-11-06T14:27:20.450Z
5430530 5430530 20241028225549_8ZiPF CA002Q 2024-10-31T12:18:33.091Z 2024-11-06T14:27:20.398Z
5423186 5423186 20241029075520_klRdt CA002Q 2024-10-31T12:00:31.939Z 2024-11-07T14:26:24.311Z
5423166 5423166 20241029073832_tvLzs CA002Q 2024-10-31T12:00:27.328Z 2024-11-07T14:26:24.169Z
5423014 5423014 20241027064106_7Pvr4 CA002Q 2024-10-30T12:23:18.878Z 2024-11-04T14:29:07.326Z
5421456 5421456 20241028064121_f1LV3 CA002Q 2024-10-30T12:19:56.956Z 2024-11-05T14:27:18.757Z
5421443 5421443 20241028063927_cdsZl CA002Q 2024-10-30T12:19:56.449Z 2024-11-05T14:27:18.711Z
5421362 5421362 20241028060723_Ue1mj CA002Q 2024-10-30T12:19:52.648Z 2024-11-05T14:27:18.382Z
5421358 5421358 20241028060700_hpR7d CA002Q 2024-10-30T12:19:52.523Z 2024-11-05T14:27:18.379Z
5421347 5421347 20241028060338_TkcIA CA002Q 2024-10-30T12:19:52.307Z 2024-11-05T14:27:18.308Z
5421198 5421198 20241028050420_gZjU1 CA002Q 2024-10-30T12:19:42.331Z 2024-11-05T14:27:17.759Z
5421156 5421156 20241028044853_ZXeoY CA002Q 2024-10-30T12:19:38.910Z 2024-11-05T14:27:17.533Z
5421100 5421100 20241028043244_KjAA6 CA002Q 2024-10-30T12:19:35.817Z 2024-11-05T14:27:17.346Z
5421094 5421094 20241028043043_mF39T CA002Q 2024-10-30T12:19:35.622Z 2024-11-05T14:27:17.328Z
5420997 5420997 20241028041148_KLAoS CA002Q 2024-10-30T12:19:31.426Z 2024-11-05T14:27:16.906Z
5420991 5420991 20241028041015_NB9gR CA002Q 2024-10-30T12:19:31.216Z 2024-11-05T14:27:16.892Z
5420987 5420987 20241028040925_18sKX CA002Q 2024-10-30T12:19:31.155Z 2024-11-05T14:27:16.891Z
5420963 5420963 20241028040427_6tvK4 CA002Q 2024-10-30T12:19:30.018Z 2024-11-05T14:27:16.808Z
5420945 5420945 20241028040143_YDvCy CA002Q 2024-10-30T12:19:27.638Z 2024-11-05T14:27:16.751Z
5420867 5420867 20241028034657_AHGSk CA002Q 2024-10-30T12:19:23.286Z 2024-11-05T14:27:16.610Z
5420819 5420819 20241028034042_2DD8x CA002Q 2024-10-30T12:19:20.716Z 2024-11-05T14:27:16.465Z
5420627 5420627 20241028030937_M2Feb CA002Q 2024-10-30T12:19:05.634Z 2024-11-05T14:27:15.945Z
5413564 5413564 20241028102209_FeJ1c CA002Q 2024-10-30T12:03:30.090Z 2024-11-06T14:27:06.584Z
5413396 5413396 20241028095249_YooTP CA002Q 2024-10-30T12:02:55.903Z 2024-11-06T14:27:05.585Z
5413393 5413393 20241028095248_WA9Yf CA002Q 2024-10-30T12:02:55.450Z 2024-11-06T14:27:05.582Z
5413289 5413289 20241028092955_7lj4N CA002Q 2024-10-30T12:02:34.766Z 2024-11-06T14:27:05.178Z
5413241 5413241 20241028091755_hJa6k CA002Q 2024-10-30T12:02:21.534Z 2024-11-06T14:27:05.074Z
5413214 5413214 20241028091051_cNhhX CA002Q 2024-10-30T12:02:16.737Z 2024-11-06T14:27:04.902Z
5412906 5412906 20241028080343_U1ffk CA002Q 2024-10-30T12:01:07.699Z 2024-11-06T14:27:03.576Z
5412883 5412883 20241028075952_c7k1O CA002Q 2024-10-30T12:01:04.309Z 2024-11-06T14:27:03.465Z
5412817 5412817 20241028074104_kZCd5 CA002Q 2024-10-30T12:00:50.427Z 2024-11-06T14:27:02.839Z
5412810 5412810 20241028073920_zuuLI CA002Q 2024-10-30T12:00:47.316Z 2024-11-06T14:27:02.775Z
5412783 5412783 20241028073301_lpH7K CA002Q 2024-10-30T12:00:39.856Z 2024-11-06T14:27:02.567Z
5412743 5412743 20241028071813_4pebZ CA002Q 2024-10-30T12:00:31.522Z 2024-11-06T14:27:02.083Z
5412710 5412710 20241028070951_b0v33 CA002Q 2024-10-30T12:00:25.914Z 2024-11-06T14:27:01.788Z
5412640 5412640 20241028065451_jz7BI CA002Q 2024-10-30T12:00:11.408Z 2024-11-06T14:27:01.470Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE participating_station
(
    meteor_unique_trajectory_identifier text     NOT NULL,
    station_code                        text     NOT NULL,
    created_at                          datetime NOT NULL DEFAULT (
        strftime(
                '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc'
            )
        ),
    updated_at                          datetime NOT NULL DEFAULT (
        strftime(
                '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc'
            )
        ),
    FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier),
    FOREIGN KEY (station_code) REFERENCES station (code),
    UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE
);
CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier);
CREATE INDEX participating_station_created_at_index ON participating_station (created_at);
CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network