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

1,619 rows where station_code = "UA0001" 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
9223811 9223811 20260118022536_j6REl UA0001 2026-01-19T14:21:15.030Z 2026-01-26T15:02:36.914Z
9223681 9223681 20260118020036_OuS2J UA0001 2026-01-19T14:20:36.989Z 2026-01-26T15:02:31.957Z
9223610 9223610 20260118014223_W4MmP UA0001 2026-01-19T14:20:10.601Z 2026-01-26T15:02:29.299Z
9223316 9223316 20260118001226_8nzl5 UA0001 2026-01-19T14:18:39.231Z 2026-01-26T15:02:01.951Z
9223158 9223158 20260117233012_fWlDA UA0001 2026-01-19T14:17:57.842Z 2026-01-26T15:01:56.086Z
9222963 9222963 20260117214613_nb1Xy UA0001 2026-01-19T14:17:00.701Z 2026-01-26T15:01:30.177Z
9222900 9222900 20260117212038_cJmK2 UA0001 2026-01-19T14:16:44.968Z 2026-01-26T15:01:25.297Z
9222803 9222803 20260117205356_abxvo UA0001 2026-01-19T14:16:18.610Z 2026-01-26T15:01:21.620Z
9222419 9222419 20260117193009_2Hgti UA0001 2026-01-19T14:14:41.570Z 2026-01-26T15:00:52.993Z
9218035 9218035 20260116223526_MK3wt UA0001 2026-01-18T14:10:05.045Z 2026-01-25T14:57:56.111Z
9218016 9218016 20260116215551_s7wXX UA0001 2026-01-18T14:09:59.994Z 2026-01-25T14:57:55.272Z
9217857 9217857 20260116200958_3lypA UA0001 2026-01-18T14:09:18.836Z 2026-01-25T14:57:49.886Z
9206827 9206827 20260114190936_Luc7t UA0001 2026-01-16T14:05:44.846Z 2026-01-22T15:02:37.728Z
9206776 9206776 20260114184815_GhuUn UA0001 2026-01-16T14:05:31.537Z 2026-01-22T15:02:36.227Z
9202465 9202465 20260114034139_3EiyR UA0001 2026-01-15T14:21:22.499Z 2026-01-22T15:09:20.736Z
9202312 9202312 20260114032832_ne7yP UA0001 2026-01-15T14:21:03.089Z 2026-01-22T15:09:16.209Z
9201805 9201805 20260114025617_81dhr UA0001 2026-01-15T14:19:46.238Z 2026-01-22T15:09:09.929Z
9201704 9201704 20260114024205_dlF0e UA0001 2026-01-15T14:19:20.158Z 2026-01-22T15:09:07.725Z
9200428 9200428 20260114000646_4iaFF UA0001 2026-01-15T14:15:11.148Z 2026-01-22T15:08:15.805Z
9200229 9200229 20260113232104_ui3MF UA0001 2026-01-15T14:14:17.116Z 2026-01-22T15:08:11.863Z
9200129 9200129 20260113225416_I7wvO UA0001 2026-01-15T14:13:52.558Z 2026-01-22T15:08:10.024Z
9199936 9199936 20260113215853_HOf93 UA0001 2026-01-15T14:13:07.496Z 2026-01-22T15:08:05.872Z
9199492 9199492 20260113200816_klEOb UA0001 2026-01-15T14:11:09.780Z 2026-01-22T15:07:25.298Z
9198422 9198422 20260113161802_e2f0L UA0001 2026-01-15T14:04:16.108Z 2026-01-22T15:06:27.060Z
9189257 9189257 20260112034305_Wwyps UA0001 2026-01-13T14:16:38.398Z 2026-01-20T15:23:00.265Z
9189236 9189236 20260112033916_GH3s5 UA0001 2026-01-13T14:16:32.849Z 2026-01-20T15:22:58.865Z
9189203 9189203 20260112032725_LOc2f UA0001 2026-01-13T14:16:18.608Z 2026-01-20T15:22:47.372Z
9189189 9189189 20260112032412_ixtkF UA0001 2026-01-13T14:16:14.257Z 2026-01-20T15:22:46.539Z
9189133 9189133 20260112030802_j5wIi UA0001 2026-01-13T14:15:58.283Z 2026-01-20T15:22:43.467Z
9189129 9189129 20260112030720_lr3GN UA0001 2026-01-13T14:15:56.895Z 2026-01-20T15:22:43.056Z
9189059 9189059 20260112024750_mkrE1 UA0001 2026-01-13T14:15:33.189Z 2026-01-20T15:22:36.877Z
9188099 9188099 20260111202817_UEjdz UA0001 2026-01-13T14:10:28.626Z 2026-01-20T15:21:12.814Z
9187265 9187265 20260111155441_d9FMW UA0001 2026-01-13T14:06:28.002Z 2026-01-20T15:20:12.524Z
9175008 9175008 20260110004349_BMsmW UA0001 2026-01-11T14:05:07.463Z 2026-01-18T15:07:21.683Z
9174993 9174993 20260110003907_ZnNI5 UA0001 2026-01-11T14:05:04.275Z 2026-01-18T15:07:20.972Z
9174843 9174843 20260109233041_UGR5A UA0001 2026-01-11T14:04:36.047Z 2026-01-18T15:07:13.564Z
9174806 9174806 20260109230755_YXOux UA0001 2026-01-11T14:04:27.676Z 2026-01-18T15:07:11.693Z
9174627 9174627 20260109210544_MCjG8 UA0001 2026-01-11T14:03:53.677Z 2026-01-18T15:06:55.952Z
9174591 9174591 20260109204109_ZA508 UA0001 2026-01-11T14:03:44.952Z 2026-01-18T15:06:54.022Z
9174424 9174424 20260109184050_ssMMH UA0001 2026-01-11T14:03:08.469Z 2026-01-18T15:06:45.287Z
9141375 9141375 20260104005218_MUHc2 UA0001 2026-01-05T14:14:29.228Z 2026-01-12T15:04:59.919Z
9141235 9141235 20260104004635_13tix UA0001 2026-01-05T14:14:19.513Z 2026-01-12T15:04:44.026Z
9141149 9141149 20260104004424_1Sm1g UA0001 2026-01-05T14:14:15.221Z 2026-01-12T15:04:41.884Z
9141113 9141113 20260104004302_BYyDB UA0001 2026-01-05T14:14:12.453Z 2026-01-12T15:04:40.737Z
9140940 9140940 20260104003645_fgwEd UA0001 2026-01-05T14:13:49.183Z 2026-01-12T15:04:34.790Z
9140838 9140838 20260104003207_e8cYJ UA0001 2026-01-05T14:13:41.952Z 2026-01-12T15:04:32.457Z
9140832 9140832 20260104003206_ZJVnh UA0001 2026-01-05T14:13:41.570Z 2026-01-12T15:04:32.252Z
9140773 9140773 20260104003011_m5xwt UA0001 2026-01-05T14:13:36.034Z 2026-01-12T15:04:30.135Z
9140580 9140580 20260104002234_T8ou1 UA0001 2026-01-05T14:13:25.116Z 2026-01-12T15:04:25.246Z
9140553 9140553 20260104002149_de2Fs UA0001 2026-01-05T14:13:17.345Z 2026-01-12T15:04:24.397Z
9140273 9140273 20260104000817_OlBbL UA0001 2026-01-05T14:12:58.271Z 2026-01-12T15:04:04.077Z
9139474 9139474 20260103233302_oWm4X UA0001 2026-01-05T14:11:42.378Z 2026-01-12T15:03:31.631Z
9137283 9137283 20260103205929_Jc4fd UA0001 2026-01-05T14:08:16.595Z 2026-01-12T15:01:55.582Z
9137191 9137191 20260103205002_JGp3U UA0001 2026-01-05T14:08:00.496Z 2026-01-12T15:01:52.735Z
9136903 9136903 20260103202449_nFQDW UA0001 2026-01-05T14:07:27.632Z 2026-01-12T15:01:42.868Z
9136063 9136063 20260103193124_gq9s1 UA0001 2026-01-05T14:06:02.693Z 2026-01-12T15:01:05.594Z
9135924 9135924 20260103192405_pdAP5 UA0001 2026-01-05T14:05:38.185Z 2026-01-12T15:00:51.600Z
9135908 9135908 20260103192327_Lgphb UA0001 2026-01-05T14:05:36.880Z 2026-01-12T15:00:50.991Z
9135435 9135435 20260103185455_c2Jrq UA0001 2026-01-05T14:04:29.129Z 2026-01-12T15:00:30.572Z
9135300 9135300 20260103185108_uJqC0 UA0001 2026-01-05T14:04:13.108Z 2026-01-12T15:00:23.011Z
9135296 9135296 20260103185027_z8MVu UA0001 2026-01-05T14:04:11.353Z 2026-01-12T15:00:22.168Z
9135073 9135073 20260103183756_i8wZD UA0001 2026-01-05T14:03:36.628Z 2026-01-12T15:00:01.972Z
9126585 9126585 20260101230313_RgHzU UA0001 2026-01-03T14:05:28.771Z 2026-01-09T14:48:52.322Z
9126564 9126564 20260101225024_ckS8c UA0001 2026-01-03T14:05:19.279Z 2026-01-09T14:48:51.124Z
9126461 9126461 20260101210715_agzd9 UA0001 2026-01-03T14:04:25.787Z 2026-01-09T14:48:39.830Z
9126335 9126335 20260101193656_89AlD UA0001 2026-01-03T14:02:59.801Z 2026-01-09T14:48:19.543Z
9122112 9122112 20260101043000_wXp2E UA0001 2026-01-02T14:11:17.331Z 2026-01-09T14:53:01.740Z
9122048 9122048 20260101041438_9SKP9 UA0001 2026-01-02T14:10:54.024Z 2026-01-09T14:52:58.108Z
9121813 9121813 20260101025921_oPvUx UA0001 2026-01-02T14:09:33.162Z 2026-01-09T14:52:40.036Z
9121753 9121753 20260101022339_3CZm8 UA0001 2026-01-02T14:09:13.276Z 2026-01-09T14:52:36.072Z
9121540 9121540 20251231233906_GwlXR UA0001 2026-01-02T14:07:54.400Z 2026-01-09T14:52:18.134Z
9121470 9121470 20251231225612_7SByB UA0001 2026-01-02T14:07:34.402Z 2026-01-09T14:52:09.421Z
9119166 9119166 20251230164715_SVgtd UA0001 2026-01-01T14:55:02.843Z 2026-01-07T15:12:10.236Z
9119157 9119157 20251230164226_k8ESW UA0001 2026-01-01T14:55:00.564Z 2026-01-07T15:12:09.085Z
9113649 9113649 20251231034116_P3Qdg UA0001 2026-01-01T14:19:53.836Z 2026-01-08T15:08:55.682Z
9112241 9112241 20251231021448_XxciR UA0001 2026-01-01T14:14:30.315Z 2026-01-01T14:57:51.858Z
9112239 9112239 20251231021432_LJz6D UA0001 2026-01-01T14:14:29.724Z 2026-01-08T15:07:35.200Z
9112164 9112164 20251231020946_pnF6X UA0001 2026-01-01T14:14:14.538Z 2026-01-01T14:57:51.777Z
9111946 9111946 20251231015250_E3Md2 UA0001 2026-01-01T14:13:23.420Z 2026-01-01T14:57:51.520Z
9111495 9111495 20251231011337_ubvJC UA0001 2026-01-01T14:11:44.140Z 2026-01-08T15:06:42.525Z
9111159 9111159 20251231004332_4ekdD UA0001 2026-01-01T14:10:19.761Z 2026-01-08T15:06:18.566Z
9111018 9111018 20251231002910_93exJ UA0001 2026-01-01T14:09:47.921Z 2026-01-08T15:06:11.660Z
9110987 9110987 20251231002608_eX9Yr UA0001 2026-01-01T14:09:42.393Z 2026-01-01T14:57:50.425Z
9110402 9110402 20251230230054_vRRd5 UA0001 2026-01-01T14:07:04.383Z 2026-01-08T15:05:21.714Z
9110356 9110356 20251230225559_0GLrj UA0001 2026-01-01T14:06:57.523Z 2026-01-08T15:05:19.967Z
9109930 9109930 20251230213420_vgcY3 UA0001 2026-01-01T14:04:49.897Z 2026-01-08T15:04:48.626Z
9109733 9109733 20251230203709_C3122 UA0001 2026-01-01T14:03:18.730Z 2026-01-08T15:04:25.269Z
9109725 9109725 20251230203232_mNWw1 UA0001 2026-01-01T14:03:13.031Z 2026-01-08T15:04:24.922Z
9108071 9108071 20251229175448_AOcLP UA0001 2025-12-31T14:42:49.183Z 2026-01-06T15:21:23.942Z
9107483 9107483 20251229160459_jHG0w UA0001 2025-12-31T14:41:06.242Z 2026-01-06T15:20:48.404Z
9107479 9107479 20251229160448_p385j UA0001 2025-12-31T14:41:05.495Z 2026-01-06T15:20:48.288Z
9101154 9101154 20251229225648_3FkRG UA0001 2025-12-31T14:06:51.425Z 2026-01-07T15:06:04.239Z
9101034 9101034 20251229221342_SProb UA0001 2025-12-31T14:06:09.582Z 2026-01-07T15:05:48.493Z
9100936 9100936 20251229213931_D82se UA0001 2025-12-31T14:05:29.025Z 2026-01-07T15:05:44.685Z
9073865 9073865 20251225183720_uoCrr UA0001 2025-12-29T14:59:56.036Z 2026-01-02T15:47:59.412Z
9073560 9073560 20251225180241_LUtYc UA0001 2025-12-29T14:59:45.113Z 2026-01-02T15:47:53.735Z
9073356 9073356 20251225173330_a8qJ1 UA0001 2025-12-29T14:59:13.931Z 2026-01-02T15:47:49.895Z
9073046 9073046 20251225153724_UvNnB UA0001 2025-12-29T14:58:56.970Z 2026-01-02T15:47:35.697Z
9073044 9073044 20251225153153_LB3XB UA0001 2025-12-29T14:58:56.109Z 2026-01-02T15:47:23.367Z
9063517 9063517 20251226031813_9k8Zd UA0001 2025-12-29T14:35:27.971Z 2026-01-03T15:35:21.866Z

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