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

>10,000 rows count all where station_code = "UK0026" 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
9273256 9273256 20260128051839_G7AsK UK0026 2026-01-29T14:29:13.669Z 2026-01-29T14:30:25.778Z
9272837 9272837 20260128034328_sEWv2 UK0026 2026-01-29T14:28:01.088Z 2026-01-29T14:30:25.580Z
9272796 9272796 20260128033924_0OGcK UK0026 2026-01-29T14:27:51.380Z 2026-01-29T14:30:25.563Z
9272741 9272741 20260128031330_Pdmew UK0026 2026-01-29T14:27:39.946Z 2026-01-29T14:30:25.445Z
9272005 9272005 20260127225628_T9mkn UK0026 2026-01-29T14:25:17.216Z 2026-01-29T14:30:25.263Z
9271936 9271936 20260127221036_t5UlR UK0026 2026-01-29T14:25:00.331Z 2026-01-29T14:30:25.232Z
9271864 9271864 20260127211707_DsgGa UK0026 2026-01-29T14:24:39.859Z 2026-01-29T14:30:25.216Z
9271859 9271859 20260127211520_N7pPx UK0026 2026-01-29T14:24:37.800Z 2026-01-29T14:30:25.215Z
9256083 9256083 20260124055058_djUpU UK0026 2026-01-25T14:15:44.661Z 2026-01-29T14:48:21.926Z
9256034 9256034 20260124054633_Pijqm UK0026 2026-01-25T14:15:36.894Z 2026-01-29T14:48:19.265Z
9256011 9256011 20260124054236_xhwhE UK0026 2026-01-25T14:15:33.931Z 2026-01-29T14:48:18.402Z
9255941 9255941 20260124052954_3l5d0 UK0026 2026-01-25T14:15:13.519Z 2026-01-29T14:48:09.143Z
9255881 9255881 20260124051127_DTfze UK0026 2026-01-25T14:15:02.505Z 2026-01-29T14:48:03.118Z
9255707 9255707 20260124043644_gpi6d UK0026 2026-01-25T14:14:27.234Z 2026-01-29T14:47:53.211Z
9255663 9255663 20260124042822_ObJ4f UK0026 2026-01-25T14:14:13.975Z 2026-01-29T14:47:50.040Z
9255648 9255648 20260124042413_OiFge UK0026 2026-01-25T14:14:10.761Z 2026-01-29T14:47:49.356Z
9255544 9255544 20260124040749_jZ3qz UK0026 2026-01-25T14:13:54.864Z 2026-01-29T14:47:39.278Z
9255318 9255318 20260124024830_x8J09 UK0026 2026-01-25T14:12:53.946Z 2026-01-29T14:47:23.347Z
9255316 9255316 20260124024518_oTOn2 UK0026 2026-01-25T14:12:53.202Z 2026-01-29T14:47:23.268Z
9255293 9255293 20260124024033_33DFI UK0026 2026-01-25T14:12:44.998Z 2026-01-29T14:47:21.921Z
9255277 9255277 20260124022708_PQLX2 UK0026 2026-01-25T14:12:39.070Z 2026-01-29T14:47:14.809Z
9255272 9255272 20260124022324_hUjBi UK0026 2026-01-25T14:12:38.461Z 2026-01-29T14:47:14.372Z
9255241 9255241 20260124021010_Q7mFs UK0026 2026-01-25T14:12:30.567Z 2026-01-29T14:47:11.985Z
9255174 9255174 20260124012814_aW03q UK0026 2026-01-25T14:12:10.003Z 2026-01-29T14:47:06.369Z
9255136 9255136 20260124011314_dc2kq UK0026 2026-01-25T14:12:01.254Z 2026-01-29T14:47:04.291Z
9255105 9255105 20260124005609_gLiOY UK0026 2026-01-25T14:11:55.057Z 2026-01-29T14:47:02.769Z
9255087 9255087 20260124004508_3FzxE UK0026 2026-01-25T14:11:51.312Z 2026-01-29T14:47:01.762Z
9255068 9255068 20260124003933_mULw4 UK0026 2026-01-25T14:11:46.472Z 2026-01-29T14:47:01.169Z
9255055 9255055 20260124003730_fvqu6 UK0026 2026-01-25T14:11:45.525Z 2026-01-29T14:47:01.022Z
9255031 9255031 20260124002827_TWGF5 UK0026 2026-01-25T14:11:42.590Z 2026-01-29T14:47:00.288Z
9255012 9255012 20260124002237_YcetE UK0026 2026-01-25T14:11:38.946Z 2026-01-29T14:46:59.818Z
9254979 9254979 20260123235544_sAF2R UK0026 2026-01-25T14:11:31.529Z 2026-01-29T14:46:58.268Z
9254613 9254613 20260123202532_zL138 UK0026 2026-01-25T14:10:03.820Z 2026-01-29T14:46:32.521Z
9252753 9252753 20260123060741_w9aKm UK0026 2026-01-24T14:17:01.363Z 2026-01-29T14:53:22.897Z
9252727 9252727 20260123055035_KKEPh UK0026 2026-01-24T14:16:56.419Z 2026-01-29T14:53:21.307Z
9252617 9252617 20260123044716_bz6Rv UK0026 2026-01-24T14:16:28.500Z 2026-01-29T14:53:11.957Z
9252613 9252613 20260123044605_1RGew UK0026 2026-01-24T14:16:28.101Z 2026-01-29T14:53:11.799Z
9252586 9252586 20260123043026_m732v UK0026 2026-01-24T14:16:18.765Z 2026-01-29T14:53:10.070Z
9252516 9252516 20260123034611_nC92u UK0026 2026-01-24T14:15:59.749Z 2026-01-29T14:53:05.334Z
9252329 9252329 20260123021751_hLh5L UK0026 2026-01-24T14:15:09.049Z 2026-01-29T14:52:45.340Z
9244127 9244127 20260121061824_8tA4U UK0026 2026-01-22T14:24:14.236Z 2026-01-29T15:05:52.604Z
9244103 9244103 20260121061337_sFBil UK0026 2026-01-22T14:24:10.341Z 2026-01-29T15:05:52.057Z
9244079 9244079 20260121061011_q7kOI UK0026 2026-01-22T14:24:05.827Z 2026-01-29T15:05:50.792Z
9244010 9244010 20260121055543_f1G0L UK0026 2026-01-22T14:23:56.017Z 2026-01-29T15:05:47.458Z
9243994 9243994 20260121055013_aeUOf UK0026 2026-01-22T14:23:53.240Z 2026-01-29T15:05:37.914Z
9243598 9243598 20260121045103_RcwD1 UK0026 2026-01-22T14:22:18.601Z 2026-01-29T15:05:19.482Z
9243564 9243564 20260121044838_Iaeak UK0026 2026-01-22T14:22:13.739Z 2026-01-29T15:05:18.267Z
9243520 9243520 20260121044351_8gEpq UK0026 2026-01-22T14:22:08.633Z 2026-01-29T15:05:16.893Z
9243357 9243357 20260121042101_asesF UK0026 2026-01-22T14:21:31.530Z 2026-01-29T15:04:56.885Z
9243221 9243221 20260121040045_M9eBq UK0026 2026-01-22T14:20:59.406Z 2026-01-29T15:04:51.443Z
9195843 9195843 20260113030541_ePv2s UK0026 2026-01-14T14:15:12.048Z 2026-01-21T15:04:48.580Z
9195743 9195743 20260113023913_WuavR UK0026 2026-01-14T14:14:43.674Z 2026-01-21T15:04:46.830Z
9195694 9195694 20260113022049_pYFYb UK0026 2026-01-14T14:14:24.719Z 2026-01-21T15:04:45.718Z
9195667 9195667 20260113021318_L6K7Y UK0026 2026-01-14T14:14:19.562Z 2026-01-21T15:04:45.387Z
9195557 9195557 20260113014628_3XSiZ UK0026 2026-01-14T14:13:48.551Z 2026-01-21T15:04:42.285Z
9195401 9195401 20260113011927_B87Dd UK0026 2026-01-14T14:13:11.187Z 2026-01-21T15:04:40.042Z
9195240 9195240 20260113004621_PB12j UK0026 2026-01-14T14:12:34.673Z 2026-01-21T15:04:37.942Z
9195214 9195214 20260113004200_mGD8Q UK0026 2026-01-14T14:12:24.664Z 2026-01-21T15:04:37.606Z
9195140 9195140 20260113002801_CxQXe UK0026 2026-01-14T14:12:10.023Z 2026-01-21T15:04:36.903Z
9195035 9195035 20260113000554_MzUOD UK0026 2026-01-14T14:11:47.227Z 2026-01-21T15:04:35.428Z
9194976 9194976 20260112235318_bd8ov UK0026 2026-01-14T14:11:34.004Z 2026-01-21T15:04:34.572Z
9194969 9194969 20260112234915_uUFUD UK0026 2026-01-14T14:11:32.885Z 2026-01-21T15:04:34.509Z
9194764 9194764 20260112223452_fQL6f UK0026 2026-01-14T14:10:37.859Z 2026-01-21T15:04:20.792Z
9194635 9194635 20260112213729_XNEM3 UK0026 2026-01-14T14:10:05.935Z 2026-01-21T15:04:19.516Z
9194632 9194632 20260112213729_pG323 UK0026 2026-01-14T14:10:05.275Z 2026-01-21T15:04:19.444Z
9194580 9194580 20260112212740_zxXwZ UK0026 2026-01-14T14:09:53.579Z 2026-01-21T15:04:19.010Z
9176715 9176715 20260110061238_azZi8 UK0026 2026-01-11T14:09:48.709Z 2026-01-18T15:08:51.788Z
9176622 9176622 20260110055834_JlxuA UK0026 2026-01-11T14:09:30.622Z 2026-01-18T15:08:46.411Z
9176590 9176590 20260110054953_PcJAT UK0026 2026-01-11T14:09:24.084Z 2026-01-18T15:08:45.020Z
9176218 9176218 20260110050238_kdc3f UK0026 2026-01-11T14:08:29.780Z 2026-01-18T15:08:24.277Z
9175887 9175887 20260110040632_83xR9 UK0026 2026-01-11T14:07:40.403Z 2026-01-18T15:08:12.115Z
9175534 9175534 20260110025210_as3mx UK0026 2026-01-11T14:06:39.535Z 2026-01-18T15:07:49.244Z
9175525 9175525 20260110024710_8Pp8C UK0026 2026-01-11T14:06:38.022Z 2026-01-18T15:07:48.742Z
9167296 9167296 20260108001246_2y1qU UK0026 2026-01-09T14:07:05.472Z 2026-01-16T15:11:01.104Z
9167273 9167273 20260108000507_JA4Bc UK0026 2026-01-09T14:06:58.929Z 2026-01-16T15:10:59.807Z
9167240 9167240 20260107235011_uVwFw UK0026 2026-01-09T14:06:51.017Z 2026-01-16T15:10:57.812Z
9167123 9167123 20260107225008_xiHqZ UK0026 2026-01-09T14:06:21.646Z 2026-01-16T15:10:51.206Z
9166850 9166850 20260107204509_2A6Ij UK0026 2026-01-09T14:05:11.842Z 2026-01-16T15:10:26.774Z
9166602 9166602 20260107192543_qZhX7 UK0026 2026-01-09T14:04:00.899Z 2026-01-16T15:10:05.775Z
9166473 9166473 20260107184300_YMVPR UK0026 2026-01-09T14:03:24.179Z 2026-01-16T15:09:56.945Z
9166251 9166251 20260107173203_PZkHw UK0026 2026-01-09T14:02:21.092Z 2026-01-16T15:09:34.552Z
9163417 9163417 20260107063424_0EvIS UK0026 2026-01-08T14:09:06.001Z 2026-01-08T14:16:36.137Z
9163321 9163321 20260107062215_N6Ab7 UK0026 2026-01-08T14:08:44.846Z 2026-01-13T15:03:09.295Z
9162834 9162834 20260107044222_vGQuP UK0026 2026-01-08T14:07:02.106Z 2026-01-13T15:02:41.525Z
9162372 9162372 20260107023429_RCB92 UK0026 2026-01-08T14:04:53.080Z 2026-01-13T15:02:05.337Z
9160683 9160683 20260106065459_ax4t5 UK0026 2026-01-07T14:13:24.907Z 2026-01-13T15:09:46.472Z
9160650 9160650 20260106064413_24Xss UK0026 2026-01-07T14:13:19.486Z 2026-01-13T15:09:44.507Z
9160628 9160628 20260106063541_wbkui UK0026 2026-01-07T14:13:14.921Z 2026-01-13T15:09:43.168Z
9160573 9160573 20260106062438_yiiAW UK0026 2026-01-07T14:13:02.412Z 2026-01-13T15:09:33.347Z
9160561 9160561 20260106062438_H2ZoQ UK0026 2026-01-07T14:13:01.851Z 2026-01-13T15:09:33.033Z
9160466 9160466 20260106060055_IXgVJ UK0026 2026-01-07T14:12:44.416Z 2026-01-13T15:09:27.646Z
9160396 9160396 20260106054620_FTwiC UK0026 2026-01-07T14:12:29.945Z 2026-01-13T15:09:24.748Z
9160228 9160228 20260106051119_AMYgi UK0026 2026-01-07T14:11:55.328Z 2026-01-13T15:09:15.728Z
9160214 9160214 20260106050917_WhPX5 UK0026 2026-01-07T14:11:52.556Z 2026-01-13T15:09:14.847Z
9160195 9160195 20260106050124_STPDX UK0026 2026-01-07T14:11:45.330Z 2026-01-13T15:09:07.106Z
9160147 9160147 20260106045329_N3nLF UK0026 2026-01-07T14:11:33.146Z 2026-01-13T15:09:04.936Z
9160128 9160128 20260106045302_KjP4k UK0026 2026-01-07T14:11:30.801Z 2026-01-13T15:09:03.904Z
9159737 9159737 20260106033546_wTCA5 UK0026 2026-01-07T14:10:18.214Z 2026-01-13T15:08:39.487Z
9159556 9159556 20260106030750_8RdBZ UK0026 2026-01-07T14:09:44.375Z 2026-01-13T15:08:30.811Z
9159460 9159460 20260106024440_16BaM UK0026 2026-01-07T14:09:22.166Z 2026-01-13T15:08:26.661Z

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