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

129 rows where station_code = "ZA000E" 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
9800749 9800749 20260426033450_OFR6v ZA000E 2026-04-27T12:30:35.674Z 2026-04-29T12:41:41.199Z
9796610 9796610 20260425182506_OmzuX ZA000E 2026-04-27T12:15:56.577Z 2026-04-29T12:37:34.484Z
9786354 9786354 20260425013157_iz5KL ZA000E 2026-04-26T12:20:41.365Z 2026-04-29T12:49:27.653Z
9786006 9786006 20260425010359_M4F7s ZA000E 2026-04-26T12:20:03.354Z 2026-04-29T12:49:01.264Z
9783529 9783529 20260424212956_1obO4 ZA000E 2026-04-26T12:14:57.104Z 2026-04-29T12:47:26.446Z
9770639 9770639 20260424040328_kiJSu ZA000E 2026-04-25T12:32:35.052Z 2026-04-25T12:59:22.505Z
9770207 9770207 20260424030154_kFL73 ZA000E 2026-04-25T12:31:33.860Z 2026-04-29T12:58:12.555Z
9769808 9769808 20260424023758_g6k5o ZA000E 2026-04-25T12:30:48.563Z 2026-04-29T12:57:48.072Z
9764658 9764658 20260423212738_oxg0y ZA000E 2026-04-25T12:16:55.506Z 2026-04-29T12:54:59.762Z
9763727 9763727 20260423185428_cr2sl ZA000E 2026-04-25T12:13:31.512Z 2026-04-29T12:54:20.174Z
9758007 9758007 20260423035219_Q4kNA ZA000E 2026-04-24T12:07:22.238Z 2026-04-29T13:08:09.617Z
9758004 9758004 20260423035113_3j7L3 ZA000E 2026-04-24T12:07:22.194Z 2026-04-29T13:08:09.551Z
9757830 9757830 20260423032435_WnVyj ZA000E 2026-04-24T12:07:19.958Z 2026-04-29T13:08:06.491Z
9756614 9756614 20260423022606_k6YdK ZA000E 2026-04-24T12:07:04.533Z 2026-04-29T13:07:07.675Z
9752141 9752141 20260423001435_CZn1b ZA000E 2026-04-24T12:05:07.232Z 2026-04-29T13:04:59.936Z
9751941 9751941 20260423000841_v0Cfn ZA000E 2026-04-24T12:05:03.283Z 2026-04-29T13:04:57.945Z
9750925 9750925 20260422233154_eRXw8 ZA000E 2026-04-24T12:04:34.036Z 2026-04-29T13:04:44.073Z
9728282 9728282 20260421024835_nOEeY ZA000E 2026-04-22T12:24:15.873Z 2026-04-29T13:21:15.877Z
9721116 9721116 20260420040854_etzBP ZA000E 2026-04-21T12:29:17.869Z 2026-04-28T13:39:27.895Z
9672481 9672481 20260413230457_rEx4L ZA000E 2026-04-15T12:27:35.390Z 2026-04-22T13:15:04.886Z
9629241 9629241 20260407221236_rbToh ZA000E 2026-04-09T12:18:35.729Z 2026-04-16T12:59:58.364Z
9621320 9621320 20260407002117_pomHt ZA000E 2026-04-08T12:18:00.394Z 2026-04-15T13:07:50.419Z
9619047 9619047 20260406213437_Zut3l ZA000E 2026-04-08T12:11:59.562Z 2026-04-15T13:06:44.469Z
9592664 9592664 20260329025355_1fJXj ZA000E 2026-03-30T12:01:33.571Z 2026-04-07T12:26:37.980Z
9584772 9584772 20260325220358_o3KBv ZA000E 2026-03-27T12:16:05.759Z 2026-04-03T12:39:40.621Z
9581476 9581476 20260326031619_TnGEU ZA000E 2026-03-27T12:03:13.022Z 2026-04-04T12:39:07.538Z
9579416 9579416 20260324200833_GKIMW ZA000E 2026-03-26T12:13:36.927Z 2026-04-02T12:37:08.868Z
9576505 9576505 20260325022338_wh2z8 ZA000E 2026-03-26T12:02:28.607Z 2026-04-03T12:36:10.612Z
9576427 9576427 20260325020449_v3pkb ZA000E 2026-03-26T12:02:11.462Z 2026-04-03T12:35:58.244Z
9576176 9576176 20260325013123_rkQW1 ZA000E 2026-03-26T12:01:29.645Z 2026-04-03T12:35:47.303Z
9571659 9571659 20260324032525_CaXKd ZA000E 2026-03-25T12:02:14.984Z 2026-04-02T12:34:36.828Z
9559655 9559655 20260321190303_atNLK ZA000E 2026-03-23T12:11:25.464Z 2026-03-29T12:20:42.371Z
9501379 9501379 20260315220720_FVzrU ZA000E 2026-03-17T12:24:55.225Z 2026-03-23T12:22:44.195Z
9474095 9474095 20260312203851_22AT9 ZA000E 2026-03-14T12:21:59.185Z 2026-03-20T12:37:15.851Z
9469685 9469685 20260313032906_CBlgn ZA000E 2026-03-14T12:05:13.143Z 2026-03-21T12:49:00.495Z
9468990 9468990 20260313012731_eIOXL ZA000E 2026-03-14T12:02:34.976Z 2026-03-21T12:48:32.335Z
9467243 9467243 20260311205713_5qfIf ZA000E 2026-03-13T12:18:49.681Z 2026-03-19T12:45:50.803Z
9462924 9462924 20260312003439_Uh8fL ZA000E 2026-03-13T12:02:36.953Z 2026-03-20T12:36:18.901Z
9462468 9462468 20260311232325_WxKJa ZA000E 2026-03-13T12:01:06.626Z 2026-03-20T12:36:16.166Z
9457067 9457067 20260311022640_R9fG3 ZA000E 2026-03-12T12:02:44.030Z 2026-03-19T12:44:25.246Z
9456848 9456848 20260311012005_B18NA ZA000E 2026-03-12T12:01:58.791Z 2026-03-19T12:44:22.764Z
9456769 9456769 20260311005042_K2KKc ZA000E 2026-03-12T12:01:44.295Z 2026-03-19T12:44:21.764Z
9455988 9455988 20260309211910_smUD7 ZA000E 2026-03-11T12:15:23.209Z 2026-03-17T12:42:45.127Z
9450315 9450315 20260308200816_uOG7m ZA000E 2026-03-10T12:19:13.482Z 2026-03-16T12:44:40.017Z
9446823 9446823 20260309030913_0boIE ZA000E 2026-03-10T12:04:04.377Z 2026-03-17T12:41:43.370Z
9446223 9446223 20260309002933_KavT2 ZA000E 2026-03-10T12:01:32.194Z 2026-03-17T12:41:34.820Z
9442281 9442281 20260308025236_gHiMr ZA000E 2026-03-09T12:03:22.940Z 2026-03-16T12:43:48.949Z
9441976 9441976 20260308004157_jY1EM ZA000E 2026-03-09T12:02:03.656Z 2026-03-16T12:43:34.761Z
9431770 9431770 20260306015217_jl3n2 ZA000E 2026-03-07T14:01:57.661Z 2026-03-14T12:39:17.263Z
9425408 9425408 20260303210738_h6EGt ZA000E 2026-03-05T14:14:55.821Z 2026-03-11T12:29:04.172Z
9419127 9419127 20260303013853_JybuR ZA000E 2026-03-04T14:00:48.430Z 2026-03-11T12:27:45.362Z
9415640 9415640 20260302024353_72CEq ZA000E 2026-03-03T14:00:59.733Z 2026-03-10T12:35:46.410Z
9415613 9415613 20260302021520_RhxIE ZA000E 2026-03-03T14:00:53.252Z 2026-03-10T12:35:45.479Z
9408919 9408919 20260227232823_seg13 ZA000E 2026-03-01T14:00:11.015Z 2026-03-08T12:40:47.456Z
9401668 9401668 20260227011039_w47Uh ZA000E 2026-02-28T14:01:44.133Z 2026-03-07T14:45:56.877Z
9401469 9401469 20260227000050_Le7P8 ZA000E 2026-02-28T14:00:52.557Z 2026-03-07T14:45:46.082Z
9395036 9395036 20260224224021_ngU71 ZA000E 2026-02-26T14:21:00.512Z 2026-03-04T14:19:29.286Z
9394579 9394579 20260224203955_9lZdn ZA000E 2026-02-26T14:20:08.247Z 2026-03-04T14:19:23.838Z
9386269 9386269 20260223193954_jXvS1 ZA000E 2026-02-25T14:17:25.022Z 2026-03-03T14:32:46.674Z
9365052 9365052 20260222015439_PJbmQ ZA000E 2026-02-23T14:01:51.387Z 2026-02-24T14:14:47.665Z
9364581 9364581 20260220222902_BynGm ZA000E 2026-02-22T14:21:45.680Z 2026-03-01T14:22:55.295Z
9351682 9351682 20260217214951_39vZw ZA000E 2026-02-20T14:02:45.994Z 2026-02-26T14:40:11.260Z
9351256 9351256 20260217185236_5K3NJ ZA000E 2026-02-20T14:02:42.486Z 2026-02-26T14:40:04.514Z
9340334 9340334 20260216234923_o4qZ4 ZA000E 2026-02-18T14:24:39.790Z 2026-02-25T14:42:53.397Z
9335630 9335630 20260217022024_afwQf ZA000E 2026-02-18T14:01:49.347Z 2026-02-26T14:38:57.437Z
9335260 9335260 20260217011035_9BNxL ZA000E 2026-02-18T14:00:29.117Z 2026-02-26T14:38:52.422Z
9335131 9335131 20260216004913_1YEkS ZA000E 2026-02-17T14:26:27.795Z 2026-02-24T14:43:36.364Z
9334421 9334421 20260215214516_Igv3n ZA000E 2026-02-17T14:24:10.261Z 2026-02-24T14:43:09.714Z
9334407 9334407 20260215214348_4hl2y ZA000E 2026-02-17T14:24:07.265Z 2026-02-24T14:43:09.247Z
9333979 9333979 20260215192847_u5AG7 ZA000E 2026-02-17T14:22:29.444Z 2026-02-24T14:42:58.194Z
9330911 9330911 20260216030715_Q9ybZ ZA000E 2026-02-17T14:03:35.553Z 2026-02-25T14:41:33.719Z
9330513 9330513 20260216014917_gNkyC ZA000E 2026-02-17T14:01:48.682Z 2026-02-25T14:41:28.382Z
9330141 9330141 20260215002418_POMPR ZA000E 2026-02-16T14:22:42.701Z 2026-02-23T14:47:41.895Z
9229463 9229463 20260119015004_3OIhO ZA000E 2026-01-20T14:22:42.226Z 2026-01-27T15:03:27.267Z
9229245 9229245 20260119011218_t8dVd ZA000E 2026-01-20T14:21:41.754Z 2026-01-27T15:03:13.649Z
9228263 9228263 20260118210403_WFWgL ZA000E 2026-01-20T14:16:56.995Z 2026-01-27T15:01:39.503Z
9167012 9167012 20260107213325_AEyfH ZA000E 2026-01-09T14:05:50.380Z 2026-01-16T15:10:35.667Z
9158500 9158500 20260105224611_yb8by ZA000E 2026-01-07T14:06:17.994Z 2026-01-13T15:07:25.245Z
9157443 9157443 20260107015332_EmnY3 ZA000E 2026-01-07T14:01:51.397Z 2026-01-13T15:02:00.360Z
9100610 9100610 20251229204958_oVKCj ZA000E 2025-12-31T14:03:54.214Z 2025-12-31T14:29:49.698Z
9084313 9084313 20251228013222_8aRDr ZA000E 2025-12-30T14:35:18.704Z 2025-12-30T14:53:54.822Z
9023869 9023869 20251220225856_MvkIr ZA000E 2025-12-27T15:10:02.710Z 2025-12-27T15:10:02.710Z
9023767 9023767 20251220215946_a2fph ZA000E 2025-12-27T15:09:40.303Z 2025-12-29T15:26:22.473Z
8995243 8995243 20251217233736_OXQZV ZA000E 2025-12-26T15:05:15.341Z 2025-12-26T15:05:15.341Z
8994284 8994284 20251219004213_mc3HN ZA000E 2025-12-26T14:54:28.910Z 2025-12-26T14:54:28.910Z
8994113 8994113 20251219002141_dbXJn ZA000E 2025-12-26T14:54:05.347Z 2025-12-27T15:28:50.291Z
8993943 8993943 20251219000154_w3JCA ZA000E 2025-12-26T14:53:54.343Z 2025-12-27T15:28:43.052Z
8993794 8993794 20251218233559_5Sggw ZA000E 2025-12-26T14:53:43.461Z 2025-12-27T15:28:15.581Z
8993787 8993787 20251218233400_2WwTx ZA000E 2025-12-26T14:53:42.165Z 2025-12-27T15:28:14.042Z
8993591 8993591 20251218224916_528Rh ZA000E 2025-12-26T14:53:17.083Z 2025-12-26T14:53:17.083Z
8993541 8993541 20251218223544_Zw20s ZA000E 2025-12-26T14:53:13.041Z 2025-12-27T15:27:50.912Z
8993416 8993416 20251218214941_q2aFG ZA000E 2025-12-26T14:52:55.303Z 2025-12-26T14:52:55.303Z
8993288 8993288 20251218211915_AEXam ZA000E 2025-12-26T14:52:40.513Z 2025-12-27T15:27:26.749Z
8985183 8985183 20251218012931_WUcVb ZA000E 2025-12-26T14:33:20.552Z 2025-12-27T15:18:55.181Z
8983441 8983441 20251219215141_VUQso ZA000E 2025-12-26T14:29:04.381Z 2025-12-28T15:23:39.338Z
8951515 8951515 20251215014648_3YtZk ZA000E 2025-12-24T15:08:50.797Z 2025-12-24T15:08:50.797Z
8950985 8950985 20251215011840_nFT8K ZA000E 2025-12-24T15:07:43.357Z 2025-12-24T15:07:43.357Z
8950653 8950653 20251215010510_Kg4ZK ZA000E 2025-12-24T15:07:35.566Z 2025-12-24T15:07:35.566Z
8950532 8950532 20251215005931_5nlCN ZA000E 2025-12-24T15:07:32.939Z 2025-12-24T15:07:32.939Z
8950359 8950359 20251215005011_6JRjL ZA000E 2025-12-24T15:07:29.091Z 2025-12-24T15:07:29.091Z

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