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

4,553 rows where station_code = "CA000L" 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
8682415 8682415 20251203052808_zwHyO CA000L 2025-12-04T14:17:08.037Z 2025-12-06T14:29:01.075Z
8658709 8658709 20251201084018_fiwGF CA000L 2025-12-02T14:00:23.262Z 2025-12-02T14:00:23.262Z
8658694 8658694 20251201080441_mYAe8 CA000L 2025-12-02T14:00:18.786Z 2025-12-06T14:29:53.332Z
8648374 8648374 20251129074032_2S2wk CA000L 2025-11-30T14:30:06.989Z 2025-12-06T14:57:36.476Z
8648271 8648271 20251129071806_ejL1N CA000L 2025-11-30T14:30:00.539Z 2025-12-06T14:57:28.563Z
8639170 8639170 20251129103640_56zIP CA000L 2025-11-30T14:04:01.749Z 2025-12-06T14:43:35.534Z
8639021 8639021 20251129101719_F2vgV CA000L 2025-11-30T14:03:30.794Z 2025-12-06T14:43:08.297Z
8638855 8638855 20251129095538_pcpRz CA000L 2025-11-30T14:02:36.797Z 2025-12-06T14:43:02.688Z
8638495 8638495 20251129085709_iKwPK CA000L 2025-11-30T14:01:11.869Z 2025-12-06T14:42:52.703Z
8638460 8638460 20251129085014_3Kb6q CA000L 2025-11-30T14:01:01.100Z 2025-12-06T14:42:51.744Z
8638440 8638440 20251129084710_Uw8aP CA000L 2025-11-30T14:00:55.659Z 2025-12-06T14:42:51.152Z
8637839 8637839 20251128065020_VgOSK CA000L 2025-11-29T14:27:54.949Z 2025-12-06T15:04:04.768Z
8592601 8592601 20251124084016_BBwon CA000L 2025-11-25T14:27:18.409Z 2025-12-02T15:13:05.514Z
8583194 8583194 20251124095706_R5jPp CA000L 2025-11-25T14:00:41.642Z 2025-12-02T15:05:26.688Z
8554473 8554473 20251120095453_XpkYB CA000L 2025-11-22T14:35:29.979Z 2025-11-28T14:58:52.066Z
8554223 8554223 20251120090653_MZQOP CA000L 2025-11-22T14:34:52.958Z 2025-11-28T14:58:48.578Z
8554123 8554123 20251120083812_DkZON CA000L 2025-11-22T14:34:47.260Z 2025-11-28T14:58:46.916Z
8550373 8550373 20251120233950_rP7Oj CA000L 2025-11-22T14:20:50.085Z 2025-11-29T14:54:26.803Z
8539002 8539002 20251119225436_Y1IXu CA000L 2025-11-21T14:34:42.557Z 2025-11-28T14:55:40.727Z
8529550 8529550 20251119093952_LK3RD CA000L 2025-11-20T14:45:01.943Z 2025-11-27T15:13:32.847Z
8529443 8529443 20251119081956_XBOao CA000L 2025-11-20T14:44:56.020Z 2025-11-27T15:13:29.421Z
8529397 8529397 20251119074631_XXheF CA000L 2025-11-20T14:44:54.443Z 2025-11-27T15:13:28.885Z
8529391 8529391 20251119073905_8BYIR CA000L 2025-11-20T14:44:54.293Z 2025-11-27T15:13:28.762Z
8529367 8529367 20251119071248_a6FbR CA000L 2025-11-20T14:44:53.012Z 2025-11-27T15:13:28.444Z
8529337 8529337 20251119070024_WGjNO CA000L 2025-11-20T14:44:51.576Z 2025-11-27T15:13:27.157Z
8528805 8528805 20251119050825_GsqdR CA000L 2025-11-20T14:43:53.655Z 2025-11-27T15:13:12.794Z
8527021 8527021 20251119004722_zaR7n CA000L 2025-11-20T14:40:32.879Z 2025-11-27T15:12:05.939Z
8515818 8515818 20251118051039_ESNB3 CA000L 2025-11-19T14:39:59.076Z 2025-11-26T15:08:04.414Z
8470521 8470521 20251115051031_R4wpy CA000L 2025-11-16T14:22:59.467Z 2025-11-23T15:18:13.743Z
8470477 8470477 20251115050623_TH8EM CA000L 2025-11-16T14:22:55.200Z 2025-11-23T15:18:12.622Z
8470246 8470246 20251115043954_PSIhI CA000L 2025-11-16T14:22:15.031Z 2025-11-23T15:18:01.625Z
8469147 8469147 20251115020645_2K3IN CA000L 2025-11-16T14:19:26.165Z 2025-11-23T15:17:35.038Z
8468892 8468892 20251115012540_QQ3ix CA000L 2025-11-16T14:18:44.473Z 2025-11-23T15:17:28.032Z
8461930 8461930 20251114102022_8bHoa CA000L 2025-11-15T14:25:14.812Z 2025-11-22T15:23:45.740Z
8460448 8460448 20251114070317_Rja4w CA000L 2025-11-15T14:22:07.674Z 2025-11-22T15:22:38.199Z
8458961 8458961 20251114022229_Nwi2U CA000L 2025-11-15T14:18:20.455Z 2025-11-22T15:21:29.678Z
8391975 8391975 20251107041343_0xS6k CA000L 2025-11-08T14:16:48.136Z 2025-11-15T15:00:40.831Z
8390862 8390862 20251107013536_0UrtM CA000L 2025-11-08T14:12:40.833Z 2025-11-15T15:00:12.094Z
8390359 8390359 20251107001301_3SNDq CA000L 2025-11-08T14:10:40.654Z 2025-11-15T15:00:01.365Z
8386660 8386660 20251106061027_NNdZv CA000L 2025-11-07T14:11:59.749Z 2025-11-14T15:08:44.665Z
8380554 8380554 20251105022155_tCM28 CA000L 2025-11-06T14:12:07.697Z 2025-11-13T15:14:56.459Z
8372905 8372905 20251104104337_3Gfmq CA000L 2025-11-05T14:19:38.706Z 2025-11-12T15:11:58.865Z
8370720 8370720 20251104025326_fylq8 CA000L 2025-11-05T14:12:10.144Z 2025-11-12T15:10:49.953Z
8370379 8370379 20251104014909_NwCpa CA000L 2025-11-05T14:10:42.668Z 2025-11-12T15:10:35.975Z
8358353 8358353 20251102082926_c0q6w CA000L 2025-11-03T14:44:47.420Z 2025-11-10T15:10:15.587Z
8357897 8357897 20251102073311_dG3gP CA000L 2025-11-03T14:43:48.437Z 2025-11-03T14:43:48.437Z
8356748 8356748 20251102030000_nSMPW CA000L 2025-11-03T14:41:54.200Z 2025-11-10T15:08:14.506Z
8345787 8345787 20251101072247_0TgET CA000L 2025-11-02T14:43:28.717Z 2025-11-09T15:04:32.560Z
8345741 8345741 20251101071743_LAWqw CA000L 2025-11-02T14:43:22.851Z 2025-11-02T14:43:22.851Z
8345524 8345524 20251101065018_uOs6F CA000L 2025-11-02T14:43:06.184Z 2025-11-09T15:04:15.559Z
8345477 8345477 20251101064610_uOzwr CA000L 2025-11-02T14:43:03.214Z 2025-11-09T15:04:11.605Z
8319684 8319684 20251030022044_239Es CA000L 2025-11-01T12:25:08.188Z 2025-11-07T15:13:44.835Z
8307893 8307893 20251029101942_Up33O CA000L 2025-10-31T12:28:34.906Z 2025-11-06T15:15:50.084Z
8307048 8307048 20251029090501_8Z6dx CA000L 2025-10-31T12:26:52.695Z 2025-11-06T15:15:23.958Z
8306970 8306970 20251029085825_FuFZS CA000L 2025-10-31T12:26:31.431Z 2025-11-06T15:15:20.918Z
8306765 8306765 20251029083702_BpSTd CA000L 2025-10-31T12:26:14.260Z 2025-11-06T15:15:15.153Z
8306620 8306620 20251029082632_uyhMi CA000L 2025-10-31T12:25:55.460Z 2025-11-06T15:15:13.843Z
8306236 8306236 20251029074101_VUdxn CA000L 2025-10-31T12:24:51.446Z 2025-11-06T15:15:01.033Z
8306225 8306225 20251029073948_hLdvU CA000L 2025-10-31T12:24:50.331Z 2025-11-06T15:15:00.514Z
8305936 8305936 20251029065923_ZvnOp CA000L 2025-10-31T12:23:58.617Z 2025-11-06T15:14:54.513Z
8305918 8305918 20251029065719_rttQo CA000L 2025-10-31T12:23:54.391Z 2025-11-06T15:14:53.805Z
8305800 8305800 20251029063744_l2IvA CA000L 2025-10-31T12:23:37.264Z 2025-11-06T15:14:49.108Z
8305760 8305760 20251029062905_ohuOh CA000L 2025-10-31T12:23:15.995Z 2025-11-06T15:14:48.723Z
8305683 8305683 20251029061807_abQ9m CA000L 2025-10-31T12:23:06.214Z 2025-11-06T15:14:47.677Z
8305530 8305530 20251029054446_2Tfqd CA000L 2025-10-31T12:22:50.390Z 2025-11-06T15:14:41.800Z
8305458 8305458 20251029052952_g1Esc CA000L 2025-10-31T12:22:23.410Z 2025-11-06T15:14:39.457Z
8304945 8304945 20251029025736_mAZCB CA000L 2025-10-31T12:17:45.955Z 2025-11-06T15:13:36.475Z
8293061 8293061 20251028091149_T3Rfo CA000L 2025-10-30T12:38:40.338Z 2025-11-05T15:23:43.706Z
8292916 8292916 20251028090203_63iYM CA000L 2025-10-30T12:38:33.991Z 2025-11-05T15:23:40.283Z
8292188 8292188 20251028080602_UD5oP CA000L 2025-10-30T12:37:21.285Z 2025-11-05T15:23:27.591Z
8291674 8291674 20251028072336_axV5q CA000L 2025-10-30T12:36:17.591Z 2025-11-05T15:23:15.344Z
8291311 8291311 20251028064043_UhT2W CA000L 2025-10-30T12:35:36.641Z 2025-11-05T15:23:12.075Z
8284406 8284406 20251028044105_Ro2xL CA000L 2025-10-29T12:45:32.475Z 2025-11-05T15:22:46.582Z
8284361 8284361 20251028043830_Q6SF8 CA000L 2025-10-29T12:45:30.782Z 2025-11-05T15:22:44.936Z
8283090 8283090 20251028031307_aaEeS CA000L 2025-10-29T12:43:42.872Z 2025-11-05T15:22:01.929Z
8282804 8282804 20251028024911_3ngOW CA000L 2025-10-29T12:43:28.757Z 2025-11-05T15:21:50.264Z
8282048 8282048 20251028015744_OX06D CA000L 2025-10-29T12:42:06.043Z 2025-10-29T12:42:06.043Z
8281850 8281850 20251028014642_quBta CA000L 2025-10-29T12:41:55.642Z 2025-11-05T15:21:34.730Z
8281519 8281519 20251028012454_V8RbD CA000L 2025-10-29T12:41:40.061Z 2025-11-05T15:21:31.754Z
8277233 8277233 20251027100834_G2tv3 CA000L 2025-10-29T12:31:27.142Z 2025-11-04T15:47:38.869Z
8276465 8276465 20251027084717_Zh9sC CA000L 2025-10-29T12:29:57.291Z 2025-11-04T15:46:57.002Z
8276382 8276382 20251027084150_zMty6 CA000L 2025-10-29T12:29:53.360Z 2025-11-04T15:46:55.486Z
8276172 8276172 20251027081804_7NCSx CA000L 2025-10-29T12:29:11.014Z 2025-11-04T15:46:50.559Z
8276043 8276043 20251027080136_5KTO3 CA000L 2025-10-29T12:29:04.198Z 2025-11-04T15:46:47.982Z
8275934 8275934 20251027075048_31u0Y CA000L 2025-10-29T12:28:59.013Z 2025-11-04T15:46:32.269Z
8275622 8275622 20251027071501_DWy8S CA000L 2025-10-29T12:28:12.341Z 2025-11-04T15:46:09.761Z
8275523 8275523 20251027070138_NYrYb CA000L 2025-10-29T12:28:05.261Z 2025-11-04T15:46:07.592Z
8275364 8275364 20251027063638_3IhJg CA000L 2025-10-29T12:27:50.759Z 2025-11-04T15:46:03.049Z
8275200 8275200 20251027061316_2EK3l CA000L 2025-10-29T12:27:18.828Z 2025-11-04T15:45:58.479Z
8274061 8274061 20251027045724_mmSBE CA000L 2025-10-29T12:25:12.128Z 2025-11-04T15:45:07.657Z
8273909 8273909 20251027044826_KOLB9 CA000L 2025-10-29T12:24:48.654Z 2025-11-04T15:45:05.156Z
8273355 8273355 20251027041755_q8gUQ CA000L 2025-10-29T12:23:36.789Z 2025-11-04T15:44:54.290Z
8273337 8273337 20251027041202_OefCK CA000L 2025-10-29T12:23:29.400Z 2025-11-04T15:44:52.087Z
8273334 8273334 20251027041202_hsgU2 CA000L 2025-10-29T12:23:29.120Z 2025-11-04T15:44:52.010Z
8273141 8273141 20251027031757_G1VgQ CA000L 2025-10-29T12:21:16.693Z 2025-11-04T15:44:10.280Z
8265704 8265704 20251026083127_gBIYu CA000L 2025-10-28T12:38:41.866Z 2025-11-03T15:17:04.987Z
8265680 8265680 20251026083002_f8I6R CA000L 2025-10-28T12:38:39.649Z 2025-11-03T15:17:04.974Z
8265618 8265618 20251026082459_VIBnl CA000L 2025-10-28T12:38:38.209Z 2025-11-03T15:17:04.888Z
8264911 8264911 20251026064557_oFt4M CA000L 2025-10-28T12:37:37.197Z 2025-11-03T15:17:00.816Z
8264777 8264777 20251026061921_KFEXA CA000L 2025-10-28T12:37:20.617Z 2025-11-03T15:17:00.154Z

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