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

538 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
9611425 9611425 20260405015326_CTNRo PL000E 2026-04-06T12:14:32.801Z 2026-04-06T12:16:14.797Z
9611322 9611322 20260405012658_BvJZl PL000E 2026-04-06T12:14:01.288Z 2026-04-06T12:16:14.779Z
9611223 9611223 20260405005523_03cpA PL000E 2026-04-06T12:13:31.689Z 2026-04-06T12:16:14.757Z
9608893 9608893 20260404022100_33ePp PL000E 2026-04-05T12:12:08.540Z 2026-04-06T12:20:48.898Z
9579968 9579968 20260324233904_ctndr PL000E 2026-03-26T12:14:46.746Z 2026-04-02T12:37:36.816Z
9579673 9579673 20260324220938_AKNUY PL000E 2026-03-26T12:14:10.693Z 2026-04-02T12:37:19.958Z
9575911 9575911 20260325003921_RCYMc PL000E 2026-03-26T12:00:38.363Z 2026-04-03T12:35:28.934Z
9575329 9575329 20260323204357_UFb5d PL000E 2026-03-25T12:20:50.820Z 2026-03-31T12:28:54.965Z
9570939 9570939 20260322231738_YBTl0 PL000E 2026-03-24T12:24:02.894Z 2026-03-30T12:30:52.266Z
9570933 9570933 20260322231405_6Smg9 PL000E 2026-03-24T12:24:02.511Z 2026-03-30T12:30:52.184Z
9562846 9562846 20260323032629_vXd7p PL000E 2026-03-24T12:04:15.745Z 2026-03-31T12:26:27.701Z
9562756 9562756 20260323030858_U583A PL000E 2026-03-24T12:03:57.830Z 2026-03-31T12:26:25.229Z
9559672 9559672 20260321192118_vTvIz PL000E 2026-03-23T12:11:26.349Z 2026-03-29T12:20:42.641Z
9553943 9553943 20260322022648_KGZ1F PL000E 2026-03-23T12:02:02.407Z 2026-03-30T12:27:55.669Z
9533627 9533627 20260320024704_3rMUV PL000E 2026-03-21T12:05:54.717Z 2026-03-28T12:33:57.222Z
9532271 9532271 20260320004301_LMwvM PL000E 2026-03-21T12:02:15.239Z 2026-03-28T12:33:26.936Z
9531585 9531585 20260319232622_VZE2K PL000E 2026-03-21T12:00:17.999Z 2026-03-28T12:33:18.897Z
9530584 9530584 20260318211251_ufiYT PL000E 2026-03-20T12:24:30.509Z 2026-03-26T12:39:14.043Z
9530492 9530492 20260318210253_C7xgt PL000E 2026-03-20T12:24:26.766Z 2026-03-26T12:39:12.980Z
9520978 9520978 20260319034712_77A8d PL000E 2026-03-20T12:07:19.215Z 2026-03-27T12:40:49.637Z
9520704 9520704 20260319033315_sxBt8 PL000E 2026-03-20T12:06:50.001Z 2026-03-27T12:40:46.427Z
9520589 9520589 20260319032653_x35HP PL000E 2026-03-20T12:06:36.599Z 2026-03-27T12:40:45.189Z
9519253 9519253 20260319015705_Dlzxl PL000E 2026-03-20T12:04:10.851Z 2026-03-27T12:40:19.567Z
9509809 9509809 20260318021712_dveLg PL000E 2026-03-19T12:06:15.080Z 2026-03-26T12:37:08.009Z
9500918 9500918 20260315200213_DnoTO PL000E 2026-03-17T12:24:10.189Z 2026-03-23T12:22:42.273Z
9493709 9493709 20260316002405_j9A3y PL000E 2026-03-17T12:01:46.498Z 2026-03-24T12:40:41.385Z
9484628 9484628 20260315011601_EJsNX PL000E 2026-03-16T12:03:33.029Z 2026-03-23T12:21:47.598Z
9484439 9484439 20260315003949_4244k PL000E 2026-03-16T12:02:53.738Z 2026-03-23T12:21:46.783Z
9484343 9484343 20260315002326_xDY8e PL000E 2026-03-16T12:02:29.074Z 2026-03-23T12:21:46.402Z
9484258 9484258 20260315001137_BYTUt PL000E 2026-03-16T12:02:11.934Z 2026-03-23T12:21:46.055Z
9484256 9484256 20260315001132_5fZev PL000E 2026-03-16T12:02:11.208Z 2026-03-23T12:21:46.055Z
9476989 9476989 20260314040126_Ft72l PL000E 2026-03-15T12:07:21.182Z 2026-03-22T12:42:00.449Z
9475632 9475632 20260314015012_1MkUD PL000E 2026-03-15T12:03:40.367Z 2026-03-22T12:41:46.295Z
9475410 9475410 20260314012335_hXnYL PL000E 2026-03-15T12:03:04.061Z 2026-03-22T12:41:37.815Z
9475327 9475327 20260314011608_SjKRA PL000E 2026-03-15T12:02:53.061Z 2026-03-22T12:41:33.377Z
9474531 9474531 20260313230830_L2WPF PL000E 2026-03-15T12:00:29.247Z 2026-03-22T12:41:21.237Z
9469775 9469775 20260313034413_kIs2H PL000E 2026-03-14T12:05:30.051Z 2026-03-21T12:49:02.185Z
9469534 9469534 20260313030252_vp9Vh PL000E 2026-03-14T12:04:37.678Z 2026-03-21T12:48:41.173Z
9469478 9469478 20260313025600_G9GHE PL000E 2026-03-14T12:04:24.683Z 2026-03-21T12:48:40.203Z
9463882 9463882 20260312025924_sh2xn PL000E 2026-03-13T12:05:29.988Z 2026-03-20T12:36:25.367Z
9463109 9463109 20260312010416_Xi26k PL000E 2026-03-13T12:03:09.243Z 2026-03-20T12:36:19.772Z
9463000 9463000 20260312004740_99lrI PL000E 2026-03-13T12:02:50.707Z 2026-03-20T12:36:19.320Z
9456047 9456047 20260309213301_33O4y PL000E 2026-03-11T12:15:33.536Z 2026-03-17T12:42:49.300Z
9455790 9455790 20260309201819_25tRp PL000E 2026-03-11T12:15:03.118Z 2026-03-17T12:42:39.266Z
9451299 9451299 20260310013922_O0rVI PL000E 2026-03-11T12:02:23.753Z 2026-03-18T12:38:44.525Z
9451130 9451130 20260310004727_Gg3Pa PL000E 2026-03-11T12:01:49.114Z 2026-03-18T12:38:40.886Z
9450511 9450511 20260308220903_96V5a PL000E 2026-03-10T12:19:52.130Z 2026-03-16T12:44:44.276Z
9446358 9446358 20260309011519_WQCYx PL000E 2026-03-10T12:02:07.107Z 2026-03-17T12:41:36.928Z
9446356 9446356 20260309011516_ybI9c PL000E 2026-03-10T12:02:06.547Z 2026-03-17T12:41:36.903Z
9446278 9446278 20260309004845_EWyBK PL000E 2026-03-10T12:01:49.237Z 2026-03-17T12:41:35.606Z
9446012 9446012 20260308231554_IKkTG PL000E 2026-03-10T12:00:34.183Z 2026-03-17T12:41:19.210Z
9445579 9445579 20260307204307_dZejG PL000E 2026-03-09T12:19:56.208Z 2026-03-15T12:42:11.529Z
9445415 9445415 20260307191012_HI2xR PL000E 2026-03-09T12:18:58.804Z 2026-03-15T12:42:07.932Z
9441526 9441526 20260306222221_ahAY9 PL000E 2026-03-08T12:22:14.569Z 2026-03-14T12:40:54.457Z
9441490 9441490 20260306221400_2mKMZ PL000E 2026-03-08T12:22:06.309Z 2026-03-14T12:40:52.716Z
9437491 9437491 20260307040454_Q3Meh PL000E 2026-03-08T12:04:12.472Z 2026-03-15T12:41:08.223Z
9437026 9437026 20260307012016_iCyap PL000E 2026-03-08T12:02:18.042Z 2026-03-15T12:41:00.994Z
9436821 9436821 20260307000634_O7Lj6 PL000E 2026-03-08T12:01:22.589Z 2026-03-15T12:40:58.212Z
9436346 9436346 20260305205922_A6Ozb PL000E 2026-03-07T14:25:36.088Z 2026-03-13T12:35:58.789Z
9432140 9432140 20260306034044_CMYn3 PL000E 2026-03-07T14:03:35.996Z 2026-03-14T12:39:25.690Z
9431587 9431587 20260306003629_1RYK3 PL000E 2026-03-07T14:01:14.697Z 2026-03-14T12:39:14.897Z
9430497 9430497 20260304192413_bAo2M PL000E 2026-03-06T14:23:16.470Z 2026-03-12T12:33:36.749Z
9426360 9426360 20260305031822_Ut7Ud PL000E 2026-03-06T14:04:27.908Z 2026-03-13T12:34:45.521Z
9426284 9426284 20260305025435_Fbx80 PL000E 2026-03-06T14:04:05.297Z 2026-03-13T12:34:44.530Z
9422247 9422247 20260303232157_9p2DS PL000E 2026-03-05T14:00:33.247Z 2026-03-12T12:32:24.359Z
9420456 9420456 20260302202610_A8N8A PL000E 2026-03-04T14:04:52.800Z 2026-03-10T12:36:52.780Z
9420429 9420429 20260302201038_vIIs8 PL000E 2026-03-04T14:04:49.106Z 2026-03-10T12:36:52.126Z
9420358 9420358 20260302175556_lgBzA PL000E 2026-03-04T14:04:37.936Z 2026-03-10T12:36:37.361Z
9419505 9419505 20260303040846_YZQH6 PL000E 2026-03-04T14:01:33.235Z 2026-03-11T12:28:01.776Z
9419496 9419496 20260303040547_2Gu7H PL000E 2026-03-04T14:01:31.981Z 2026-03-11T12:28:01.448Z
9419340 9419340 20260303030711_yBWj1 PL000E 2026-03-04T14:01:14.628Z 2026-03-11T12:27:58.779Z
9419185 9419185 20260303020409_XKgyj PL000E 2026-03-04T14:00:55.437Z 2026-03-11T12:27:46.361Z
9419052 9419052 20260303004805_d1NHD PL000E 2026-03-04T14:00:36.710Z 2026-03-11T12:27:44.090Z
9415402 9415402 20260228224211_CTrid PL000E 2026-03-02T14:07:51.038Z 2026-03-08T12:43:12.844Z
9412186 9412186 20260301013548_PmU0s PL000E 2026-03-02T14:00:46.311Z 2026-03-09T12:39:23.631Z
9411906 9411906 20260227222838_Stenr PL000E 2026-03-01T14:09:17.308Z 2026-03-07T14:51:22.316Z
9407369 9407369 20260226172115_6A5tn PL000E 2026-02-28T14:21:20.316Z 2026-03-06T14:44:58.197Z
9402059 9402059 20260227023417_ByeqJ PL000E 2026-02-28T14:03:22.264Z 2026-03-07T14:46:21.425Z
9401540 9401540 20260227002625_qPHuv PL000E 2026-02-28T14:01:11.625Z 2026-03-07T14:45:50.116Z
9400983 9400983 20260225214202_e3Hzn PL000E 2026-02-27T14:16:09.321Z 2026-03-05T14:39:01.626Z
9400794 9400794 20260225203532_GnJBI PL000E 2026-02-27T14:15:41.330Z 2026-03-05T14:38:48.859Z
9398679 9398679 20260226040043_GXNLT PL000E 2026-02-27T14:05:53.034Z 2026-03-06T14:43:55.410Z
9397857 9397857 20260226023449_4D7cl PL000E 2026-02-27T14:03:43.394Z 2026-03-06T14:43:27.832Z
9397531 9397531 20260226015341_sOCta PL000E 2026-02-27T14:02:43.875Z 2026-03-06T14:43:12.868Z
9397205 9397205 20260226010440_uCLI9 PL000E 2026-02-27T14:01:45.110Z 2026-03-06T14:43:03.796Z
9358431 9358431 20260221010908_T2Fgc PL000E 2026-02-22T14:00:45.935Z 2026-03-02T14:20:46.393Z
9358388 9358388 20260221004644_FfagL PL000E 2026-02-22T14:00:31.892Z 2026-03-02T14:20:45.528Z
9316672 9316672 20260210201356_EMBCp PL000E 2026-02-12T14:18:22.828Z 2026-02-18T14:57:52.227Z
9271821 9271821 20260127202855_nJmVy PL000E 2026-01-29T14:24:03.305Z 2026-02-05T14:48:56.002Z
9271726 9271726 20260127194149_V9a9B PL000E 2026-01-29T14:22:59.497Z 2026-02-05T14:48:35.833Z
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

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