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,634 rows where station_code = "CA002U" 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
8680963 8680963 20251203020344_svaap CA002U 2025-12-04T14:13:27.509Z 2025-12-05T14:21:09.040Z
8677562 8677562 20251203104609_PWvmX CA002U 2025-12-04T14:01:45.447Z 2025-12-05T14:14:34.880Z
8677521 8677521 20251203103314_7EP4x CA002U 2025-12-04T14:01:32.295Z 2025-12-05T14:14:34.867Z
8677466 8677466 20251203101219_32OT4 CA002U 2025-12-04T14:01:19.530Z 2025-12-05T14:14:34.850Z
8677440 8677440 20251203100049_RcjYq CA002U 2025-12-04T14:01:15.275Z 2025-12-05T14:14:34.842Z
8677418 8677418 20251203094713_x0s2o CA002U 2025-12-04T14:01:08.512Z 2025-12-05T14:14:34.835Z
8677395 8677395 20251203093525_BlUS4 CA002U 2025-12-04T14:01:01.659Z 2025-12-05T14:14:34.826Z
8677386 8677386 20251203093019_4yW57 CA002U 2025-12-04T14:00:59.871Z 2025-12-05T14:14:34.823Z
8677334 8677334 20251203085326_6j78P CA002U 2025-12-04T14:00:49.075Z 2025-12-05T14:14:34.804Z
8677321 8677321 20251203084317_G2GBi CA002U 2025-12-04T14:00:46.264Z 2025-12-05T14:14:34.799Z
8677310 8677310 20251203083430_KPVxZ CA002U 2025-12-04T14:00:43.859Z 2025-12-05T14:14:34.796Z
8677286 8677286 20251203081350_ud5mS CA002U 2025-12-04T14:00:36.269Z 2025-12-05T14:14:34.787Z
8670949 8670949 20251201105238_0wt2H CA002U 2025-12-03T14:10:48.894Z 2025-12-05T14:23:57.175Z
8670937 8670937 20251201104857_HYe4S CA002U 2025-12-03T14:10:46.684Z 2025-12-05T14:23:56.599Z
8667733 8667733 20251130033918_rkB24 CA002U 2025-12-02T14:40:11.329Z 2025-12-05T14:44:26.291Z
8667636 8667636 20251130025751_vo4JP CA002U 2025-12-02T14:39:31.503Z 2025-12-05T14:43:46.804Z
8625229 8625229 20251127084155_6dCx3 CA002U 2025-11-28T14:26:31.466Z 2025-12-05T15:05:48.126Z
8625205 8625205 20251127083146_3nANl CA002U 2025-11-28T14:26:25.436Z 2025-12-05T15:05:47.342Z
8625150 8625150 20251127081341_382v2 CA002U 2025-11-28T14:26:18.451Z 2025-12-05T15:05:45.056Z
8625141 8625141 20251127081224_6LhSf CA002U 2025-11-28T14:26:17.940Z 2025-12-05T15:05:42.985Z
8625122 8625122 20251127080831_6XBxi CA002U 2025-11-28T14:26:16.639Z 2025-12-05T15:05:42.546Z
8617833 8617833 20251127103751_UpjBw CA002U 2025-11-28T14:02:32.075Z 2025-12-05T14:54:05.257Z
8617770 8617770 20251127103014_ZUhrj CA002U 2025-11-28T14:02:20.666Z 2025-12-05T14:54:04.270Z
8617324 8617324 20251127090156_qwcL8 CA002U 2025-11-28T14:00:25.950Z 2025-12-05T14:53:42.517Z
8582860 8582860 20251123085714_3wP9r CA002U 2025-11-24T14:34:33.974Z 2025-12-01T15:22:28.674Z
8582787 8582787 20251123083144_8hPkq CA002U 2025-11-24T14:34:30.684Z 2025-12-01T15:22:27.923Z
8582553 8582553 20251123070225_uz4Qd CA002U 2025-11-24T14:34:02.825Z 2025-12-01T15:22:25.152Z
8582521 8582521 20251123065121_khq24 CA002U 2025-11-24T14:33:50.760Z 2025-12-01T15:22:24.804Z
8582506 8582506 20251123063903_fnUsX CA002U 2025-11-24T14:33:46.134Z 2025-12-01T15:22:24.606Z
8582467 8582467 20251123062848_biEsF CA002U 2025-11-24T14:33:39.099Z 2025-12-01T15:22:24.238Z
8582447 8582447 20251123062042_CvRM4 CA002U 2025-11-24T14:33:37.565Z 2025-12-01T15:22:24.013Z
8582418 8582418 20251123060932_3MVAm CA002U 2025-11-24T14:33:35.962Z 2025-12-01T15:22:23.560Z
8582347 8582347 20251123054921_saSBG CA002U 2025-11-24T14:33:30.907Z 2025-12-01T15:22:22.470Z
8582310 8582310 20251123052751_0cvxa CA002U 2025-11-24T14:33:28.856Z 2025-12-01T15:22:21.873Z
8582224 8582224 20251123044650_A217F CA002U 2025-11-24T14:33:23.584Z 2025-12-01T15:22:19.050Z
8582176 8582176 20251123042820_lIjav CA002U 2025-11-24T14:33:20.968Z 2025-12-01T15:22:17.881Z
8582150 8582150 20251123042533_wgxbD CA002U 2025-11-24T14:33:19.675Z 2025-12-01T15:22:17.514Z
8582086 8582086 20251123040302_6gDjd CA002U 2025-11-24T14:33:15.914Z 2025-12-01T15:22:15.798Z
8582049 8582049 20251123035412_uVJ3x CA002U 2025-11-24T14:33:13.636Z 2025-12-01T15:22:14.902Z
8582039 8582039 20251123034837_9iA9q CA002U 2025-11-24T14:33:13.225Z 2025-12-01T15:22:14.515Z
8582005 8582005 20251123033544_uOmqd CA002U 2025-11-24T14:33:03.118Z 2025-12-01T15:22:11.591Z
8581957 8581957 20251123031816_L2sXY CA002U 2025-11-24T14:32:49.786Z 2025-12-01T15:22:04.205Z
8581749 8581749 20251123020613_IduVr CA002U 2025-11-24T14:32:35.765Z 2025-12-01T15:21:27.596Z
8581724 8581724 20251123015424_WSwZk CA002U 2025-11-24T14:32:34.236Z 2025-12-01T15:21:20.143Z
8581677 8581677 20251123013806_3xe6r CA002U 2025-11-24T14:32:31.700Z 2025-12-01T15:21:13.266Z
8581644 8581644 20251123012609_RC0VS CA002U 2025-11-24T14:32:24.370Z 2025-12-01T15:21:11.232Z
8581638 8581638 20251123012253_bmow1 CA002U 2025-11-24T14:32:14.848Z 2025-12-01T15:21:10.778Z
8574416 8574416 20251122063207_TJ5z9 CA002U 2025-11-23T14:43:33.790Z 2025-11-30T15:07:08.291Z
8574406 8574406 20251122062406_2ADy0 CA002U 2025-11-23T14:43:29.781Z 2025-11-30T15:07:08.098Z
8574344 8574344 20251122055340_0irg3 CA002U 2025-11-23T14:43:07.324Z 2025-11-30T15:07:05.074Z
8574311 8574311 20251122054627_P0lH7 CA002U 2025-11-23T14:43:05.388Z 2025-11-30T15:07:04.741Z
8574207 8574207 20251122052534_Y2Jo0 CA002U 2025-11-23T14:42:48.183Z 2025-11-30T15:07:02.534Z
8574201 8574201 20251122052454_Gudtk CA002U 2025-11-23T14:42:47.954Z 2025-11-30T15:07:02.488Z
8461290 8461290 20251114090245_VigYh CA002U 2025-11-15T14:24:06.777Z 2025-11-22T15:23:16.863Z
8326139 8326139 20251030091344_IM0dG CA002U 2025-11-01T12:35:17.611Z 2025-11-07T15:17:43.322Z
8326088 8326088 20251030090605_nJpTL CA002U 2025-11-01T12:35:15.441Z 2025-11-07T15:17:41.717Z
8325705 8325705 20251030081405_Gykdc CA002U 2025-11-01T12:34:23.014Z 2025-11-07T15:17:28.386Z
8325568 8325568 20251030080416_GRRLa CA002U 2025-11-01T12:34:15.474Z 2025-11-07T15:17:25.987Z
8325450 8325450 20251030074849_K61I6 CA002U 2025-11-01T12:34:10.023Z 2025-11-07T15:17:22.618Z
8325418 8325418 20251030074553_ZwLwc CA002U 2025-11-01T12:34:08.453Z 2025-11-07T15:17:22.034Z
8325383 8325383 20251030074024_NqBV6 CA002U 2025-11-01T12:34:06.191Z 2025-11-07T15:17:21.487Z
8325268 8325268 20251030072920_xX6Yk CA002U 2025-11-01T12:33:36.440Z 2025-11-07T15:17:20.040Z
8325128 8325128 20251030071541_1RErI CA002U 2025-11-01T12:33:22.185Z 2025-11-07T15:17:18.331Z
8325093 8325093 20251030071308_eKxx8 CA002U 2025-11-01T12:33:21.319Z 2025-11-07T15:17:17.981Z
8324939 8324939 20251030064839_jKEXs CA002U 2025-11-01T12:33:11.971Z 2025-11-07T15:17:15.731Z
8324915 8324915 20251030064617_TenC4 CA002U 2025-11-01T12:33:10.471Z 2025-11-07T15:17:15.001Z
8324902 8324902 20251030064427_aEXSg CA002U 2025-11-01T12:33:09.766Z 2025-11-07T15:17:14.738Z
8324804 8324804 20251030063023_VmBNP CA002U 2025-11-01T12:33:04.435Z 2025-11-07T15:17:13.357Z
8324776 8324776 20251030062600_QhRcs CA002U 2025-11-01T12:33:03.211Z 2025-11-07T15:17:12.968Z
8324719 8324719 20251030061857_DYU31 CA002U 2025-11-01T12:32:58.785Z 2025-11-07T15:17:12.105Z
8324672 8324672 20251030061323_2eM2t CA002U 2025-11-01T12:32:39.226Z 2025-11-07T15:17:11.319Z
8324670 8324670 20251030061309_DOpqa CA002U 2025-11-01T12:32:38.810Z 2025-11-07T15:17:11.230Z
8324640 8324640 20251030060440_R8IPp CA002U 2025-11-01T12:32:33.648Z 2025-11-07T15:17:10.631Z
8324635 8324635 20251030060432_Xe4Q1 CA002U 2025-11-01T12:32:33.571Z 2025-11-07T15:17:10.606Z
8324558 8324558 20251030055430_rla2b CA002U 2025-11-01T12:32:26.437Z 2025-11-07T15:17:08.874Z
8324065 8324065 20251030052310_OxAaP CA002U 2025-11-01T12:31:39.758Z 2025-11-07T15:16:57.967Z
8324011 8324011 20251030051841_fTJBx CA002U 2025-11-01T12:31:38.078Z 2025-11-07T15:16:51.558Z
8323952 8323952 20251030051653_bjT55 CA002U 2025-11-01T12:31:34.453Z 2025-11-07T15:16:49.223Z
8323940 8323940 20251030051601_SMQv3 CA002U 2025-11-01T12:31:33.335Z 2025-11-07T15:16:45.744Z
8323658 8323658 20251030050504_J2bPv CA002U 2025-11-01T12:31:22.011Z 2025-11-07T15:16:17.948Z
8323569 8323569 20251030050119_skpSK CA002U 2025-11-01T12:30:51.964Z 2025-11-07T15:16:10.298Z
8322902 8322902 20251030043015_wzUGO CA002U 2025-11-01T12:30:00.988Z 2025-11-07T15:15:49.955Z
8322647 8322647 20251030041959_1O9Ha CA002U 2025-11-01T12:29:34.539Z 2025-11-07T15:15:42.403Z
8322198 8322198 20251030040210_u305R CA002U 2025-11-01T12:28:47.226Z 2025-11-07T15:15:37.507Z
8322176 8322176 20251030040039_zd2DI CA002U 2025-11-01T12:28:45.929Z 2025-11-07T15:15:37.210Z
8322139 8322139 20251030035836_WhXPd CA002U 2025-11-01T12:28:40.997Z 2025-11-07T15:15:36.660Z
8321374 8321374 20251030033322_NPthT CA002U 2025-11-01T12:27:43.827Z 2025-11-07T15:15:29.038Z
8313812 8313812 20251030002559_7onBq CA002U 2025-10-31T12:38:11.413Z 2025-11-07T15:13:08.016Z
8307580 8307580 20251029095547_LMuFL CA002U 2025-10-31T12:28:06.629Z 2025-11-06T15:15:40.165Z
8307204 8307204 20251029092347_Jk0rq CA002U 2025-10-31T12:27:03.829Z 2025-11-06T15:15:26.678Z
8306681 8306681 20251029083158_jyoaT CA002U 2025-10-31T12:26:01.647Z 2025-11-06T15:15:14.221Z
8306656 8306656 20251029083025_kyXl2 CA002U 2025-10-31T12:25:59.702Z 2025-11-06T15:15:14.095Z
8306069 8306069 20251029072022_kkK9U CA002U 2025-10-31T12:24:22.278Z 2025-11-06T15:14:57.462Z
8305978 8305978 20251029070307_mAHui CA002U 2025-10-31T12:24:12.013Z 2025-11-06T15:14:55.031Z
8304955 8304955 20251029030028_PzV3a CA002U 2025-10-31T12:17:50.481Z 2025-11-06T15:13:37.199Z
8304831 8304831 20251029014444_Gi12q CA002U 2025-10-31T12:16:43.954Z 2025-11-06T15:13:08.066Z
8304776 8304776 20251029000811_19fqn CA002U 2025-10-31T12:15:41.452Z 2025-11-06T15:12:36.896Z
8300746 8300746 20251029101404_20UWJ CA002U 2025-10-30T12:54:08.692Z 2025-11-06T15:15:45.613Z
8300740 8300740 20251029101040_3Prrc CA002U 2025-10-30T12:54:04.534Z 2025-11-06T15:15:45.277Z
8300728 8300728 20251029095710_LXLPK CA002U 2025-10-30T12:54:04.127Z 2025-11-06T15:15:40.454Z

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