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

3,520 rows where station_code = "CA0032" 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
8682628 8682628 20251203055252_FlAdG CA0032 2025-12-04T14:17:44.843Z 2025-12-05T14:22:45.683Z
8682300 8682300 20251203051217_l3mX2 CA0032 2025-12-04T14:16:46.528Z 2025-12-05T14:22:23.511Z
8677380 8677380 20251203092910_DUDUc CA0032 2025-12-04T14:00:58.752Z 2025-12-05T14:14:34.820Z
8677357 8677357 20251203091225_0v8Ge CA0032 2025-12-04T14:00:53.699Z 2025-12-05T14:14:34.812Z
8677344 8677344 20251203085828_CwOjF CA0032 2025-12-04T14:00:50.849Z 2025-12-05T14:14:34.807Z
8677311 8677311 20251203083430_KPVxZ CA0032 2025-12-04T14:00:43.859Z 2025-12-05T14:14:34.796Z
8677223 8677223 20251203072728_cGbGC CA0032 2025-12-04T14:00:24.229Z 2025-12-05T14:14:34.768Z
8677195 8677195 20251203070456_u99tc CA0032 2025-12-04T14:00:19.279Z 2025-12-05T14:14:34.760Z
8625206 8625206 20251127083146_3nANl CA0032 2025-11-28T14:26:25.437Z 2025-12-05T15:05:47.342Z
8584009 8584009 20251123103344_afhJZ CA0032 2025-11-25T14:05:00.446Z 2025-12-02T15:09:45.176Z
8583864 8583864 20251123095950_x3NyE CA0032 2025-11-25T14:04:17.679Z 2025-12-02T15:09:43.485Z
8583042 8583042 20251123094816_Brq2S CA0032 2025-11-24T14:34:46.952Z 2025-12-01T15:22:31.116Z
8582625 8582625 20251123072213_pbAMH CA0032 2025-11-24T14:34:22.438Z 2025-12-01T15:22:25.938Z
8582222 8582222 20251123044632_O65a5 CA0032 2025-11-24T14:33:23.506Z 2025-12-01T15:22:19.012Z
8582208 8582208 20251123044427_CdA1c CA0032 2025-11-24T14:33:22.716Z 2025-12-01T15:22:18.814Z
8582050 8582050 20251123035412_uVJ3x CA0032 2025-11-24T14:33:13.636Z 2025-12-01T15:22:14.902Z
8581987 8581987 20251123033045_MLcnw CA0032 2025-11-24T14:32:57.291Z 2025-12-01T15:22:09.304Z
8581651 8581651 20251123013020_EW3jK CA0032 2025-11-24T14:32:29.699Z 2025-12-01T15:21:11.553Z
8581645 8581645 20251123012609_RC0VS CA0032 2025-11-24T14:32:24.370Z 2025-12-01T15:21:11.232Z
8574380 8574380 20251122061119_7C4w4 CA0032 2025-11-23T14:43:17.481Z 2025-11-30T15:07:07.766Z
8574370 8574370 20251122060525_6T4ez CA0032 2025-11-23T14:43:13.025Z 2025-11-30T15:07:07.516Z
8574365 8574365 20251122060057_k3ZbQ CA0032 2025-11-23T14:43:11.562Z 2025-11-30T15:07:07.428Z
8574331 8574331 20251122055132_RhA2N CA0032 2025-11-23T14:43:06.605Z 2025-11-30T15:07:04.992Z
8574208 8574208 20251122052534_Y2Jo0 CA0032 2025-11-23T14:42:48.183Z 2025-11-30T15:07:02.534Z
8326159 8326159 20251030091523_5iFv3 CA0032 2025-11-01T12:35:18.106Z 2025-11-07T15:17:44.322Z
8325948 8325948 20251030084520_SCQV2 CA0032 2025-11-01T12:34:45.567Z 2025-11-07T15:17:34.247Z
8325095 8325095 20251030071325_8riqC CA0032 2025-11-01T12:33:21.467Z 2025-11-07T15:17:18.081Z
8324960 8324960 20251030065056_Oeq3y CA0032 2025-11-01T12:33:13.249Z 2025-11-07T15:17:16.149Z
8324777 8324777 20251030062600_QhRcs CA0032 2025-11-01T12:33:03.212Z 2025-11-07T15:17:12.968Z
8324764 8324764 20251030062415_PGHZ6 CA0032 2025-11-01T12:33:02.452Z 2025-11-07T15:17:12.668Z
8324743 8324743 20251030062224_nQrc2 CA0032 2025-11-01T12:33:01.724Z 2025-11-07T15:17:12.543Z
8324608 8324608 20251030060116_l24zb CA0032 2025-11-01T12:32:31.896Z 2025-11-07T15:17:10.214Z
8324559 8324559 20251030055430_rla2b CA0032 2025-11-01T12:32:26.437Z 2025-11-07T15:17:08.874Z
8324509 8324509 20251030054924_YBKE3 CA0032 2025-11-01T12:32:23.409Z 2025-11-07T15:17:07.640Z
8324462 8324462 20251030054429_jeSP7 CA0032 2025-11-01T12:32:21.738Z 2025-11-07T15:17:07.195Z
8324111 8324111 20251030052409_7FurV CA0032 2025-11-01T12:31:41.266Z 2025-11-07T15:17:00.764Z
8323893 8323893 20251030051412_y6HlU CA0032 2025-11-01T12:31:30.838Z 2025-11-07T15:16:42.599Z
8323401 8323401 20251030045252_33Geo CA0032 2025-11-01T12:30:38.528Z 2025-11-07T15:15:57.367Z
8322140 8322140 20251030035836_WhXPd CA0032 2025-11-01T12:28:40.997Z 2025-11-07T15:15:36.660Z
8321855 8321855 20251030034839_w2e0d CA0032 2025-11-01T12:28:27.648Z 2025-11-07T15:15:33.656Z
8321375 8321375 20251030033322_NPthT CA0032 2025-11-01T12:27:43.846Z 2025-11-07T15:15:29.038Z
8312788 8312788 20251029233007_F6WWk CA0032 2025-10-31T12:36:57.990Z 2025-11-07T15:12:14.989Z
8312287 8312287 20251029230006_VRKMb CA0032 2025-10-31T12:36:43.210Z 2025-11-07T15:11:41.785Z
8306315 8306315 20251029075224_pJGsA CA0032 2025-10-31T12:24:58.149Z 2025-11-06T15:15:03.093Z
8306169 8306169 20251029073229_fs8jG CA0032 2025-10-31T12:24:29.437Z 2025-11-06T15:14:59.221Z
8300750 8300750 20251029101657_kBleU CA0032 2025-10-30T12:54:09.362Z 2025-11-06T15:15:46.644Z
8300737 8300737 20251029100730_GpsI0 CA0032 2025-10-30T12:54:04.454Z 2025-11-06T15:15:44.610Z
8300721 8300721 20251029095251_jV8ds CA0032 2025-10-30T12:54:02.888Z 2025-11-06T15:15:39.192Z
8300719 8300719 20251029094612_2g2u4 CA0032 2025-10-30T12:54:02.705Z 2025-11-06T15:15:37.248Z
8300717 8300717 20251029094550_ZNgD9 CA0032 2025-10-30T12:54:02.672Z 2025-11-06T15:15:37.208Z
8300701 8300701 20251029093509_mMGw9 CA0032 2025-10-30T12:54:01.866Z 2025-11-06T15:15:33.308Z
8300697 8300697 20251029093454_uuSyw CA0032 2025-10-30T12:54:01.825Z 2025-11-06T15:15:33.281Z
8300689 8300689 20251029092645_CJ5nk CA0032 2025-10-30T12:54:01.778Z 2025-11-06T15:15:26.949Z
8300675 8300675 20251029091205_ih2EW CA0032 2025-10-30T12:54:01.215Z 2025-11-06T15:15:25.564Z
8300646 8300646 20251029084606_qrlDI CA0032 2025-10-30T12:54:00.431Z 2025-11-06T15:15:18.535Z
8300624 8300624 20251029083300_m4sNs CA0032 2025-10-30T12:53:59.101Z 2025-11-06T15:15:14.337Z
8300618 8300618 20251029082954_63y93 CA0032 2025-10-30T12:53:58.812Z 2025-11-06T15:15:14.019Z
8300615 8300615 20251029082938_ar6QM CA0032 2025-10-30T12:53:58.773Z 2025-11-06T15:15:14.018Z
8300587 8300587 20251029081020_bFnw4 CA0032 2025-10-30T12:53:54.518Z 2025-11-06T15:15:10.386Z
8300500 8300500 20251029071640_lkImp CA0032 2025-10-30T12:53:48.404Z 2025-11-06T15:14:56.786Z
8300452 8300452 20251029070018_yWJSs CA0032 2025-10-30T12:53:45.573Z 2025-11-06T15:14:54.603Z
8300434 8300434 20251029064807_nsBqU CA0032 2025-10-30T12:53:43.973Z 2025-11-06T15:14:50.383Z
8300432 8300432 20251029064753_dl2bx CA0032 2025-10-30T12:53:43.968Z 2025-11-06T15:14:50.376Z
8300425 8300425 20251029064448_VzxKQ CA0032 2025-10-30T12:53:43.920Z 2025-11-06T15:14:50.121Z
8300312 8300312 20251029053811_EGRPl CA0032 2025-10-30T12:53:27.969Z 2025-11-06T15:14:40.675Z
8300303 8300303 20251029053446_NDiep CA0032 2025-10-30T12:53:27.223Z 2025-11-06T15:14:40.539Z
8300267 8300267 20251029052123_vsFQ2 CA0032 2025-10-30T12:53:23.194Z 2025-11-06T15:14:32.459Z
8300266 8300266 20251029052114_stXkb CA0032 2025-10-30T12:53:23.190Z 2025-11-06T15:14:32.444Z
8300223 8300223 20251029050824_SV9vV CA0032 2025-10-30T12:53:13.061Z 2025-11-06T15:14:28.066Z
8300197 8300197 20251029050245_3nT2o CA0032 2025-10-30T12:53:11.763Z 2025-11-06T15:14:25.865Z
8300154 8300154 20251029044806_Ov4Wi CA0032 2025-10-30T12:53:07.948Z 2025-11-06T15:14:23.274Z
8300148 8300148 20251029044751_8rHSP CA0032 2025-10-30T12:53:07.324Z 2025-11-06T15:14:23.100Z
8300139 8300139 20251029044726_tPdsG CA0032 2025-10-30T12:53:07.003Z 2025-11-06T15:14:22.881Z
8300111 8300111 20251029044203_O4B24 CA0032 2025-10-30T12:53:02.864Z 2025-11-06T15:14:20.414Z
8299865 8299865 20251029040001_rhflp CA0032 2025-10-30T12:52:33.360Z 2025-10-30T12:52:33.360Z
8299715 8299715 20251029034254_EHTrB CA0032 2025-10-30T12:52:16.849Z 2025-11-06T15:13:51.257Z
8299644 8299644 20251029033641_RicUI CA0032 2025-10-30T12:52:06.403Z 2025-11-06T15:13:49.470Z
8299250 8299250 20251029025840_9OfJd CA0032 2025-10-30T12:51:51.623Z 2025-11-06T15:13:36.848Z
8299179 8299179 20251029025024_jBBT8 CA0032 2025-10-30T12:51:49.741Z 2025-11-06T15:13:35.943Z
8299101 8299101 20251029024332_Q0UdS CA0032 2025-10-30T12:51:47.863Z 2025-11-06T15:13:34.629Z
8299048 8299048 20251029023546_ZFoi4 CA0032 2025-10-30T12:51:46.363Z 2025-11-06T15:13:33.657Z
8299040 8299040 20251029023521_5uL3u CA0032 2025-10-30T12:51:46.154Z 2025-11-06T15:13:33.623Z
8298873 8298873 20251029021729_9fdfl CA0032 2025-10-30T12:51:40.977Z 2025-11-06T15:13:21.852Z
8298744 8298744 20251029020109_0fKrM CA0032 2025-10-30T12:51:35.637Z 2025-11-06T15:13:17.777Z
8298105 8298105 20251029004102_3uCI3 CA0032 2025-10-30T12:50:11.403Z 2025-11-06T15:12:45.809Z
8298077 8298077 20251029003830_EJ3sV CA0032 2025-10-30T12:50:08.410Z 2025-11-06T15:12:45.156Z
8297764 8297764 20251028235942_RSi4o CA0032 2025-10-30T12:49:34.085Z 2025-11-06T15:12:35.092Z
8297607 8297607 20251028234345_sNVsu CA0032 2025-10-30T12:49:27.749Z 2025-11-06T15:12:31.182Z
8294107 8294107 20251028101657_0O9rg CA0032 2025-10-30T12:40:49.713Z 2025-11-05T15:24:20.627Z
8293795 8293795 20251028095751_S2rcO CA0032 2025-10-30T12:39:56.799Z 2025-11-05T15:24:06.270Z
8293688 8293688 20251028095205_VxERs CA0032 2025-10-30T12:39:45.668Z 2025-11-05T15:24:03.998Z
8293473 8293473 20251028093727_c20Vm CA0032 2025-10-30T12:39:35.835Z 2025-11-05T15:24:00.346Z
8293276 8293276 20251028092732_Oe2Vh CA0032 2025-10-30T12:39:26.324Z 2025-11-05T15:23:53.523Z
8293245 8293245 20251028092601_GSiAS CA0032 2025-10-30T12:39:16.566Z 2025-11-05T15:23:52.005Z
8293216 8293216 20251028092403_agLcz CA0032 2025-10-30T12:39:06.684Z 2025-11-05T15:23:51.946Z
8293181 8293181 20251028092235_heuzK CA0032 2025-10-30T12:38:58.902Z 2025-11-05T15:23:50.570Z
8293077 8293077 20251028091403_Z50is CA0032 2025-10-30T12:38:43.637Z 2025-11-05T15:23:45.113Z
8293046 8293046 20251028091044_DFV6R CA0032 2025-10-30T12:38:39.174Z 2025-11-05T15:23:42.600Z
8292235 8292235 20251028080926_aGOgC CA0032 2025-10-30T12:37:24.342Z 2025-11-05T15:23:28.200Z
8292206 8292206 20251028080727_QcPh5 CA0032 2025-10-30T12:37:22.365Z 2025-11-05T15:23:27.792Z

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