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

801 rows where station_code = "PL000F" 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
9613351 9613351 20260405193811_zF6Vz PL000F 2026-04-07T12:06:29.139Z 2026-04-07T12:13:19.362Z
9611645 9611645 20260405025428_cW9vM PL000F 2026-04-06T12:15:28.072Z 2026-04-07T12:16:19.672Z
9611559 9611559 20260405023520_sIL9s PL000F 2026-04-06T12:15:06.368Z 2026-04-07T12:16:15.927Z
9611556 9611556 20260405023421_YEPv9 PL000F 2026-04-06T12:15:05.655Z 2026-04-07T12:16:15.816Z
9611320 9611320 20260405012615_yyiAX PL000F 2026-04-06T12:14:00.840Z 2026-04-07T12:16:04.322Z
9610522 9610522 20260404200957_pRNIk PL000F 2026-04-06T12:09:54.783Z 2026-04-07T12:15:13.917Z
9608470 9608470 20260403231341_q0VJr PL000F 2026-04-05T12:10:31.549Z 2026-04-07T12:18:11.825Z
9576013 9576013 20260325005814_31t1K PL000F 2026-03-26T12:00:57.798Z 2026-04-03T12:35:40.770Z
9575608 9575608 20260323234138_0UK3f PL000F 2026-03-25T12:21:30.413Z 2026-03-31T12:29:02.964Z
9570648 9570648 20260322222233_Cm3yY PL000F 2026-03-24T12:23:35.131Z 2026-03-30T12:30:47.080Z
9560689 9560689 20260321220231_6jTM7 PL000F 2026-03-23T12:12:01.188Z 2026-03-29T12:21:02.185Z
9560221 9560221 20260321204849_XGdLo PL000F 2026-03-23T12:11:40.399Z 2026-03-29T12:20:58.672Z
9560085 9560085 20260321203143_zErt3 PL000F 2026-03-23T12:11:37.734Z 2026-03-29T12:20:57.858Z
9559711 9559711 20260321193353_su14F PL000F 2026-03-23T12:11:27.906Z 2026-03-29T12:20:47.083Z
9559579 9559579 20260321182251_Bdeku PL000F 2026-03-23T12:11:12.726Z 2026-03-29T12:20:41.368Z
9554165 9554165 20260322024421_aMF5B PL000F 2026-03-23T12:02:17.666Z 2026-03-30T12:27:59.532Z
9553502 9553502 20260322014549_Pmrbv PL000F 2026-03-23T12:01:34.731Z 2026-03-30T12:27:42.299Z
9553389 9553389 20260322013718_73Q8r PL000F 2026-03-23T12:01:27.119Z 2026-03-30T12:27:40.226Z
9533584 9533584 20260320024528_BYha2 PL000F 2026-03-21T12:05:49.453Z 2026-03-28T12:33:56.722Z
9533540 9533540 20260320024032_0F2p3 PL000F 2026-03-21T12:05:39.479Z 2026-03-28T12:33:55.330Z
9532510 9532510 20260320010400_Y2o9Q PL000F 2026-03-21T12:02:57.973Z 2026-03-28T12:33:33.103Z
9532367 9532367 20260320004924_Cipni PL000F 2026-03-21T12:02:30.172Z 2026-03-28T12:33:28.591Z
9532323 9532323 20260320004704_Cjdbc PL000F 2026-03-21T12:02:23.247Z 2026-03-28T12:33:27.691Z
9531662 9531662 20260319233404_Aha5k PL000F 2026-03-21T12:00:26.347Z 2026-03-28T12:33:19.920Z
9531186 9531186 20260318224058_CMtH3 PL000F 2026-03-20T12:25:00.868Z 2026-03-26T12:39:17.958Z
9531102 9531102 20260318222559_5NV0n PL000F 2026-03-20T12:24:57.597Z 2026-03-26T12:39:17.435Z
9531081 9531081 20260318222450_cslYZ PL000F 2026-03-20T12:24:56.783Z 2026-03-26T12:39:17.350Z
9531013 9531013 20260318221419_28ybl PL000F 2026-03-20T12:24:54.636Z 2026-03-26T12:39:16.950Z
9520845 9520845 20260319034109_9o33d PL000F 2026-03-20T12:07:03.888Z 2026-03-27T12:40:47.975Z
9520479 9520479 20260319031820_w1LDQ PL000F 2026-03-20T12:06:25.740Z 2026-03-27T12:40:43.760Z
9519788 9519788 20260319023617_sh5pT PL000F 2026-03-20T12:05:07.042Z 2026-03-27T12:40:35.581Z
9519449 9519449 20260319021044_ahA9C PL000F 2026-03-20T12:04:29.570Z 2026-03-27T12:40:31.275Z
9518935 9518935 20260319013557_BOMtS PL000F 2026-03-20T12:03:38.003Z 2026-03-27T12:40:16.550Z
9518163 9518163 20260319003820_vIek2 PL000F 2026-03-20T12:02:01.970Z 2026-03-27T12:40:06.941Z
9518025 9518025 20260319002223_456mh PL000F 2026-03-20T12:01:45.374Z 2026-03-27T12:40:05.665Z
9517908 9517908 20260319001058_NylAl PL000F 2026-03-20T12:01:30.777Z 2026-03-27T12:40:04.607Z
9517805 9517805 20260319000448_SPr0T PL000F 2026-03-20T12:01:20.257Z 2026-03-27T12:40:03.585Z
9509806 9509806 20260318021540_ffFfN PL000F 2026-03-19T12:06:14.291Z 2026-03-26T12:37:07.973Z
9501295 9501295 20260315214756_BU3eg PL000F 2026-03-17T12:24:47.883Z 2026-03-23T12:22:43.866Z
9494371 9494371 20260316020503_sbt9c PL000F 2026-03-17T12:03:49.218Z 2026-03-24T12:40:47.276Z
9493028 9493028 20260314223353_dKyD0 PL000F 2026-03-16T12:29:17.816Z 2026-03-22T12:42:56.473Z
9492708 9492708 20260314214220_gFL6r PL000F 2026-03-16T12:28:57.592Z 2026-03-22T12:42:54.009Z
9485820 9485820 20260315035948_X3DsM PL000F 2026-03-16T12:07:46.608Z 2026-03-23T12:21:54.242Z
9485816 9485816 20260315035914_2LA2c PL000F 2026-03-16T12:07:45.147Z 2026-03-23T12:21:54.209Z
9485683 9485683 20260315034121_oij3t PL000F 2026-03-16T12:07:15.667Z 2026-03-23T12:21:53.481Z
9485326 9485326 20260315025052_YzpXQ PL000F 2026-03-16T12:06:02.697Z 2026-03-23T12:21:50.995Z
9485092 9485092 20260315022613_wSefr PL000F 2026-03-16T12:05:15.945Z 2026-03-23T12:21:49.989Z
9484915 9484915 20260315015910_a5VFD PL000F 2026-03-16T12:04:36.461Z 2026-03-23T12:21:49.006Z
9484144 9484144 20260314235536_H2vgh PL000F 2026-03-16T12:01:40.660Z 2026-03-23T12:21:45.561Z
9483995 9483995 20260314233420_2laLM PL000F 2026-03-16T12:01:10.261Z 2026-03-23T12:21:44.729Z
9476079 9476079 20260314023619_F7cn2 PL000F 2026-03-15T12:05:02.134Z 2026-03-22T12:41:54.100Z
9475997 9475997 20260314022959_sh6Ow PL000F 2026-03-15T12:04:50.475Z 2026-03-22T12:41:53.640Z
9475633 9475633 20260314015012_1MkUD PL000F 2026-03-15T12:03:40.367Z 2026-03-22T12:41:46.295Z
9475574 9475574 20260314014214_qe1Hy PL000F 2026-03-15T12:03:29.786Z 2026-03-22T12:41:43.264Z
9475226 9475226 20260314010013_2OV7P PL000F 2026-03-15T12:02:33.781Z 2026-03-22T12:41:28.550Z
9475184 9475184 20260314005141_dLknW PL000F 2026-03-15T12:02:27.481Z 2026-03-22T12:41:27.659Z
9474973 9474973 20260314002239_BrtG4 PL000F 2026-03-15T12:01:54.197Z 2026-03-22T12:41:25.879Z
9474669 9474669 20260313233434_ci5da PL000F 2026-03-15T12:00:54.065Z 2026-03-22T12:41:23.132Z
9469833 9469833 20260313034942_D6pSR PL000F 2026-03-14T12:05:41.425Z 2026-03-21T12:49:02.875Z
9469761 9469761 20260313034300_P494U PL000F 2026-03-14T12:05:27.276Z 2026-03-21T12:49:01.990Z
9469425 9469425 20260313024723_i7kzK PL000F 2026-03-14T12:04:12.434Z 2026-03-21T12:48:38.933Z
9469316 9469316 20260313022847_FZu7w PL000F 2026-03-14T12:03:49.579Z 2026-03-21T12:48:37.457Z
9466909 9466909 20260311182245_zlgoq PL000F 2026-03-13T12:17:33.292Z 2026-03-19T12:45:40.676Z
9464045 9464045 20260312032523_NWwhQ PL000F 2026-03-13T12:06:03.202Z 2026-03-20T12:36:28.299Z
9463919 9463919 20260312030429_ETJQQ PL000F 2026-03-13T12:05:37.241Z 2026-03-20T12:36:25.652Z
9463889 9463889 20260312030054_tB2Bl PL000F 2026-03-13T12:05:31.209Z 2026-03-20T12:36:25.424Z
9463498 9463498 20260312015923_fOqkO PL000F 2026-03-13T12:04:22.473Z 2026-03-20T12:36:22.944Z
9463486 9463486 20260312015800_THBXP PL000F 2026-03-13T12:04:20.763Z 2026-03-20T12:36:22.898Z
9463324 9463324 20260312013134_uFn13 PL000F 2026-03-13T12:03:50.996Z 2026-03-20T12:36:21.900Z
9463201 9463201 20260312011320_U3Pbp PL000F 2026-03-13T12:03:26.921Z 2026-03-20T12:36:20.453Z
9463115 9463115 20260312010449_5Mrwz PL000F 2026-03-13T12:03:10.364Z 2026-03-20T12:36:19.787Z
9462579 9462579 20260311234057_yAc1k PL000F 2026-03-13T12:01:29.903Z 2026-03-20T12:36:16.928Z
9457003 9457003 20260311020403_2WNtt PL000F 2026-03-12T12:02:33.337Z 2026-03-19T12:44:24.646Z
9455681 9455681 20260309193906_ixFCf PL000F 2026-03-11T12:14:47.052Z 2026-03-17T12:42:37.583Z
9455544 9455544 20260309183711_1G3c2 PL000F 2026-03-11T12:14:32.516Z 2026-03-17T12:42:34.376Z
9451745 9451745 20260310033652_Mgv31 PL000F 2026-03-11T12:03:42.940Z 2026-03-18T12:39:03.779Z
9451694 9451694 20260310032411_Jj42V PL000F 2026-03-11T12:03:36.100Z 2026-03-18T12:39:02.907Z
9451659 9451659 20260310031519_2NRlo PL000F 2026-03-11T12:03:28.277Z 2026-03-18T12:39:02.261Z
9451411 9451411 20260310020633_xU0iv PL000F 2026-03-11T12:02:43.253Z 2026-03-18T12:38:46.004Z
9451328 9451328 20260310014638_MTR9h PL000F 2026-03-11T12:02:27.698Z 2026-03-18T12:38:44.843Z
9451305 9451305 20260310014045_17Dg8 PL000F 2026-03-11T12:02:24.552Z 2026-03-18T12:38:44.620Z
9451118 9451118 20260310004610_aA9NG PL000F 2026-03-11T12:01:46.922Z 2026-03-18T12:38:40.681Z
9451033 9451033 20260310002741_pdMeq PL000F 2026-03-11T12:01:30.510Z 2026-03-18T12:38:39.469Z
9450487 9450487 20260308220043_M26Mc PL000F 2026-03-10T12:19:47.439Z 2026-03-16T12:44:43.545Z
9450367 9450367 20260308205357_hd302 PL000F 2026-03-10T12:19:25.913Z 2026-03-16T12:44:41.397Z
9446957 9446957 20260309034506_7c1LD PL000F 2026-03-10T12:04:35.564Z 2026-03-17T12:41:45.255Z
9446817 9446817 20260309030729_paj2a PL000F 2026-03-10T12:04:02.696Z 2026-03-17T12:41:43.293Z
9446789 9446789 20260309030210_X6h8M PL000F 2026-03-10T12:03:53.958Z 2026-03-17T12:41:42.927Z
9446713 9446713 20260309024218_uRjBY PL000F 2026-03-10T12:03:33.345Z 2026-03-17T12:41:41.590Z
9446585 9446585 20260309021627_htU93 PL000F 2026-03-10T12:03:02.919Z 2026-03-17T12:41:39.993Z
9446489 9446489 20260309015059_i40h2 PL000F 2026-03-10T12:02:40.260Z 2026-03-17T12:41:38.883Z
9446016 9446016 20260308231743_RNJ7E PL000F 2026-03-10T12:00:34.914Z 2026-03-17T12:41:19.242Z
9445605 9445605 20260307205011_025dq PL000F 2026-03-09T12:20:02.308Z 2026-03-15T12:42:11.962Z
9445328 9445328 20260307181021_zKPyX PL000F 2026-03-09T12:18:27.667Z 2026-03-15T12:42:06.050Z
9441843 9441843 20260307235903_elMaM PL000F 2026-03-09T12:01:29.560Z 2026-03-16T12:43:32.249Z
9441627 9441627 20260307225724_SqMtV PL000F 2026-03-09T12:00:28.915Z 2026-03-16T12:43:28.520Z
9440987 9440987 20260306185211_CJOmD PL000F 2026-03-08T12:20:02.032Z 2026-03-14T12:40:41.264Z
9437392 9437392 20260307032942_ULJzU PL000F 2026-03-08T12:03:48.313Z 2026-03-15T12:41:07.094Z
9437355 9437355 20260307031404_xMONf PL000F 2026-03-08T12:03:39.854Z 2026-03-15T12:41:06.432Z
9437149 9437149 20260307021317_G19kS PL000F 2026-03-08T12:02:44.692Z 2026-03-15T12:41:02.723Z

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