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

272 rows where station_code = "UA0006" 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
9243178 9243178 20260121035342_xR4V4 UA0006 2026-01-22T14:20:50.823Z 2026-01-29T15:04:49.645Z
9243141 9243141 20260121034740_3aDt6 UA0006 2026-01-22T14:20:45.383Z 2026-01-29T15:04:47.938Z
9242473 9242473 20260121015802_fu9rh UA0006 2026-01-22T14:17:58.451Z 2026-01-29T15:04:00.247Z
9236217 9236217 20260120024803_UfZ4o UA0006 2026-01-21T14:21:59.384Z 2026-01-28T14:59:50.498Z
9235219 9235219 20260120004355_zJNJ3 UA0006 2026-01-21T14:17:56.726Z 2026-01-28T14:58:44.100Z
9229190 9229190 20260119010442_sCneq UA0006 2026-01-20T14:21:23.129Z 2026-01-27T15:03:10.693Z
9224118 9224118 20260118032720_Porqh UA0006 2026-01-19T14:22:58.272Z 2026-01-26T15:03:05.175Z
9224065 9224065 20260118031848_6CIlz UA0006 2026-01-19T14:22:35.999Z 2026-01-26T15:02:49.628Z
9223448 9223448 20260118004638_xsPDU UA0006 2026-01-19T14:19:22.632Z 2026-01-26T15:02:07.205Z
9221807 9221807 20260117163501_AcRqV UA0006 2026-01-19T14:11:59.191Z 2026-01-26T15:00:10.979Z
9213084 9213084 20260116020815_bVvHO UA0006 2026-01-17T14:15:18.784Z 2026-01-24T15:11:39.979Z
9212734 9212734 20260116003539_nToOW UA0006 2026-01-17T14:13:32.144Z 2026-01-24T15:11:24.145Z
9150081 9150081 20260105005822_R4W4i UA0006 2026-01-06T14:08:29.036Z 2026-01-13T15:13:03.256Z
9147796 9147796 20260103152259_VUgdS UA0006 2026-01-05T14:29:39.257Z 2026-01-10T15:03:43.355Z
9146547 9146547 20260104035854_86vNd UA0006 2026-01-05T14:22:22.564Z 2026-01-12T15:08:53.906Z
9144691 9144691 20260104025203_fUC2B UA0006 2026-01-05T14:19:30.146Z 2026-01-12T15:07:13.271Z
9029835 9029835 20251225041805_oj34k UA0006 2025-12-28T14:17:23.589Z 2026-01-02T15:44:38.786Z
9027398 9027398 20251225021621_xg2FX UA0006 2025-12-28T14:11:00.070Z 2026-01-02T15:43:32.563Z
9027159 9027159 20251225020254_FqlL7 UA0006 2025-12-28T14:10:18.462Z 2026-01-02T15:43:25.258Z
9026181 9026181 20251225005049_C9hlP UA0006 2025-12-28T14:07:02.562Z 2026-01-02T15:42:50.807Z
9026030 9026030 20251225004114_hSW33 UA0006 2025-12-28T14:06:28.684Z 2026-01-02T15:42:47.659Z
8990859 8990859 20251218151231_AklHL UA0006 2025-12-26T14:47:20.591Z 2025-12-26T14:47:20.591Z
8789648 8789648 20251213031202_bF0Gw UA0006 2025-12-15T14:39:47.766Z 2025-12-21T14:17:38.283Z
8788707 8788707 20251213030102_9sq4C UA0006 2025-12-15T14:39:24.019Z 2025-12-21T14:17:37.873Z
8597792 8597792 20251125001256_2Kx2x UA0006 2025-11-26T14:17:43.280Z 2025-12-02T15:07:40.729Z
8522360 8522360 20251119000057_WxfCO UA0006 2025-11-20T14:15:16.131Z 2025-11-27T15:12:01.045Z
8520841 8520841 20251118200820_hEpBY UA0006 2025-11-20T14:11:05.651Z 2025-11-27T15:11:35.768Z
8520827 8520827 20251118200633_llhPv UA0006 2025-11-20T14:10:58.703Z 2025-11-27T15:11:35.720Z
8519691 8519691 20251118175151_Wc0gt UA0006 2025-11-20T14:07:31.652Z 2025-11-27T15:11:28.415Z
8481065 8481065 20251116013157_QoveB UA0006 2025-11-17T14:19:55.022Z 2025-11-24T15:04:58.606Z
8480828 8480828 20251116001507_aGgLn UA0006 2025-11-17T14:19:14.382Z 2025-11-24T15:04:56.408Z
8480733 8480733 20251115232246_Y04Ho UA0006 2025-11-17T14:19:03.534Z 2025-11-24T15:04:55.620Z
8480343 8480343 20251115210319_Fusql UA0006 2025-11-17T14:17:53.194Z 2025-11-24T15:04:52.032Z
8456438 8456438 20251113184345_n7oVl UA0006 2025-11-15T14:11:18.115Z 2025-11-22T15:20:44.197Z
8364520 8364520 20251102234115_xLqrY UA0006 2025-11-04T14:17:30.820Z 2025-11-11T15:06:16.429Z
8364376 8364376 20251102231433_hTcST UA0006 2025-11-04T14:16:58.365Z 2025-11-11T15:06:14.057Z
8364329 8364329 20251102230638_fEPHm UA0006 2025-11-04T14:16:51.863Z 2025-11-11T15:06:13.163Z
8353387 8353387 20251102023532_l4dI6 UA0006 2025-11-03T14:18:11.570Z 2025-11-10T15:07:54.144Z
8353180 8353180 20251102020752_6R8Pe UA0006 2025-11-03T14:17:52.331Z 2025-11-10T15:07:25.414Z
8351713 8351713 20251101233441_tdkiu UA0006 2025-11-03T14:14:20.010Z 2025-11-10T15:05:54.155Z
8350613 8350613 20251101210354_nQPyO UA0006 2025-11-03T14:11:36.262Z 2025-11-10T15:05:41.935Z
8334570 8334570 20251031020454_dVf2h UA0006 2025-11-02T14:25:24.590Z 2025-11-08T15:13:42.979Z
8334109 8334109 20251031012309_gPz5u UA0006 2025-11-02T14:24:24.345Z 2025-11-08T15:13:09.195Z
8319309 8319309 20251030020144_2CNmJ UA0006 2025-11-01T12:24:20.884Z 2025-11-07T15:13:40.261Z
8319157 8319157 20251030015232_2AU7x UA0006 2025-11-01T12:24:09.754Z 2025-11-07T15:13:35.979Z
8318778 8318778 20251030013950_QP1Vz UA0006 2025-11-01T12:23:21.150Z 2025-11-07T15:13:31.645Z
8318647 8318647 20251030013222_SSSto UA0006 2025-11-01T12:23:10.738Z 2025-11-07T15:13:30.396Z
8314428 8314428 20251030005453_XcMuc UA0006 2025-10-31T12:39:05.619Z 2025-11-07T15:13:21.275Z
8314155 8314155 20251030004002_ox8YK UA0006 2025-10-31T12:38:19.391Z 2025-11-07T15:13:17.854Z
8313226 8313226 20251029235702_dE368 UA0006 2025-10-31T12:37:49.581Z 2025-11-07T15:12:30.287Z
8279165 8279165 20251027201216_yYSoG UA0006 2025-10-29T12:36:08.288Z 2025-11-05T15:20:23.808Z
8279137 8279137 20251027200309_42N3G UA0006 2025-10-29T12:36:01.952Z 2025-11-05T15:20:21.733Z
8279102 8279102 20251027194606_Ktbz7 UA0006 2025-10-29T12:35:47.688Z 2025-11-05T15:20:18.235Z
8279088 8279088 20251027193834_RrdME UA0006 2025-10-29T12:35:40.127Z 2025-11-05T15:20:14.691Z
8256839 8256839 20251026013915_a3t1N UA0006 2025-10-28T12:30:03.172Z 2025-11-03T15:16:16.961Z
8251681 8251681 20251026222820_MWfOU UA0006 2025-10-28T12:12:28.305Z 2025-11-04T15:41:52.921Z
8251602 8251602 20251026220654_i6lwa UA0006 2025-10-28T12:12:07.729Z 2025-11-04T15:41:48.192Z
8251557 8251557 20251026215042_VdYWc UA0006 2025-10-28T12:12:00.444Z 2025-11-04T15:41:46.622Z
8251168 8251168 20251026202050_2VkxQ UA0006 2025-10-28T12:10:48.557Z 2025-11-04T15:41:34.445Z
8249107 8249107 20251026165345_fw5z1 UA0006 2025-10-28T12:04:31.398Z 2025-11-04T15:39:33.148Z
8249048 8249048 20251026164137_mgH3G UA0006 2025-10-28T12:04:21.200Z 2025-11-04T15:39:31.148Z
8231821 8231821 20251025193209_dBKAh UA0006 2025-10-27T12:08:57.194Z 2025-11-03T15:15:47.975Z
8192230 8192230 20251022023748_H1Pt9 UA0006 2025-10-24T12:25:35.975Z 2025-10-30T13:13:20.086Z
8191786 8191786 20251022020509_6oAy2 UA0006 2025-10-24T12:24:42.397Z 2025-10-30T13:13:15.537Z
8191373 8191373 20251022013213_SGvUA UA0006 2025-10-24T12:23:51.633Z 2025-10-30T13:13:12.502Z
8191129 8191129 20251022011452_v8yP5 UA0006 2025-10-24T12:23:21.693Z 2025-10-30T13:13:10.395Z
8190983 8190983 20251022005856_PG804 UA0006 2025-10-24T12:23:11.083Z 2025-10-30T13:13:09.495Z
8190379 8190379 20251022000521_MrPAP UA0006 2025-10-24T12:21:42.263Z 2025-10-30T13:13:05.363Z
8180335 8180335 20251021230141_19sLU UA0006 2025-10-23T12:18:12.536Z 2025-10-23T12:39:24.952Z
8179663 8179663 20251021214845_JYmBU UA0006 2025-10-23T12:16:51.493Z 2025-10-30T13:12:55.669Z
8092807 8092807 20251013013407_pZQjg UA0006 2025-10-14T12:11:45.255Z 2025-10-21T13:09:27.657Z
8092271 8092271 20251012232202_z8go2 UA0006 2025-10-14T12:10:05.872Z 2025-10-21T13:09:19.498Z
7974854 7974854 20250926014403_k2P37 UA0006 2025-09-27T12:14:13.782Z 2025-10-04T13:07:09.844Z
7970548 7970548 20250925191407_2XQg1 UA0006 2025-09-27T12:09:31.065Z 2025-10-04T13:06:34.340Z
7958091 7958091 20250924215354_EWacY UA0006 2025-09-26T12:20:54.861Z 2025-10-03T13:04:01.174Z
7935794 7935794 20250922015009_HvBSf UA0006 2025-09-24T12:53:53.662Z 2025-09-30T13:03:26.859Z
7928770 7928770 20250921201318_fugmV UA0006 2025-09-24T12:46:33.472Z 2025-09-30T13:02:12.633Z
7922068 7922068 20250923022653_GkTRi UA0006 2025-09-24T12:31:00.287Z 2025-10-01T13:24:51.101Z
7917330 7917330 20250922221658_IvEU6 UA0006 2025-09-24T12:23:41.251Z 2025-10-01T13:23:51.511Z
7916299 7916299 20250922210636_4Q6DT UA0006 2025-09-24T12:22:05.230Z 2025-10-01T13:23:36.262Z
7914463 7914463 20250922180118_8Wtyd UA0006 2025-09-24T12:17:38.723Z 2025-10-01T13:22:56.534Z
7906988 7906988 20250921014407_3OuqZ UA0006 2025-09-22T12:37:18.778Z 2025-09-29T13:05:37.118Z
7906823 7906823 20250921013057_JLTM2 UA0006 2025-09-22T12:37:07.590Z 2025-09-29T13:05:35.829Z
7905701 7905701 20250921000454_zYleU UA0006 2025-09-22T12:35:30.623Z 2025-09-29T13:05:24.628Z
7904417 7904417 20250920215412_kjiII UA0006 2025-09-22T12:33:09.849Z 2025-09-29T13:05:12.770Z
7904378 7904378 20250920215045_GDPYs UA0006 2025-09-22T12:33:07.516Z 2025-09-29T13:05:12.459Z
7895905 7895905 20250920002149_wz2XV UA0006 2025-09-21T12:39:23.962Z 2025-09-28T12:54:44.919Z
7895092 7895092 20250919232200_t24Gi UA0006 2025-09-21T12:37:57.525Z 2025-09-28T12:54:38.817Z
7891526 7891526 20250919174929_vCkA3 UA0006 2025-09-21T12:31:48.389Z 2025-09-28T12:54:08.550Z
7804981 7804981 20250911003509_Rzngv UA0006 2025-09-12T12:04:28.401Z 2025-09-19T12:56:51.908Z
7804979 7804979 20250911003451_rSdyJ UA0006 2025-09-12T12:04:27.772Z 2025-09-19T12:56:51.593Z
7804901 7804901 20250911001347_sUbO8 UA0006 2025-09-12T12:04:01.447Z 2025-09-19T12:56:50.514Z
7794947 7794947 20250909002155_pe0i8 UA0006 2025-09-10T12:05:41.893Z 2025-09-17T12:56:24.390Z
7794824 7794824 20250909000710_HQCPN UA0006 2025-09-10T12:05:24.668Z 2025-09-17T12:56:23.522Z
7790496 7790496 20250908014639_JPYjp UA0006 2025-09-09T12:07:02.972Z 2025-09-16T12:51:03.235Z
7789758 7789758 20250907225537_qOiuu UA0006 2025-09-09T12:04:44.022Z 2025-09-16T12:50:53.608Z
7783405 7783405 20250906224202_vzwhS UA0006 2025-09-08T12:05:51.639Z 2025-09-15T12:43:11.827Z
7783181 7783181 20250906215049_H66Yn UA0006 2025-09-08T12:05:06.956Z 2025-09-15T12:43:09.365Z
7779586 7779586 20250906014624_jyv3v UA0006 2025-09-07T12:09:49.527Z 2025-09-14T12:49:25.343Z
7778969 7778969 20250906002459_skTjF UA0006 2025-09-07T12:07:37.837Z 2025-09-14T12:49:03.689Z

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