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

370 rows where station_code = "PL000D" 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
9614049 9614049 20260405215734_XH2Sc PL000D 2026-04-07T12:07:51.279Z 2026-04-07T12:13:19.511Z
9608913 9608913 20260404023401_f1jBn PL000D 2026-04-05T12:12:17.296Z 2026-04-07T12:18:33.462Z
9608853 9608853 20260404020008_aK49b PL000D 2026-04-05T12:11:57.494Z 2026-04-07T12:18:31.080Z
9608801 9608801 20260404013518_KrSGH PL000D 2026-04-05T12:11:48.339Z 2026-04-07T12:18:29.307Z
9600800 9600800 20260401025940_OTjpT PL000D 2026-04-02T12:00:20.536Z 2026-04-07T12:20:35.928Z
9579686 9579686 20260324221800_2ikGR PL000D 2026-03-26T12:14:12.932Z 2026-04-02T12:37:26.064Z
9576704 9576704 20260325025735_7n8pc PL000D 2026-03-26T12:03:03.476Z 2026-04-03T12:36:18.281Z
9576698 9576698 20260325025644_GPYOo PL000D 2026-03-26T12:03:02.494Z 2026-04-03T12:36:18.022Z
9576586 9576586 20260325023705_TeaiH PL000D 2026-03-26T12:02:41.636Z 2026-04-03T12:36:13.530Z
9576000 9576000 20260325005619_CjXmj PL000D 2026-03-26T12:00:56.020Z 2026-04-03T12:35:40.459Z
9575614 9575614 20260323234432_wFxuc PL000D 2026-03-25T12:21:31.099Z 2026-03-31T12:29:03.097Z
9571291 9571291 20260324005338_2QV1J PL000D 2026-03-25T12:00:50.136Z 2026-04-02T12:34:18.171Z
9570542 9570542 20260322215918_L1q13 PL000D 2026-03-24T12:23:26.364Z 2026-03-30T12:30:45.168Z
9562001 9562001 20260323011019_SQ5t6 PL000D 2026-03-24T12:01:50.388Z 2026-03-31T12:25:58.906Z
9561954 9561954 20260323010145_jlQ1T PL000D 2026-03-24T12:01:41.106Z 2026-03-31T12:25:57.355Z
9561406 9561406 20260321233044_uc2qG PL000D 2026-03-23T12:12:18.437Z 2026-03-29T12:21:07.044Z
9560104 9560104 20260321203228_ZVuPE PL000D 2026-03-23T12:11:38.167Z 2026-03-29T12:20:57.967Z
9553748 9553748 20260322021055_0zrtS PL000D 2026-03-23T12:01:49.651Z 2026-03-30T12:27:51.923Z
9534032 9534032 20260320031921_2JUZa PL000D 2026-03-21T12:06:57.689Z 2026-03-28T12:34:04.240Z
9531661 9531661 20260319233404_Aha5k PL000D 2026-03-21T12:00:26.347Z 2026-03-28T12:33:19.920Z
9530020 9530020 20260318195547_i358v PL000D 2026-03-20T12:23:54.870Z 2026-03-26T12:39:08.393Z
9529822 9529822 20260318193506_QWVHr PL000D 2026-03-20T12:23:44.728Z 2026-03-26T12:39:06.794Z
9520652 9520652 20260319033023_yJmez PL000D 2026-03-20T12:06:45.390Z 2026-03-27T12:40:45.974Z
9520608 9520608 20260319032730_LEGds PL000D 2026-03-20T12:06:40.388Z 2026-03-27T12:40:45.433Z
9520156 9520156 20260319025710_8cdU4 PL000D 2026-03-20T12:05:50.930Z 2026-03-27T12:40:39.698Z
9520118 9520118 20260319025503_tYYWQ PL000D 2026-03-20T12:05:46.521Z 2026-03-27T12:40:39.252Z
9519675 9519675 20260319022628_QbsLu PL000D 2026-03-20T12:04:52.784Z 2026-03-27T12:40:34.051Z
9519503 9519503 20260319021420_p2wHZ PL000D 2026-03-20T12:04:34.133Z 2026-03-27T12:40:31.923Z
9518679 9518679 20260319011742_qaXUm PL000D 2026-03-20T12:03:05.922Z 2026-03-27T12:40:12.619Z
9517482 9517482 20260318233152_fHiyL PL000D 2026-03-20T12:00:29.292Z 2026-03-27T12:40:00.117Z
9509608 9509608 20260318020040_NsaJs PL000D 2026-03-19T12:05:46.322Z 2026-03-26T12:37:06.617Z
9494613 9494613 20260316023710_IH3mY PL000D 2026-03-17T12:04:23.482Z 2026-03-24T12:40:48.764Z
9493000 9493000 20260314222856_ai3Rh PL000D 2026-03-16T12:29:16.149Z 2026-03-22T12:42:56.325Z
9492686 9492686 20260314213912_to9FA PL000D 2026-03-16T12:28:56.447Z 2026-03-22T12:42:53.905Z
9492553 9492553 20260314211703_E8Hze PL000D 2026-03-16T12:28:43.026Z 2026-03-22T12:42:52.995Z
9492057 9492057 20260314190300_oCics PL000D 2026-03-16T12:27:58.335Z 2026-03-22T12:42:49.817Z
9485604 9485604 20260315032301_EUUAB PL000D 2026-03-16T12:06:56.217Z 2026-03-23T12:21:53.081Z
9485425 9485425 20260315030419_6Bdzi PL000D 2026-03-16T12:06:25.005Z 2026-03-23T12:21:52.235Z
9485298 9485298 20260315024743_zJvYb PL000D 2026-03-16T12:05:58.502Z 2026-03-23T12:21:50.875Z
9485206 9485206 20260315023949_XK354 PL000D 2026-03-16T12:05:37.243Z 2026-03-23T12:21:50.473Z
9484669 9484669 20260315012654_7fTBE PL000D 2026-03-16T12:03:42.731Z 2026-03-23T12:21:47.811Z
9484575 9484575 20260315010448_VrmP9 PL000D 2026-03-16T12:03:21.152Z 2026-03-23T12:21:47.340Z
9484161 9484161 20260314235816_m1YTp PL000D 2026-03-16T12:01:47.100Z 2026-03-23T12:21:45.694Z
9484104 9484104 20260314235008_AXEL2 PL000D 2026-03-16T12:01:33.632Z 2026-03-23T12:21:45.421Z
9484003 9484003 20260314233457_3pUVe PL000D 2026-03-16T12:01:11.899Z 2026-03-23T12:21:44.774Z
9483843 9483843 20260314232021_f226k PL000D 2026-03-16T12:00:51.499Z 2026-03-23T12:21:44.270Z
9483430 9483430 20260313221427_D2Vh3 PL000D 2026-03-15T12:26:30.582Z 2026-03-21T12:50:27.643Z
9476637 9476637 20260314032159_mWo73 PL000D 2026-03-15T12:06:30.195Z 2026-03-22T12:41:58.203Z
9476375 9476375 20260314025950_YcZST PL000D 2026-03-15T12:05:46.857Z 2026-03-22T12:41:56.299Z
9476306 9476306 20260314025332_Vbbwi PL000D 2026-03-15T12:05:33.015Z 2026-03-22T12:41:55.709Z
9476242 9476242 20260314024629_916T9 PL000D 2026-03-15T12:05:22.577Z 2026-03-22T12:41:55.127Z
9476181 9476181 20260314024106_5S7Dp PL000D 2026-03-15T12:05:12.976Z 2026-03-22T12:41:54.712Z
9476138 9476138 20260314024019_mJPLH PL000D 2026-03-15T12:05:08.470Z 2026-03-22T12:41:54.382Z
9475483 9475483 20260314013150_1rHa7 PL000D 2026-03-15T12:03:15.584Z 2026-03-22T12:41:40.455Z
9475325 9475325 20260314011442_oO5Fk PL000D 2026-03-15T12:02:52.477Z 2026-03-22T12:41:33.232Z
9475247 9475247 20260314010304_BZPhT PL000D 2026-03-15T12:02:37.634Z 2026-03-22T12:41:29.345Z
9474977 9474977 20260314002319_EfAg6 PL000D 2026-03-15T12:01:55.221Z 2026-03-22T12:41:25.917Z
9469155 9469155 20260313020336_UIgj1 PL000D 2026-03-14T12:03:10.998Z 2026-03-21T12:48:34.308Z
9468973 9468973 20260313012646_DbFc3 PL000D 2026-03-14T12:02:31.629Z 2026-03-21T12:48:32.137Z
9467025 9467025 20260311194001_Du2ZG PL000D 2026-03-13T12:18:06.125Z 2026-03-19T12:45:47.028Z
9463712 9463712 20260312022945_c3nzr PL000D 2026-03-13T12:04:56.684Z 2026-03-20T12:36:24.234Z
9463145 9463145 20260312010604_7Fj3M PL000D 2026-03-13T12:03:15.631Z 2026-03-20T12:36:20.037Z
9462598 9462598 20260311234322_lWXie PL000D 2026-03-13T12:01:35.032Z 2026-03-20T12:36:17.047Z
9460707 9460707 20260310215615_NkHTA PL000D 2026-03-12T12:14:57.543Z 2026-03-18T12:40:18.206Z
9455630 9455630 20260309192952_dTvAZ PL000D 2026-03-11T12:14:41.927Z 2026-03-17T12:42:36.997Z
9451306 9451306 20260310014202_07CZJ PL000D 2026-03-11T12:02:24.826Z 2026-03-18T12:38:44.670Z
9450860 9450860 20260309233849_Y0bes PL000D 2026-03-11T12:00:57.110Z 2026-03-18T12:38:37.027Z
9450369 9450369 20260308205505_aaSlh PL000D 2026-03-10T12:19:29.202Z 2026-03-16T12:44:41.399Z
9446793 9446793 20260309030336_2Ddmg PL000D 2026-03-10T12:03:56.203Z 2026-03-17T12:41:43.015Z
9446690 9446690 20260309023910_dsrRR PL000D 2026-03-10T12:03:29.380Z 2026-03-17T12:41:41.375Z
9446688 9446688 20260309023910_XWYKZ PL000D 2026-03-10T12:03:29.012Z 2026-03-17T12:41:41.348Z
9446658 9446658 20260309023153_9jvWm PL000D 2026-03-10T12:03:19.705Z 2026-03-17T12:41:40.802Z
9446530 9446530 20260309020119_2YZKH PL000D 2026-03-10T12:02:48.699Z 2026-03-17T12:41:39.366Z
9446464 9446464 20260309014406_bPp3m PL000D 2026-03-10T12:02:33.965Z 2026-03-17T12:41:38.589Z
9446419 9446419 20260309013610_DAqWi PL000D 2026-03-10T12:02:23.115Z 2026-03-17T12:41:37.893Z
9446076 9446076 20260308234314_Kr2fl PL000D 2026-03-10T12:00:54.506Z 2026-03-17T12:41:20.266Z
9445705 9445705 20260307211426_9UI4k PL000D 2026-03-09T12:20:27.750Z 2026-03-15T12:42:13.492Z
9445329 9445329 20260307181321_Lac7g PL000D 2026-03-09T12:18:30.318Z 2026-03-15T12:42:06.090Z
9441327 9441327 20260306210823_htpzW PL000D 2026-03-08T12:21:27.445Z 2026-03-14T12:40:50.578Z
9441138 9441138 20260306200713_539vy PL000D 2026-03-08T12:20:35.503Z 2026-03-14T12:40:45.516Z
9441125 9441125 20260306195732_FQm2R PL000D 2026-03-08T12:20:30.337Z 2026-03-14T12:40:45.039Z
9440964 9440964 20260306183857_y1mRq PL000D 2026-03-08T12:19:56.647Z 2026-03-14T12:40:40.632Z
9436809 9436809 20260307000427_O8pNQ PL000D 2026-03-08T12:01:20.395Z 2026-03-15T12:40:58.023Z
9432204 9432204 20260306035705_wDSmB PL000D 2026-03-07T14:03:50.517Z 2026-03-14T12:39:26.747Z
9432141 9432141 20260306034103_VKydS PL000D 2026-03-07T14:03:36.576Z 2026-03-14T12:39:25.747Z
9431929 9431929 20260306024042_ooEZb PL000D 2026-03-07T14:02:33.699Z 2026-03-14T12:39:20.813Z
9431724 9431724 20260306013323_Md3hR PL000D 2026-03-07T14:01:46.185Z 2026-03-14T12:39:16.703Z
9431411 9431411 20260305232709_IT3xx PL000D 2026-03-07T14:00:33.620Z 2026-03-14T12:39:12.247Z
9422765 9422765 20260304040336_2v5nS PL000D 2026-03-05T14:02:35.427Z 2026-03-12T12:32:35.102Z
9419385 9419385 20260303031939_7RNyS PL000D 2026-03-04T14:01:19.314Z 2026-03-11T12:27:59.521Z
9419272 9419272 20260303024323_19UxZ PL000D 2026-03-04T14:01:08.112Z 2026-03-11T12:27:48.119Z
9419181 9419181 20260303020316_zyouQ PL000D 2026-03-04T14:00:54.752Z 2026-03-11T12:27:46.295Z
9419138 9419138 20260303014353_vyXb8 PL000D 2026-03-04T14:00:49.740Z 2026-03-11T12:27:45.615Z
9419082 9419082 20260303011207_v3gDS PL000D 2026-03-04T14:00:42.049Z 2026-03-11T12:27:44.650Z
9415200 9415200 20260228204746_nEL8x PL000D 2026-03-02T14:07:33.265Z 2026-03-08T12:43:05.481Z
9415188 9415188 20260228204618_WxMiG PL000D 2026-03-02T14:07:32.366Z 2026-03-08T12:43:05.069Z
9412496 9412496 20260301034556_2QA8z PL000D 2026-03-02T14:01:29.989Z 2026-03-09T12:39:40.694Z
9412429 9412429 20260301032938_cK8hg PL000D 2026-03-02T14:01:22.224Z 2026-03-09T12:39:38.687Z
9412327 9412327 20260301024511_pf2kL PL000D 2026-03-02T14:01:07.305Z 2026-03-09T12:39:34.819Z
9412144 9412144 20260301005324_7ctok PL000D 2026-03-02T14:00:38.840Z 2026-03-09T12:39:20.883Z

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