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

529 rows where station_code = "PL000G" 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
9614056 9614056 20260405220014_M2EFo PL000G 2026-04-07T12:07:52.297Z 2026-04-07T12:13:19.513Z
9608802 9608802 20260404013518_KrSGH PL000G 2026-04-05T12:11:48.339Z 2026-04-07T12:18:29.307Z
9579992 9579992 20260324234544_VAp7c PL000G 2026-03-26T12:14:49.975Z 2026-04-02T12:37:38.224Z
9576705 9576705 20260325025735_7n8pc PL000G 2026-03-26T12:03:03.476Z 2026-04-03T12:36:18.281Z
9576699 9576699 20260325025644_GPYOo PL000G 2026-03-26T12:03:02.494Z 2026-04-03T12:36:18.022Z
9576587 9576587 20260325023705_TeaiH PL000G 2026-03-26T12:02:41.636Z 2026-04-03T12:36:13.530Z
9576001 9576001 20260325005619_CjXmj PL000G 2026-03-26T12:00:56.031Z 2026-04-03T12:35:40.459Z
9562002 9562002 20260323011019_SQ5t6 PL000G 2026-03-24T12:01:50.388Z 2026-03-31T12:25:58.906Z
9561955 9561955 20260323010145_jlQ1T PL000G 2026-03-24T12:01:41.124Z 2026-03-31T12:25:57.355Z
9561407 9561407 20260321233044_uc2qG PL000G 2026-03-23T12:12:18.437Z 2026-03-29T12:21:07.044Z
9560049 9560049 20260321202529_rkOUh PL000G 2026-03-23T12:11:36.580Z 2026-03-29T12:20:57.514Z
9553749 9553749 20260322021055_0zrtS PL000G 2026-03-23T12:01:49.680Z 2026-03-30T12:27:51.923Z
9534033 9534033 20260320031921_2JUZa PL000G 2026-03-21T12:06:57.689Z 2026-03-28T12:34:04.240Z
9533669 9533669 20260320025102_iVhAR PL000G 2026-03-21T12:05:59.905Z 2026-03-28T12:33:58.182Z
9532023 9532023 20260320001003_5cH2a PL000G 2026-03-21T12:01:27.714Z 2026-03-28T12:33:23.922Z
9530465 9530465 20260318205746_UG6Kj PL000G 2026-03-20T12:24:25.255Z 2026-03-26T12:39:12.639Z
9530137 9530137 20260318201527_wnCR3 PL000G 2026-03-20T12:24:02.660Z 2026-03-26T12:39:09.612Z
9530021 9530021 20260318195547_i358v PL000G 2026-03-20T12:23:54.870Z 2026-03-26T12:39:08.393Z
9529823 9529823 20260318193506_QWVHr PL000G 2026-03-20T12:23:44.728Z 2026-03-26T12:39:06.794Z
9520653 9520653 20260319033023_yJmez PL000G 2026-03-20T12:06:45.390Z 2026-03-27T12:40:45.974Z
9520609 9520609 20260319032730_LEGds PL000G 2026-03-20T12:06:40.388Z 2026-03-27T12:40:45.433Z
9520119 9520119 20260319025503_tYYWQ PL000G 2026-03-20T12:05:46.521Z 2026-03-27T12:40:39.252Z
9519504 9519504 20260319021420_p2wHZ PL000G 2026-03-20T12:04:34.134Z 2026-03-27T12:40:31.923Z
9518495 9518495 20260319010438_nSa0z PL000G 2026-03-20T12:02:42.440Z 2026-03-27T12:40:10.604Z
9517483 9517483 20260318233152_fHiyL PL000G 2026-03-20T12:00:29.335Z 2026-03-27T12:40:00.117Z
9501349 9501349 20260315220312_GBWfr PL000G 2026-03-17T12:24:51.655Z 2026-03-23T12:22:44.047Z
9494614 9494614 20260316023710_IH3mY PL000G 2026-03-17T12:04:23.495Z 2026-03-24T12:40:48.764Z
9485426 9485426 20260315030419_6Bdzi PL000G 2026-03-16T12:06:25.005Z 2026-03-23T12:21:52.235Z
9485207 9485207 20260315023949_XK354 PL000G 2026-03-16T12:05:37.243Z 2026-03-23T12:21:50.473Z
9485019 9485019 20260315021547_GbuTx PL000G 2026-03-16T12:04:58.161Z 2026-03-23T12:21:49.599Z
9484641 9484641 20260315011856_p0REr PL000G 2026-03-16T12:03:35.935Z 2026-03-23T12:21:47.663Z
9484576 9484576 20260315010448_VrmP9 PL000G 2026-03-16T12:03:21.152Z 2026-03-23T12:21:47.340Z
9484414 9484414 20260315003733_8DgBs PL000G 2026-03-16T12:02:47.714Z 2026-03-23T12:21:46.646Z
9483967 9483967 20260314233210_bhksF PL000G 2026-03-16T12:01:06.712Z 2026-03-23T12:21:44.664Z
9483844 9483844 20260314232021_f226k PL000G 2026-03-16T12:00:51.514Z 2026-03-23T12:21:44.270Z
9476639 9476639 20260314032159_ej9hd PL000G 2026-03-15T12:06:31.648Z 2026-03-22T12:41:58.244Z
9476274 9476274 20260314025108_F3O3W PL000G 2026-03-15T12:05:28.504Z 2026-03-22T12:41:55.514Z
9476244 9476244 20260314024629_AT8L7 PL000G 2026-03-15T12:05:23.066Z 2026-03-22T12:41:55.154Z
9469156 9469156 20260313020336_UIgj1 PL000G 2026-03-14T12:03:10.998Z 2026-03-21T12:48:34.308Z
9469126 9469126 20260313015440_ryRC5 PL000G 2026-03-14T12:03:04.789Z 2026-03-21T12:48:33.854Z
9468974 9468974 20260313012646_DbFc3 PL000G 2026-03-14T12:02:31.649Z 2026-03-21T12:48:32.137Z
9463713 9463713 20260312022945_c3nzr PL000G 2026-03-13T12:04:56.684Z 2026-03-20T12:36:24.234Z
9463221 9463221 20260312011806_LMN9s PL000G 2026-03-13T12:03:31.122Z 2026-03-20T12:36:21.368Z
9463146 9463146 20260312010604_7Fj3M PL000G 2026-03-13T12:03:15.631Z 2026-03-20T12:36:20.037Z
9462538 9462538 20260311233551_BQmzL PL000G 2026-03-13T12:01:18.631Z 2026-03-20T12:36:16.681Z
9457173 9457173 20260311025646_GSG4X PL000G 2026-03-12T12:03:05.341Z 2026-03-19T12:44:30.781Z
9456547 9456547 20260310235238_Q0LZH PL000G 2026-03-12T12:01:03.103Z 2026-03-19T12:44:18.207Z
9456048 9456048 20260309213301_33O4y PL000G 2026-03-11T12:15:33.536Z 2026-03-17T12:42:49.300Z
9455791 9455791 20260309201819_25tRp PL000G 2026-03-11T12:15:03.118Z 2026-03-17T12:42:39.266Z
9455631 9455631 20260309192952_dTvAZ PL000G 2026-03-11T12:14:41.927Z 2026-03-17T12:42:36.997Z
9451307 9451307 20260310014202_07CZJ PL000G 2026-03-11T12:02:24.826Z 2026-03-18T12:38:44.670Z
9450791 9450791 20260309231828_TfeYK PL000G 2026-03-11T12:00:41.490Z 2026-03-18T12:38:35.807Z
9450189 9450189 20260308181804_xGNwW PL000G 2026-03-10T12:18:44.135Z 2026-03-16T12:44:36.290Z
9446998 9446998 20260309035931_Er2ga PL000G 2026-03-10T12:04:46.737Z 2026-03-17T12:41:46.120Z
9446689 9446689 20260309023910_XWYKZ PL000G 2026-03-10T12:03:29.012Z 2026-03-17T12:41:41.348Z
9446531 9446531 20260309020119_2YZKH PL000G 2026-03-10T12:02:48.700Z 2026-03-17T12:41:39.366Z
9446465 9446465 20260309014406_bPp3m PL000G 2026-03-10T12:02:33.965Z 2026-03-17T12:41:38.589Z
9446077 9446077 20260308234314_Kr2fl PL000G 2026-03-10T12:00:54.518Z 2026-03-17T12:41:20.266Z
9445735 9445735 20260307212516_qbxbc PL000G 2026-03-09T12:20:33.267Z 2026-03-15T12:42:13.753Z
9441825 9441825 20260307235409_CoGV2 PL000G 2026-03-09T12:01:25.078Z 2026-03-16T12:43:31.882Z
9440922 9440922 20260306182006_1YdTk PL000G 2026-03-08T12:19:47.161Z 2026-03-14T12:40:39.805Z
9440884 9440884 20260306174442_mvrXB PL000G 2026-03-08T12:19:37.976Z 2026-03-14T12:40:38.828Z
9437041 9437041 20260307012703_zLa1E PL000G 2026-03-08T12:02:22.908Z 2026-03-15T12:41:01.171Z
9437013 9437013 20260307011402_2c64s PL000G 2026-03-08T12:02:15.576Z 2026-03-15T12:41:00.866Z
9436781 9436781 20260306234849_lnE4I PL000G 2026-03-08T12:01:13.574Z 2026-03-15T12:40:57.647Z
9432216 9432216 20260306035859_HKCmP PL000G 2026-03-07T14:03:53.899Z 2026-03-14T12:39:26.903Z
9431722 9431722 20260306013323_zKIwZ PL000G 2026-03-07T14:01:45.865Z 2026-03-14T12:39:16.662Z
9431588 9431588 20260306003629_1RYK3 PL000G 2026-03-07T14:01:14.713Z 2026-03-14T12:39:14.897Z
9426563 9426563 20260305035312_oQ4U1 PL000G 2026-03-06T14:05:25.456Z 2026-03-13T12:34:47.971Z
9426031 9426031 20260305014617_cXbZo PL000G 2026-03-06T14:02:55.041Z 2026-03-13T12:34:41.436Z
9422766 9422766 20260304040336_2v5nS PL000G 2026-03-05T14:02:35.427Z 2026-03-12T12:32:35.102Z
9422717 9422717 20260304034101_QXynW PL000G 2026-03-05T14:02:22.406Z 2026-03-12T12:32:34.334Z
9422623 9422623 20260304031108_R3kAs PL000G 2026-03-05T14:02:01.213Z 2026-03-12T12:32:32.808Z
9422490 9422490 20260304020815_JeyJw PL000G 2026-03-05T14:01:30.908Z 2026-03-12T12:32:29.572Z
9420656 9420656 20260302224450_39g4U PL000G 2026-03-04T14:05:14.884Z 2026-03-10T12:36:57.209Z
9419386 9419386 20260303031939_7RNyS PL000G 2026-03-04T14:01:19.314Z 2026-03-11T12:27:59.521Z
9419156 9419156 20260303014844_YwsbU PL000G 2026-03-04T14:00:51.884Z 2026-03-11T12:27:45.909Z
9419139 9419139 20260303014353_vyXb8 PL000G 2026-03-04T14:00:49.740Z 2026-03-11T12:27:45.615Z
9418881 9418881 20260302230432_c42vo PL000G 2026-03-04T14:00:13.041Z 2026-03-11T12:27:40.659Z
9412095 9412095 20260301000858_oOJYz PL000G 2026-03-02T14:00:28.721Z 2026-03-09T12:39:18.867Z
9411931 9411931 20260227224757_sK2Y0 PL000G 2026-03-01T14:09:21.664Z 2026-03-07T14:51:24.037Z
9411861 9411861 20260227215020_lWaER PL000G 2026-03-01T14:09:11.665Z 2026-03-07T14:51:19.587Z
9411797 9411797 20260227203752_112Me PL000G 2026-03-01T14:09:01.016Z 2026-03-07T14:51:06.231Z
9409313 9409313 20260228024313_mKOs9 PL000G 2026-03-01T14:01:12.440Z 2026-03-08T12:41:06.136Z
9409261 9409261 20260228022721_vytx4 PL000G 2026-03-01T14:01:02.729Z 2026-03-08T12:41:03.698Z
9408938 9408938 20260227234335_upXhi PL000G 2026-03-01T14:00:15.386Z 2026-03-08T12:40:48.418Z
9407857 9407857 20260226214447_TMxQ4 PL000G 2026-02-28T14:22:39.200Z 2026-03-06T14:45:21.574Z
9407718 9407718 20260226203009_M9sZe PL000G 2026-02-28T14:22:19.495Z 2026-03-06T14:45:16.982Z
9407688 9407688 20260226202000_Qy4cs PL000G 2026-02-28T14:22:11.948Z 2026-03-06T14:45:15.928Z
9402454 9402454 20260227035332_903Q2 PL000G 2026-02-28T14:04:57.008Z 2026-03-07T14:46:48.329Z
9402148 9402148 20260227030142_Fe1bW PL000G 2026-02-28T14:03:44.828Z 2026-03-07T14:46:27.752Z
9402068 9402068 20260227023900_DPkLj PL000G 2026-02-28T14:03:25.896Z 2026-03-07T14:46:22.198Z
9400965 9400965 20260225213419_AkD8x PL000G 2026-02-27T14:16:06.118Z 2026-03-05T14:38:55.792Z
9398246 9398246 20260226032238_GNpDN PL000G 2026-02-27T14:04:49.151Z 2026-03-06T14:43:38.989Z
9398202 9398202 20260226031655_3uMrL PL000G 2026-02-27T14:04:42.710Z 2026-03-06T14:43:38.035Z
9398136 9398136 20260226031100_vwfEj PL000G 2026-02-27T14:04:31.754Z 2026-03-06T14:43:36.057Z
9398128 9398128 20260226031034_fXzIg PL000G 2026-02-27T14:04:30.987Z 2026-03-06T14:43:35.903Z
9398121 9398121 20260226030953_o7BFg PL000G 2026-02-27T14:04:29.245Z 2026-03-06T14:43:35.638Z
9397158 9397158 20260226005640_5DnJm PL000G 2026-02-27T14:01:37.514Z 2026-03-06T14:43:02.788Z
9396855 9396855 20260225233143_IQD2E PL000G 2026-02-27T14:00:32.164Z 2026-03-06T14:42:46.658Z

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