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,631 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
9450932 9450932 20260309235404_OFk0E CA000E 2026-03-11T12:01:10.842Z 2026-03-18T12:38:37.965Z
9416328 9416328 20260302100731_cVGmg CA000E 2026-03-03T14:03:26.382Z 2026-03-10T12:36:03.068Z
9416145 9416145 20260302085934_IBbXh CA000E 2026-03-03T14:02:51.680Z 2026-03-10T12:35:59.658Z
9415795 9415795 20260302041340_fLkpv CA000E 2026-03-03T14:01:39.129Z 2026-03-10T12:35:50.485Z
9415566 9415566 20260302013235_XAgnO CA000E 2026-03-03T14:00:42.321Z 2026-03-10T12:35:44.250Z
9415555 9415555 20260302012425_ymwdx CA000E 2026-03-03T14:00:39.515Z 2026-03-10T12:35:43.921Z
9391069 9391069 20260225015733_RAgDc CA000E 2026-02-26T14:03:24.227Z 2026-03-05T14:36:05.407Z
9374259 9374259 20260223072204_EQNkS CA000E 2026-02-24T14:05:28.849Z 2026-03-03T14:31:18.827Z
9373847 9373847 20260223043115_hZY8u CA000E 2026-02-24T14:04:06.072Z 2026-03-03T14:31:10.595Z
9373636 9373636 20260223035414_fGRgP CA000E 2026-02-24T14:03:32.277Z 2026-03-03T14:31:07.015Z
9373446 9373446 20260223030833_CgMvA CA000E 2026-02-24T14:02:59.712Z 2026-03-03T14:31:03.344Z
9366135 9366135 20260222084544_I8M0K CA000E 2026-02-23T14:06:33.347Z 2026-02-24T14:16:01.995Z
9366029 9366029 20260222081702_gq3P2 CA000E 2026-02-23T14:06:07.838Z 2026-02-24T14:15:55.424Z
9365457 9365457 20260222035910_cihwm CA000E 2026-02-23T14:03:34.621Z 2026-02-24T14:15:14.450Z
9359098 9359098 20260221072013_xAgTP CA000E 2026-02-22T14:03:46.439Z 2026-03-02T14:21:11.408Z
9359055 9359055 20260221070350_LTCHf CA000E 2026-02-22T14:03:35.837Z 2026-03-02T14:21:10.704Z
9358983 9358983 20260221063044_TW5Nx CA000E 2026-02-22T14:03:16.865Z 2026-03-02T14:21:09.827Z
9358861 9358861 20260221052902_mJlVA CA000E 2026-02-22T14:02:43.166Z 2026-03-02T14:20:56.396Z
9352619 9352619 20260220084202_UZwWg CA000E 2026-02-21T14:02:33.208Z 2026-03-01T14:21:40.659Z
9352395 9352395 20260220060159_Ih9h2 CA000E 2026-02-21T14:01:44.654Z 2026-03-01T14:21:36.959Z
9341340 9341340 20260219081114_615VD CA000E 2026-02-20T14:00:56.385Z 2026-02-28T14:43:50.174Z
9331215 9331215 20260216042045_Nu9lh CA000E 2026-02-17T14:05:25.629Z 2026-02-25T14:41:40.443Z
9322565 9322565 20260214031746_fjhCP CA000E 2026-02-15T14:02:55.386Z 2026-02-23T14:46:18.471Z
9322012 9322012 20260213005842_TIHti CA000E 2026-02-14T14:22:15.204Z 2026-02-21T14:37:40.635Z
9320216 9320216 20260213084637_Adw7N CA000E 2026-02-14T14:05:22.732Z 2026-02-22T14:41:50.817Z
9320077 9320077 20260213071606_H9fX5 CA000E 2026-02-14T14:04:19.794Z 2026-02-22T14:41:46.508Z
9313827 9313827 20260210021432_RID70 CA000E 2026-02-11T14:18:59.924Z 2026-02-18T15:02:27.427Z
9298388 9298388 20260206021640_JdC6K CA000E 2026-02-07T14:23:04.406Z 2026-02-14T15:06:25.916Z
9295500 9295500 20260206093929_HYHB7 CA000E 2026-02-07T14:04:12.117Z 2026-02-15T14:56:34.976Z
9295164 9295164 20260206083408_o4gK2 CA000E 2026-02-07T14:02:47.613Z 2026-02-15T14:56:09.712Z
9295004 9295004 20260206071631_s3Qbu CA000E 2026-02-07T14:01:43.694Z 2026-02-15T14:55:54.610Z
9287328 9287328 20260203094118_UCA5N CA000E 2026-02-04T14:02:10.908Z 2026-02-12T14:50:18.765Z
9286621 9286621 20260202104853_3sBTy CA000E 2026-02-03T14:02:08.037Z 2026-02-11T14:50:11.851Z
9286461 9286461 20260202074457_ufoxR CA000E 2026-02-03T14:00:56.488Z 2026-02-11T14:49:56.654Z
9088068 9088068 20251228111028_YaCSX CA000E 2025-12-30T14:45:33.881Z 2026-01-05T15:11:39.329Z
9087744 9087744 20251228102511_G3oAr CA000E 2025-12-30T14:44:51.533Z 2026-01-05T15:11:28.916Z
9087401 9087401 20251228091314_NBvVg CA000E 2025-12-30T14:43:53.535Z 2026-01-05T15:11:04.863Z
9044710 9044710 20251223051343_rUOz3 CA000E 2025-12-28T14:52:25.274Z 2025-12-31T15:42:38.459Z
8988477 8988477 20251218102459_sBI2o CA000E 2025-12-26T14:42:26.759Z 2025-12-27T15:21:47.271Z
8987349 8987349 20251218081257_0Z2Ry CA000E 2025-12-26T14:40:05.692Z 2025-12-27T15:20:18.156Z
8987101 8987101 20251218073112_oE2KT CA000E 2025-12-26T14:39:30.165Z 2025-12-27T15:20:03.307Z
8951532 8951532 20251215014723_mJuzg CA000E 2025-12-24T15:08:51.213Z 2025-12-24T15:08:51.213Z
8950561 8950561 20251215010051_UDfq3 CA000E 2025-12-24T15:07:33.302Z 2025-12-24T15:07:33.302Z
8949354 8949354 20251215000323_3eIMN CA000E 2025-12-24T15:06:08.073Z 2025-12-24T15:06:08.073Z
8928008 8928008 20251215043556_ntkar CA000E 2025-12-24T14:10:08.651Z 2025-12-24T15:09:30.917Z
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

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