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,586 rows where station_code = "CA000E" 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
8584093 8584093 20251123105441_ppsQL CA000E 2025-11-25T14:05:18.609Z 2025-12-02T15:09:46.136Z
8584008 8584008 20251123103344_afhJZ CA000E 2025-11-25T14:05:00.446Z 2025-12-02T15:09:45.176Z
8583863 8583863 20251123095950_x3NyE CA000E 2025-11-25T14:04:17.679Z 2025-12-02T15:09:43.485Z
8582207 8582207 20251123044427_CdA1c CA000E 2025-11-24T14:33:22.701Z 2025-12-01T15:22:18.814Z
8574379 8574379 20251122061119_7C4w4 CA000E 2025-11-23T14:43:17.480Z 2025-11-30T15:07:07.766Z
8574369 8574369 20251122060525_6T4ez CA000E 2025-11-23T14:43:13.025Z 2025-11-30T15:07:07.516Z
8574330 8574330 20251122055132_RhA2N CA000E 2025-11-23T14:43:06.604Z 2025-11-30T15:07:04.992Z
8375911 8375911 20251103092158_V3Eir CA000E 2025-11-05T14:35:38.926Z 2025-11-11T15:08:22.800Z
8326158 8326158 20251030091523_5iFv3 CA000E 2025-11-01T12:35:18.105Z 2025-11-07T15:17:44.322Z
8325947 8325947 20251030084520_SCQV2 CA000E 2025-11-01T12:34:45.567Z 2025-11-07T15:17:34.247Z
8325094 8325094 20251030071325_8riqC CA000E 2025-11-01T12:33:21.467Z 2025-11-07T15:17:18.081Z
8324607 8324607 20251030060116_l24zb CA000E 2025-11-01T12:32:31.896Z 2025-11-07T15:17:10.214Z
8324461 8324461 20251030054429_jeSP7 CA000E 2025-11-01T12:32:21.738Z 2025-11-07T15:17:07.195Z
8324110 8324110 20251030052409_7FurV CA000E 2025-11-01T12:31:41.266Z 2025-11-07T15:17:00.764Z
8323400 8323400 20251030045252_33Geo CA000E 2025-11-01T12:30:38.527Z 2025-11-07T15:15:57.367Z
8321854 8321854 20251030034839_w2e0d CA000E 2025-11-01T12:28:27.648Z 2025-11-07T15:15:33.656Z
8312286 8312286 20251029230006_VRKMb CA000E 2025-10-31T12:36:43.184Z 2025-11-07T15:11:41.785Z
8300749 8300749 20251029101657_kBleU CA000E 2025-10-30T12:54:09.362Z 2025-11-06T15:15:46.644Z
8300720 8300720 20251029095251_jV8ds CA000E 2025-10-30T12:54:02.887Z 2025-11-06T15:15:39.192Z
8300718 8300718 20251029094612_2g2u4 CA000E 2025-10-30T12:54:02.705Z 2025-11-06T15:15:37.248Z
8300683 8300683 20251029092252_ZxAmi CA000E 2025-10-30T12:54:01.649Z 2025-11-06T15:15:26.503Z
8300674 8300674 20251029091205_ih2EW CA000E 2025-10-30T12:54:01.215Z 2025-11-06T15:15:25.564Z
8300623 8300623 20251029083300_m4sNs CA000E 2025-10-30T12:53:59.100Z 2025-11-06T15:15:14.337Z
8300585 8300585 20251029081020_bFnw4 CA000E 2025-10-30T12:53:54.518Z 2025-11-06T15:15:10.386Z
8300523 8300523 20251029073525_PsbFO CA000E 2025-10-30T12:53:49.626Z 2025-10-30T12:53:49.626Z
8300499 8300499 20251029071640_lkImp CA000E 2025-10-30T12:53:48.404Z 2025-11-06T15:14:56.786Z
8300451 8300451 20251029070018_yWJSs CA000E 2025-10-30T12:53:45.573Z 2025-11-06T15:14:54.603Z
8300431 8300431 20251029064753_dl2bx CA000E 2025-10-30T12:53:43.968Z 2025-11-06T15:14:50.376Z
8300311 8300311 20251029053811_EGRPl CA000E 2025-10-30T12:53:27.969Z 2025-11-06T15:14:40.675Z
8300302 8300302 20251029053446_NDiep CA000E 2025-10-30T12:53:27.223Z 2025-11-06T15:14:40.539Z
8300145 8300145 20251029044751_8rHSP CA000E 2025-10-30T12:53:07.324Z 2025-11-06T15:14:23.099Z
8300137 8300137 20251029044726_tPdsG CA000E 2025-10-30T12:53:07.003Z 2025-11-06T15:14:22.881Z
8300110 8300110 20251029044203_O4B24 CA000E 2025-10-30T12:53:02.863Z 2025-11-06T15:14:20.414Z
8299714 8299714 20251029034254_EHTrB CA000E 2025-10-30T12:52:16.849Z 2025-11-06T15:13:51.257Z
8299642 8299642 20251029033641_RicUI CA000E 2025-10-30T12:52:06.403Z 2025-11-06T15:13:49.470Z
8299249 8299249 20251029025840_9OfJd CA000E 2025-10-30T12:51:51.623Z 2025-11-06T15:13:36.848Z
8299038 8299038 20251029023521_5uL3u CA000E 2025-10-30T12:51:46.154Z 2025-11-06T15:13:33.623Z
8298872 8298872 20251029021729_9fdfl CA000E 2025-10-30T12:51:40.977Z 2025-11-06T15:13:21.852Z
8298104 8298104 20251029004102_3uCI3 CA000E 2025-10-30T12:50:11.403Z 2025-11-06T15:12:45.809Z
8294106 8294106 20251028101657_0O9rg CA000E 2025-10-30T12:40:49.712Z 2025-11-05T15:24:20.627Z
8293215 8293215 20251028092403_agLcz CA000E 2025-10-30T12:39:06.684Z 2025-11-05T15:23:51.946Z
8293180 8293180 20251028092235_heuzK CA000E 2025-10-30T12:38:58.901Z 2025-11-05T15:23:50.569Z
8293076 8293076 20251028091403_Z50is CA000E 2025-10-30T12:38:43.637Z 2025-11-05T15:23:45.113Z
8293045 8293045 20251028091044_DFV6R CA000E 2025-10-30T12:38:39.174Z 2025-11-05T15:23:42.600Z
8292205 8292205 20251028080727_QcPh5 CA000E 2025-10-30T12:37:22.365Z 2025-11-05T15:23:27.792Z
8292191 8292191 20251028080632_mfPf7 CA000E 2025-10-30T12:37:21.516Z 2025-11-05T15:23:27.641Z
8292130 8292130 20251028080011_KUD39 CA000E 2025-10-30T12:37:17.640Z 2025-11-05T15:23:24.664Z
8291394 8291394 20251028065057_Fu4Q4 CA000E 2025-10-30T12:35:40.631Z 2025-11-05T15:23:12.601Z
8291332 8291332 20251028064353_5Jrbm CA000E 2025-10-30T12:35:37.535Z 2025-11-05T15:23:12.252Z
8280444 8280444 20251027233733_pYSZt CA000E 2025-10-29T12:39:17.473Z 2025-11-05T15:21:04.144Z
8226049 8226049 20251024085559_PYpTV CA000E 2025-10-26T12:44:26.547Z 2025-11-01T13:11:23.808Z
8225900 8225900 20251024084603_Ne25B CA000E 2025-10-26T12:44:04.902Z 2025-11-01T13:11:23.236Z
8225798 8225798 20251024083735_YB3eQ CA000E 2025-10-26T12:43:48.841Z 2025-11-01T13:11:22.890Z
8169998 8169998 20251020070812_IRiP3 CA000E 2025-10-22T12:38:50.433Z 2025-10-28T13:09:05.384Z
8169586 8169586 20251020063032_RUsiP CA000E 2025-10-22T12:38:27.108Z 2025-10-28T13:09:02.090Z
8169561 8169561 20251020062736_bo9fL CA000E 2025-10-22T12:38:26.163Z 2025-10-28T13:09:02.032Z
8169554 8169554 20251020062657_9M73l CA000E 2025-10-22T12:38:25.377Z 2025-10-28T13:09:01.956Z
8169529 8169529 20251020062421_dGh9l CA000E 2025-10-22T12:38:23.571Z 2025-10-28T13:09:01.907Z
8169458 8169458 20251020061106_ySV2O CA000E 2025-10-22T12:38:10.327Z 2025-10-28T13:09:01.605Z
8166259 8166259 20251020003632_oNEZl CA000E 2025-10-22T12:30:26.774Z 2025-10-28T13:08:18.526Z
8165583 8165583 20251019233019_xE8IM CA000E 2025-10-22T12:28:43.442Z 2025-10-28T13:08:08.613Z
8149923 8149923 20251019095933_33pVG CA000E 2025-10-20T12:29:54.996Z 2025-10-27T13:11:21.567Z
8149861 8149861 20251019095616_iijYk CA000E 2025-10-20T12:29:51.822Z 2025-10-27T13:11:21.086Z
8137110 8137110 20251018091708_HuTQ2 CA000E 2025-10-19T12:20:46.724Z 2025-10-26T13:16:20.879Z
8136869 8136869 20251018085808_81fOc CA000E 2025-10-19T12:20:30.226Z 2025-10-26T13:16:17.489Z
8136749 8136749 20251018084916_NhbI8 CA000E 2025-10-19T12:20:23.522Z 2025-10-26T13:16:16.899Z
8136405 8136405 20251018082542_ykcgT CA000E 2025-10-19T12:19:34.330Z 2025-10-26T13:16:15.558Z
8135966 8135966 20251018074711_U9VHy CA000E 2025-10-19T12:19:05.894Z 2025-10-26T13:16:11.152Z
8135948 8135948 20251018074503_A8Pvg CA000E 2025-10-19T12:18:58.088Z 2025-10-26T13:16:11.131Z
8135384 8135384 20251018063900_7SLEb CA000E 2025-10-19T12:17:45.273Z 2025-10-26T13:16:07.940Z
8135057 8135057 20251018060336_7arDs CA000E 2025-10-19T12:17:13.440Z 2025-10-26T13:16:03.560Z
8135031 8135031 20251018060005_r8N9Q CA000E 2025-10-19T12:17:11.491Z 2025-10-26T13:16:03.430Z
8134686 8134686 20251018050957_a63is CA000E 2025-10-19T12:16:19.557Z 2025-10-26T13:15:58.957Z
8134673 8134673 20251018050829_reSkd CA000E 2025-10-19T12:16:18.318Z 2025-10-26T13:15:58.462Z
8134634 8134634 20251018050352_Y2Bfb CA000E 2025-10-19T12:16:15.750Z 2025-10-26T13:15:58.114Z
8134284 8134284 20251018041940_RPluP CA000E 2025-10-19T12:15:28.612Z 2025-10-26T13:15:53.858Z
8134229 8134229 20251018041429_G2ACk CA000E 2025-10-19T12:15:24.291Z 2025-10-26T13:15:53.396Z
8134048 8134048 20251018035816_3work CA000E 2025-10-19T12:14:46.267Z 2025-10-26T13:15:51.145Z
8132001 8132001 20251018001202_SnWSk CA000E 2025-10-19T12:09:10.306Z 2025-10-26T13:15:15.204Z
8127546 8127546 20251017100916_w5Crb CA000E 2025-10-18T12:36:05.867Z 2025-10-25T13:31:06.302Z
8127285 8127285 20251017095207_OKHfT CA000E 2025-10-18T12:35:03.428Z 2025-10-18T12:44:47.133Z
8127096 8127096 20251017094019_36wfR CA000E 2025-10-18T12:34:50.532Z 2025-10-25T13:30:50.163Z
8126797 8126797 20251017092003_f89rP CA000E 2025-10-18T12:34:10.814Z 2025-10-25T13:30:35.144Z
8125797 8125797 20251017081749_Xicsf CA000E 2025-10-18T12:32:08.288Z 2025-10-25T13:29:55.483Z
8125660 8125660 20251017080834_IUb6h CA000E 2025-10-18T12:31:55.122Z 2025-10-25T13:29:49.861Z
8125638 8125638 20251017080638_7KHFF CA000E 2025-10-18T12:31:53.483Z 2025-10-25T13:29:49.442Z
8124820 8124820 20251017065010_i3R75 CA000E 2025-10-18T12:29:53.813Z 2025-10-25T13:29:26.758Z
8124794 8124794 20251017064703_xoB33 CA000E 2025-10-18T12:29:49.983Z 2025-10-25T13:29:26.520Z
8124696 8124696 20251017063728_DoyXR CA000E 2025-10-18T12:29:43.575Z 2025-10-25T13:29:25.671Z
8124251 8124251 20251017053732_Gfmdd CA000E 2025-10-18T12:28:50.284Z 2025-10-25T13:29:18.841Z
8124132 8124132 20251017051753_xCMqV CA000E 2025-10-18T12:28:40.233Z 2025-10-25T13:29:17.513Z
8123980 8123980 20251017045115_b47SB CA000E 2025-10-18T12:28:02.273Z 2025-10-25T13:29:15.426Z
8123941 8123941 20251017044551_vqxpF CA000E 2025-10-18T12:27:59.036Z 2025-10-25T13:29:14.858Z
8123227 8123227 20251017032025_8eCDg CA000E 2025-10-18T12:26:03.622Z 2025-10-25T13:29:06.451Z
8123073 8123073 20251017030511_ACSaR CA000E 2025-10-18T12:25:29.422Z 2025-10-25T13:29:03.913Z
8115481 8115481 20251016093030_79Moh CA000E 2025-10-17T12:18:09.511Z 2025-10-24T13:17:02.590Z
8115037 8115037 20251016085151_xyEe0 CA000E 2025-10-17T12:17:16.106Z 2025-10-24T13:17:00.058Z
8115015 8115015 20251016084953_e40Pn CA000E 2025-10-17T12:17:11.781Z 2025-10-24T13:16:59.985Z
8114651 8114651 20251016081537_kwB03 CA000E 2025-10-17T12:16:48.892Z 2025-10-24T13:16:58.226Z
8113956 8113956 20251016063708_S2xQl CA000E 2025-10-17T12:15:36.569Z 2025-10-24T13:16:54.391Z

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