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

359 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
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
8524900 8524900 20251119043429_jMTCm PL000E 2025-11-20T14:21:44.650Z 2025-11-27T15:13:07.242Z
8524571 8524571 20251119035725_L80An PL000E 2025-11-20T14:21:03.057Z 2025-11-27T15:12:58.005Z
8524514 8524514 20251119035344_Esd3a PL000E 2025-11-20T14:20:59.011Z 2025-11-27T15:12:57.182Z
8524503 8524503 20251119035258_sxVYe PL000E 2025-11-20T14:20:57.807Z 2025-11-27T15:12:57.161Z
8524374 8524374 20251119033844_c6JzE PL000E 2025-11-20T14:20:30.425Z 2025-11-27T15:12:50.396Z
8524093 8524093 20251119030904_H5Xpi PL000E 2025-11-20T14:20:05.910Z 2025-11-27T15:12:39.022Z
8524075 8524075 20251119030753_Ftlwo PL000E 2025-11-20T14:20:04.582Z 2025-11-27T15:12:38.791Z
8524071 8524071 20251119030709_XLk3T PL000E 2025-11-20T14:20:03.714Z 2025-11-27T15:12:38.435Z
8524023 8524023 20251119030415_aikdY PL000E 2025-11-20T14:19:48.005Z 2025-11-27T15:12:37.628Z
8523972 8523972 20251119030048_viZ54 PL000E 2025-11-20T14:19:40.754Z 2025-11-27T15:12:35.937Z
8523809 8523809 20251119024428_ZyC8d PL000E 2025-11-20T14:19:26.186Z 2025-11-27T15:12:28.694Z
8523657 8523657 20251119023016_575vn PL000E 2025-11-20T14:18:57.152Z 2025-11-27T15:12:24.627Z
8523469 8523469 20251119021022_c2qRD PL000E 2025-11-20T14:18:23.970Z 2025-11-27T15:12:21.236Z
8523411 8523411 20251119020356_u3uKu PL000E 2025-11-20T14:18:16.882Z 2025-11-27T15:12:16.058Z
8523336 8523336 20251119015605_rpyyi PL000E 2025-11-20T14:18:10.093Z 2025-11-27T15:12:12.190Z
8523307 8523307 20251119015157_arKxt PL000E 2025-11-20T14:18:06.849Z 2025-11-27T15:12:11.741Z
8523247 8523247 20251119014543_BQEkL PL000E 2025-11-20T14:18:01.359Z 2025-11-27T15:12:10.937Z
8522931 8522931 20251119010937_u35Mp PL000E 2025-11-20T14:16:58.981Z 2025-11-27T15:12:07.803Z
8522659 8522659 20251119004127_GxNHP PL000E 2025-11-20T14:16:12.056Z 2025-11-27T15:12:05.668Z
8522638 8522638 20251119004013_2kqly PL000E 2025-11-20T14:16:09.929Z 2025-11-27T15:12:05.574Z
8522631 8522631 20251119004008_NzgZ0 PL000E 2025-11-20T14:16:09.229Z 2025-11-27T15:12:05.533Z
8522622 8522622 20251119003921_7rHrx PL000E 2025-11-20T14:16:07.826Z 2025-11-27T15:12:05.443Z
8522488 8522488 20251119001900_qQm9g PL000E 2025-11-20T14:15:34.799Z 2025-11-27T15:12:02.981Z
8522477 8522477 20251119001743_apsm5 PL000E 2025-11-20T14:15:29.157Z 2025-11-27T15:12:02.787Z
8522426 8522426 20251119000952_86KZt PL000E 2025-11-20T14:15:23.848Z 2025-11-27T15:12:01.680Z
8522414 8522414 20251119000651_yok6L PL000E 2025-11-20T14:15:21.924Z 2025-11-27T15:12:01.307Z
8522396 8522396 20251119000425_cw9J4 PL000E 2025-11-20T14:15:20.370Z 2025-11-27T15:12:01.172Z
8522236 8522236 20251118233834_g5B5H PL000E 2025-11-20T14:14:52.496Z 2025-11-27T15:11:58.156Z
8521887 8521887 20251118224332_JIN3H PL000E 2025-11-20T14:13:52.374Z 2025-11-27T15:11:48.482Z
8521849 8521849 20251118223835_PKV6m PL000E 2025-11-20T14:13:48.255Z 2025-11-27T15:11:48.294Z
8521834 8521834 20251118223500_gdtoT PL000E 2025-11-20T14:13:45.094Z 2025-11-27T15:11:48.084Z
8521788 8521788 20251118222303_KGKbE PL000E 2025-11-20T14:13:29.142Z 2025-11-27T15:11:47.426Z
8521621 8521621 20251118213706_gNsZN PL000E 2025-11-20T14:13:03.397Z 2025-11-27T15:11:40.304Z
8510505 8510505 20251118045537_Xiiw2 PL000E 2025-11-19T14:22:06.768Z 2025-11-26T15:08:02.800Z
8510414 8510414 20251118044037_9092v PL000E 2025-11-19T14:21:45.919Z 2025-11-26T15:08:01.782Z
8458532 8458532 20251114003426_BKlW1 PL000E 2025-11-15T14:17:03.806Z 2025-11-22T15:21:09.944Z
8458279 8458279 20251113232802_5TE3Z PL000E 2025-11-15T14:16:07.712Z 2025-11-22T15:21:01.257Z
8458115 8458115 20251113223431_Z8Lum PL000E 2025-11-15T14:15:39.329Z 2025-11-22T15:20:59.043Z
8457903 8457903 20251113214227_UdOpL PL000E 2025-11-15T14:14:53.856Z 2025-11-22T15:20:56.161Z
8455824 8455824 20251113173839_X04IP PL000E 2025-11-15T14:09:56.651Z 2025-11-22T15:20:26.310Z
8450430 8450430 20251113042924_XOuL8 PL000E 2025-11-14T14:23:24.296Z 2025-11-21T15:12:38.423Z
8450405 8450405 20251113042614_qrmKn PL000E 2025-11-14T14:23:22.414Z 2025-11-21T15:12:38.076Z
8450232 8450232 20251113040229_0U6mq PL000E 2025-11-14T14:22:47.845Z 2025-11-21T15:12:30.931Z
8447242 8447242 20251112191624_XgQeB PL000E 2025-11-14T14:13:27.104Z 2025-11-21T15:11:17.248Z
8446930 8446930 20251112183921_DFKmO PL000E 2025-11-14T14:12:31.647Z 2025-11-21T15:11:14.781Z
8396722 8396722 20251107224045_6Bmhv PL000E 2025-11-09T14:09:37.580Z 2025-11-16T15:03:38.748Z
8396362 8396362 20251107203023_B7nnE PL000E 2025-11-09T14:08:15.270Z 2025-11-16T15:03:28.479Z
8396024 8396024 20251107191210_hvh3L PL000E 2025-11-09T14:07:00.101Z 2025-11-16T15:03:05.034Z
8395491 8395491 20251107164520_jaokp PL000E 2025-11-09T14:04:30.742Z 2025-11-16T15:02:28.502Z
8390344 8390344 20251107001021_qN8VN PL000E 2025-11-08T14:10:37.641Z 2025-11-15T15:00:01.025Z
8389606 8389606 20251106214435_Mxqfn PL000E 2025-11-08T14:07:41.492Z 2025-11-15T14:59:43.334Z
8389388 8389388 20251106204743_BtQ1b PL000E 2025-11-08T14:06:44.971Z 2025-11-15T14:59:37.619Z
8389247 8389247 20251106200814_Vx5ss PL000E 2025-11-08T14:06:04.285Z 2025-11-15T14:59:33.552Z
8389068 8389068 20251106190613_EleIU PL000E 2025-11-08T14:05:03.936Z 2025-11-15T14:59:30.458Z
8388772 8388772 20251106170621_JwJu6 PL000E 2025-11-08T14:03:32.549Z 2025-11-15T14:59:17.464Z
8386174 8386174 20251106025803_KcKh0 PL000E 2025-11-07T14:10:00.887Z 2025-11-14T15:08:37.760Z
8385898 8385898 20251106015444_pV2s4 PL000E 2025-11-07T14:08:48.845Z 2025-11-14T15:08:29.399Z
8385808 8385808 20251106013231_fwo3K PL000E 2025-11-07T14:08:14.408Z 2025-11-14T15:08:23.261Z
8385556 8385556 20251106002841_e3kqi PL000E 2025-11-07T14:07:15.146Z 2025-11-14T15:08:16.596Z
8385550 8385550 20251106002254_7Os6E PL000E 2025-11-07T14:07:13.922Z 2025-11-14T15:08:16.577Z
8385477 8385477 20251106000804_X2mK4 PL000E 2025-11-07T14:07:00.674Z 2025-11-14T15:08:15.080Z
8385440 8385440 20251105235659_siOIY PL000E 2025-11-07T14:06:44.522Z 2025-11-14T15:08:12.118Z
8385422 8385422 20251105235102_6hkYr PL000E 2025-11-07T14:06:39.426Z 2025-11-14T15:08:11.849Z
8385390 8385390 20251105233934_2eErr PL000E 2025-11-07T14:06:33.952Z 2025-11-14T15:08:08.418Z
8385373 8385373 20251105232643_IgVem PL000E 2025-11-07T14:06:30.559Z 2025-11-14T15:08:08.117Z
8385362 8385362 20251105232141_AW3LP PL000E 2025-11-07T14:06:28.059Z 2025-11-14T15:08:08.053Z
8385304 8385304 20251105230131_tQqDV PL000E 2025-11-07T14:06:09.633Z 2025-11-14T15:08:07.504Z
8385196 8385196 20251105222311_86X83 PL000E 2025-11-07T14:05:49.027Z 2025-11-14T15:08:04.829Z
8385084 8385084 20251105212740_N4iMM PL000E 2025-11-07T14:05:17.725Z 2025-11-14T15:07:54.315Z
8384921 8384921 20251105193115_k91J9 PL000E 2025-11-07T14:04:34.343Z 2025-11-14T15:07:49.486Z
8342007 8342007 20251031220928_6X0yg PL000E 2025-11-02T14:37:50.015Z 2025-11-09T15:00:23.614Z
8341876 8341876 20251031214536_K9Yhj PL000E 2025-11-02T14:37:45.196Z 2025-11-09T15:00:18.870Z
8341376 8341376 20251031192954_uPucD PL000E 2025-11-02T14:36:35.783Z 2025-11-09T14:59:15.038Z
8336202 8336202 20251031042214_f4vYF PL000E 2025-11-02T14:29:07.267Z 2025-11-08T15:15:41.065Z
8336152 8336152 20251031041905_k2Els PL000E 2025-11-02T14:29:04.356Z 2025-11-08T15:15:39.751Z
8335918 8335918 20251031035729_ljuk4 PL000E 2025-11-02T14:28:17.540Z 2025-11-08T15:15:15.984Z
8335401 8335401 20251031031542_uZUH6 PL000E 2025-11-02T14:27:18.389Z 2025-11-08T15:14:49.455Z
8335270 8335270 20251031030627_N9PxH PL000E 2025-11-02T14:27:08.838Z 2025-11-08T15:14:38.251Z
8335226 8335226 20251031030222_2Bpqj PL000E 2025-11-02T14:27:05.084Z 2025-11-08T15:14:33.527Z
8335053 8335053 20251031024803_6RDC2 PL000E 2025-11-02T14:26:30.056Z 2025-11-08T15:14:23.643Z
8334181 8334181 20251031012905_8PlOj PL000E 2025-11-02T14:24:30.671Z 2025-11-08T15:13:12.134Z
8334125 8334125 20251031012449_lb8Hq PL000E 2025-11-02T14:24:26.045Z 2025-11-08T15:13:10.124Z
8334029 8334029 20251031011500_LBEXE PL000E 2025-11-02T14:24:17.915Z 2025-11-08T15:13:05.928Z
8333696 8333696 20251031003853_mNHMo PL000E 2025-11-02T14:23:28.711Z 2025-11-08T15:12:58.334Z
8333315 8333315 20251030235841_xmQeJ PL000E 2025-11-02T14:22:13.540Z 2025-11-08T15:12:51.898Z
8333231 8333231 20251030235028_k1ZEG PL000E 2025-11-02T14:22:04.221Z 2025-11-08T15:12:50.322Z
8332873 8332873 20251030230851_3FRH5 PL000E 2025-11-02T14:21:10.664Z 2025-11-08T15:12:44.271Z
8332840 8332840 20251030230455_rNl55 PL000E 2025-11-02T14:21:08.917Z 2025-11-08T15:12:44.084Z
8332573 8332573 20251030222418_ZTJQJ PL000E 2025-11-02T14:20:23.091Z 2025-11-08T15:12:40.072Z
8332463 8332463 20251030220652_2sJGN PL000E 2025-11-02T14:20:13.122Z 2025-11-08T15:12:32.929Z
8317855 8317855 20251030210123_UwXOZ PL000E 2025-11-01T12:11:22.086Z 2025-11-08T15:11:47.990Z

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