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

450 rows where station_code = "PL000E" 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
9271821 9271821 20260127202855_nJmVy PL000E 2026-01-29T14:24:03.305Z 2026-01-30T14:30:58.316Z
9271726 9271726 20260127194149_V9a9B PL000E 2026-01-29T14:22:59.497Z 2026-01-30T14:30:40.737Z
9243803 9243803 20260121051825_2vALB PL000E 2026-01-22T14:23:05.083Z 2026-01-29T15:05:27.956Z
9243036 9243036 20260121033428_xqsWH PL000E 2026-01-22T14:20:22.205Z 2026-01-29T15:04:44.347Z
9242280 9242280 20260121012224_5pnIK PL000E 2026-01-22T14:17:09.418Z 2026-01-29T15:03:42.271Z
9240858 9240858 20260120180640_fYGJU PL000E 2026-01-22T14:10:25.648Z 2026-01-29T15:01:58.298Z
9236402 9236402 20260120031126_Widk0 PL000E 2026-01-21T14:22:44.453Z 2026-01-28T14:59:58.609Z
9234602 9234602 20260119223454_CSnaX PL000E 2026-01-21T14:15:25.150Z 2026-01-28T14:57:56.054Z
9233988 9233988 20260119190933_NXp4E PL000E 2026-01-21T14:11:42.686Z 2026-01-28T14:56:57.497Z
9229085 9229085 20260119004617_hhV2w PL000E 2026-01-20T14:20:53.948Z 2026-01-27T15:02:53.600Z
9228711 9228711 20260118233957_KgNFk PL000E 2026-01-20T14:19:09.528Z 2026-01-27T15:02:18.686Z
9228545 9228545 20260118224835_A7pNN PL000E 2026-01-20T14:18:14.369Z 2026-01-27T15:02:06.728Z
9228513 9228513 20260118223839_YJ2Jc PL000E 2026-01-20T14:18:05.349Z 2026-01-27T15:02:04.855Z
9228316 9228316 20260118213918_zI3mt PL000E 2026-01-20T14:17:09.597Z 2026-01-27T15:01:49.187Z
9223627 9223627 20260118014753_zsPNC PL000E 2026-01-19T14:20:18.820Z 2026-01-26T15:02:29.880Z
9223384 9223384 20260118002933_saTsi PL000E 2026-01-19T14:18:58.918Z 2026-01-26T15:02:04.684Z
9223091 9223091 20260117230010_pKsEg PL000E 2026-01-19T14:17:42.069Z 2026-01-26T15:01:47.886Z
9157194 9157194 20260104163136_EkcqC PL000E 2026-01-06T14:42:00.744Z 2026-01-12T15:13:04.777Z
9151426 9151426 20260105053024_DQ6h2 PL000E 2026-01-06T14:13:38.172Z 2026-01-13T15:14:42.213Z
9151375 9151375 20260105052448_WP5i3 PL000E 2026-01-06T14:13:30.705Z 2026-01-13T15:14:40.243Z
9151323 9151323 20260105051650_ZWN2z PL000E 2026-01-06T14:13:21.553Z 2026-01-13T15:14:37.827Z
9150728 9150728 20260105032056_NJ1CG PL000E 2026-01-06T14:11:12.400Z 2026-01-13T15:13:51.526Z
9150631 9150631 20260105025946_MrNbA PL000E 2026-01-06T14:10:46.854Z 2026-01-13T15:13:44.713Z
9150284 9150284 20260105014602_sS1hW PL000E 2026-01-06T14:09:24.850Z 2026-01-13T15:13:14.807Z
9150179 9150179 20260105012238_BoXrB PL000E 2026-01-06T14:08:58.081Z 2026-01-13T15:13:09.483Z
9150077 9150077 20260105005549_6l3QK PL000E 2026-01-06T14:08:27.825Z 2026-01-13T15:13:02.901Z
9150054 9150054 20260105004301_vfN4P PL000E 2026-01-06T14:08:22.045Z 2026-01-13T15:12:53.861Z
9148780 9148780 20260104172814_efUZ7 PL000E 2026-01-06T14:02:21.617Z 2026-01-13T15:11:19.200Z
9147950 9147950 20260103172358_Aj36B PL000E 2026-01-05T14:30:01.622Z 2026-01-10T15:04:03.502Z
9147876 9147876 20260103165959_8CFyV PL000E 2026-01-05T14:29:52.290Z 2026-01-10T15:03:56.628Z
9147857 9147857 20260103164501_yRzuW PL000E 2026-01-05T14:29:49.520Z 2026-01-10T15:03:53.254Z
9147842 9147842 20260103163849_NVlFR PL000E 2026-01-05T14:29:48.059Z 2026-01-10T15:03:51.410Z
9147809 9147809 20260103161904_xgk9O PL000E 2026-01-05T14:29:45.466Z 2026-01-10T15:03:48.907Z
9147807 9147807 20260103161847_Y1U7j PL000E 2026-01-05T14:29:45.255Z 2026-01-10T15:03:48.656Z
9147135 9147135 20260104050805_rI36z PL000E 2026-01-05T14:23:30.245Z 2026-01-12T15:10:14.992Z
9147040 9147040 20260104045653_fuHW4 PL000E 2026-01-05T14:23:24.273Z 2026-01-12T15:09:50.962Z
9146866 9146866 20260104043920_320V0 PL000E 2026-01-05T14:23:01.385Z 2026-01-12T15:09:37.247Z
9146798 9146798 20260104042946_bw1h2 PL000E 2026-01-05T14:22:51.714Z 2026-01-12T15:09:31.089Z
9146692 9146692 20260104041542_V9RXC PL000E 2026-01-05T14:22:42.519Z 2026-01-12T15:09:06.767Z
9146642 9146642 20260104041054_rWMoR PL000E 2026-01-05T14:22:38.821Z 2026-01-12T15:09:03.068Z
9146612 9146612 20260104040728_bL4zE PL000E 2026-01-05T14:22:34.717Z 2026-01-12T15:09:00.176Z
9146539 9146539 20260104035804_dCyft PL000E 2026-01-05T14:22:21.540Z 2026-01-12T15:08:52.837Z
9146299 9146299 20260104034405_tqLNe PL000E 2026-01-05T14:22:04.911Z 2026-01-12T15:08:25.111Z
9145162 9145162 20260104030753_DIrVM PL000E 2026-01-05T14:20:16.561Z 2026-01-12T15:07:43.253Z
9144545 9144545 20260104024808_yaSaM PL000E 2026-01-05T14:19:22.440Z 2026-01-12T15:07:10.064Z
9143830 9143830 20260104022634_0HYon PL000E 2026-01-05T14:18:09.136Z 2026-01-12T15:06:34.790Z
9139905 9139905 20260103235050_uHXc1 PL000E 2026-01-05T14:12:16.805Z 2026-01-12T15:03:53.361Z
9137184 9137184 20260103204833_2jb43 PL000E 2026-01-05T14:07:59.650Z 2026-01-12T15:01:52.288Z
9136862 9136862 20260103202222_IcKvH PL000E 2026-01-05T14:07:23.272Z 2026-01-12T15:01:41.537Z
9136118 9136118 20260103193754_1KReX PL000E 2026-01-05T14:06:11.190Z 2026-01-12T15:01:09.999Z
9135522 9135522 20260103185715_Mvo45 PL000E 2026-01-05T14:04:43.107Z 2026-01-12T15:00:39.374Z
9135194 9135194 20260103184557_32p62 PL000E 2026-01-05T14:03:55.070Z 2026-01-12T15:00:15.677Z
9135105 9135105 20260103184010_0f2od PL000E 2026-01-05T14:03:42.621Z 2026-01-12T15:00:09.245Z
9134590 9134590 20260103181312_iGsDi PL000E 2026-01-05T14:02:20.308Z 2026-01-12T14:59:41.409Z
9134466 9134466 20260103180819_putJs PL000E 2026-01-05T14:02:03.365Z 2026-01-12T14:59:33.617Z
9134349 9134349 20260103180135_ifftY PL000E 2026-01-05T14:01:41.790Z 2026-01-12T14:59:20.702Z
9134077 9134077 20260103174946_2SG0C PL000E 2026-01-05T14:00:31.535Z 2026-01-12T14:59:07.111Z
9130723 9130723 20260103040635_KpceL PL000E 2026-01-04T14:11:22.419Z 2026-01-10T14:59:36.241Z
9130233 9130233 20260103023430_2WTOV PL000E 2026-01-04T14:09:01.513Z 2026-01-10T14:58:54.154Z
9129990 9129990 20260103014631_J7UKk PL000E 2026-01-04T14:07:35.230Z 2026-01-10T14:58:30.649Z
9103791 9103791 20251230050248_aATbB PL000E 2025-12-31T14:19:15.156Z 2025-12-31T14:29:54.054Z
9103604 9103604 20251230044443_6wtEq PL000E 2025-12-31T14:18:27.509Z 2026-01-07T15:08:59.422Z
9103491 9103491 20251230043317_GEXOU PL000E 2025-12-31T14:17:58.930Z 2026-01-07T15:08:46.951Z
9103373 9103373 20251230042454_xy5VH PL000E 2025-12-31T14:17:34.535Z 2026-01-07T15:08:40.488Z
9103368 9103368 20251230042415_1l3HZ PL000E 2025-12-31T14:17:33.496Z 2026-01-07T15:08:40.230Z
9103288 9103288 20251230041328_12ZcP PL000E 2025-12-31T14:17:14.364Z 2026-01-07T15:08:36.471Z
9103108 9103108 20251230035804_GMVum PL000E 2025-12-31T14:16:31.993Z 2026-01-07T15:08:19.228Z
9081039 9081039 20251229053428_N6A60 PL000E 2025-12-30T14:23:32.600Z 2026-01-06T15:18:49.201Z
9080703 9080703 20251229050155_83xni PL000E 2025-12-30T14:22:16.778Z 2026-01-06T15:18:25.571Z
9080089 9080089 20251229041210_o21SK PL000E 2025-12-30T14:19:49.420Z 2025-12-31T14:36:10.918Z
9078856 9078856 20251229023434_kqjdf PL000E 2025-12-30T14:14:40.787Z 2025-12-31T14:34:34.104Z
8993655 8993655 20251218230743_X4qPO PL000E 2025-12-26T14:53:24.088Z 2025-12-27T15:28:06.459Z
8992022 8992022 20251218181207_NNbFB PL000E 2025-12-26T14:50:09.494Z 2025-12-27T15:25:40.344Z
8981456 8981456 20251219173811_orZIU PL000E 2025-12-26T14:24:47.491Z 2025-12-28T15:21:54.010Z
8981052 8981052 20251219161518_PFNh8 PL000E 2025-12-26T14:23:37.609Z 2025-12-28T15:20:48.706Z
8962615 8962615 20251216033605_X1VDf PL000E 2025-12-25T14:36:23.377Z 2025-12-25T14:36:23.377Z
8962606 8962606 20251216033522_63SGI PL000E 2025-12-25T14:36:22.199Z 2025-12-25T14:36:22.199Z
8962159 8962159 20251216025622_Vr80T PL000E 2025-12-25T14:34:58.273Z 2025-12-25T14:34:58.273Z
8937640 8937640 20251214170512_oGM0i PL000E 2025-12-24T14:53:08.921Z 2025-12-24T14:53:08.921Z
8935830 8935830 20251214161427_fV2I3 PL000E 2025-12-24T14:50:46.212Z 2025-12-24T14:50:46.212Z
8742574 8742574 20251210222853_sCvL8 PL000E 2025-12-13T15:22:58.377Z 2025-12-19T15:13:19.058Z
8741722 8741722 20251210213515_WvjhH PL000E 2025-12-13T15:21:18.807Z 2025-12-19T15:12:37.819Z
8741689 8741689 20251210213328_QuwQV PL000E 2025-12-13T15:21:17.709Z 2025-12-19T15:12:37.179Z
8741276 8741276 20251210210250_PsaAd PL000E 2025-12-13T15:20:31.431Z 2025-12-19T15:12:26.309Z
8714009 8714009 20251210044143_vT53K PL000E 2025-12-11T14:01:01.756Z 2025-12-19T15:05:21.672Z
8712522 8712522 20251208234110_xHCvw PL000E 2025-12-10T14:14:12.685Z 2025-12-17T15:34:10.636Z
8708370 8708370 20251208041120_0MpNI PL000E 2025-12-09T14:29:35.961Z 2025-12-16T15:13:22.091Z
8708284 8708284 20251208035053_gedtL PL000E 2025-12-09T14:29:15.829Z 2025-12-16T15:13:19.980Z
8707669 8707669 20251208014900_2mV1D PL000E 2025-12-09T14:27:31.248Z 2025-12-16T15:13:08.095Z
8707328 8707328 20251208005553_t2f7x PL000E 2025-12-09T14:26:43.682Z 2025-12-16T15:13:02.461Z
8707301 8707301 20251208005119_03NA7 PL000E 2025-12-09T14:26:41.531Z 2025-12-16T15:13:01.920Z
8632817 8632817 20251127215902_R872h PL000E 2025-11-29T14:18:25.776Z 2025-12-06T15:01:33.809Z
8632302 8632302 20251127204926_Ztxiq PL000E 2025-11-29T14:17:14.629Z 2025-12-06T15:01:10.227Z
8632282 8632282 20251127204648_2ln5z PL000E 2025-11-29T14:17:12.546Z 2025-12-06T15:01:07.698Z
8587686 8587686 20251123223200_pmKR9 PL000E 2025-11-25T14:15:54.105Z 2025-12-02T15:11:18.967Z
8587673 8587673 20251123223029_Sq9P5 PL000E 2025-11-25T14:15:53.180Z 2025-12-02T15:11:18.938Z
8587470 8587470 20251123220908_hMYKi PL000E 2025-11-25T14:15:23.190Z 2025-12-02T15:11:13.772Z
8534812 8534812 20251120002136_SRVe0 PL000E 2025-11-21T14:14:40.512Z 2025-11-28T14:56:02.601Z
8534545 8534545 20251119234059_jXG9J PL000E 2025-11-21T14:14:02.572Z 2025-11-28T14:55:48.789Z
8525026 8525026 20251119045111_3pi3e PL000E 2025-11-20T14:21:56.159Z 2025-11-27T15:13:10.954Z

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