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 = "NZ0014" 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
9626711 9626711 20260408145701_2nicF NZ0014 2026-04-09T12:09:04.817Z 2026-04-09T12:09:04.817Z
9626687 9626687 20260408145105_MKEO4 NZ0014 2026-04-09T12:09:00.879Z 2026-04-09T12:09:00.879Z
9626023 9626023 20260408125330_Gs3Yz NZ0014 2026-04-09T12:07:20.904Z 2026-04-09T12:07:20.904Z
9625990 9625990 20260408124716_QX8Jr NZ0014 2026-04-09T12:07:15.860Z 2026-04-09T12:07:15.860Z
9625840 9625840 20260408120415_jlKuX NZ0014 2026-04-09T12:06:53.652Z 2026-04-09T12:06:53.652Z
9625838 9625838 20260408120415_atc9V NZ0014 2026-04-09T12:06:53.242Z 2026-04-09T12:06:53.242Z
9605917 9605917 20260403131014_or8fY NZ0014 2026-04-04T12:04:27.106Z 2026-04-09T12:42:03.786Z
9605876 9605876 20260403123506_T3ZT3 NZ0014 2026-04-04T12:04:17.034Z 2026-04-09T12:42:03.032Z
9605829 9605829 20260403121113_v6k9J NZ0014 2026-04-04T12:04:04.069Z 2026-04-09T12:41:58.885Z
9605822 9605822 20260403121054_rURBB NZ0014 2026-04-04T12:04:02.937Z 2026-04-09T12:41:54.930Z
9604100 9604100 20260402154714_GsW9o NZ0014 2026-04-03T12:05:55.280Z 2026-04-09T12:44:15.605Z
9603620 9603620 20260402112421_hL5w8 NZ0014 2026-04-03T12:03:50.351Z 2026-04-09T12:44:05.209Z
9603370 9603370 20260402094414_wwIrT NZ0014 2026-04-03T12:02:43.985Z 2026-04-09T12:43:30.623Z
9603325 9603325 20260402093401_c7Tka NZ0014 2026-04-03T12:02:36.910Z 2026-04-09T12:43:25.036Z
9603174 9603174 20260402083213_10JeP NZ0014 2026-04-03T12:02:03.272Z 2026-04-09T12:43:22.321Z
9601773 9601773 20260401170056_Fzfgl NZ0014 2026-04-02T12:03:41.135Z 2026-04-09T12:45:35.925Z
9599770 9599770 20260331164613_McdfA NZ0014 2026-04-01T12:04:46.912Z 2026-04-09T12:47:30.119Z
9599704 9599704 20260331162659_2l7zy NZ0014 2026-04-01T12:04:34.232Z 2026-04-09T12:47:16.139Z
9599147 9599147 20260331120859_CiE81 NZ0014 2026-04-01T12:02:32.063Z 2026-04-09T12:46:42.484Z
9599136 9599136 20260331120242_aV4IU NZ0014 2026-04-01T12:02:29.989Z 2026-04-09T12:46:42.323Z
9599057 9599057 20260331111704_HoDNl NZ0014 2026-04-01T12:02:13.304Z 2026-04-09T12:46:40.714Z
9598979 9598979 20260331101521_gm2ZL NZ0014 2026-04-01T12:01:53.017Z 2026-04-09T12:46:39.289Z
9598964 9598964 20260331095143_pBz1j NZ0014 2026-04-01T12:01:48.151Z 2026-04-09T12:46:39.013Z
9598926 9598926 20260331091517_QoXBV NZ0014 2026-04-01T12:01:37.259Z 2026-04-09T12:46:38.245Z
9597989 9597989 20260330172754_Y6HR3 NZ0014 2026-03-31T12:07:24.803Z 2026-04-08T12:44:22.675Z
9597945 9597945 20260330172207_0DZ9j NZ0014 2026-03-31T12:07:19.844Z 2026-04-08T12:44:21.405Z
9597930 9597930 20260330171712_2619Z NZ0014 2026-03-31T12:07:18.145Z 2026-04-08T12:44:20.958Z
9597853 9597853 20260330170922_DZp0u NZ0014 2026-03-31T12:07:07.351Z 2026-04-08T12:44:19.034Z
9597791 9597791 20260330170026_JG2ns NZ0014 2026-03-31T12:07:01.255Z 2026-04-08T12:44:17.619Z
9597782 9597782 20260330165841_Oe3TU NZ0014 2026-03-31T12:06:59.939Z 2026-04-08T12:44:17.270Z
9597768 9597768 20260330165826_7Z2Qx NZ0014 2026-03-31T12:06:59.182Z 2026-04-08T12:44:16.971Z
9597654 9597654 20260330164749_AjywN NZ0014 2026-03-31T12:06:50.281Z 2026-04-08T12:44:13.089Z
9597437 9597437 20260330161735_Ic4Ly NZ0014 2026-03-31T12:06:23.367Z 2026-04-08T12:43:42.990Z
9597430 9597430 20260330161719_xWNQU NZ0014 2026-03-31T12:06:22.667Z 2026-04-08T12:43:42.727Z
9597351 9597351 20260330161105_TZx4Z NZ0014 2026-03-31T12:06:13.668Z 2026-04-08T12:43:41.270Z
9597315 9597315 20260330155942_9fFlg NZ0014 2026-03-31T12:06:07.200Z 2026-04-08T12:43:40.300Z
9597302 9597302 20260330155913_5tGyX NZ0014 2026-03-31T12:06:06.492Z 2026-04-08T12:43:38.077Z
9597293 9597293 20260330155830_4uDIo NZ0014 2026-03-31T12:06:05.684Z 2026-04-08T12:43:37.906Z
9597268 9597268 20260330155414_f0N2t NZ0014 2026-03-31T12:06:03.435Z 2026-04-08T12:43:37.457Z
9597193 9597193 20260330153401_I3UWK NZ0014 2026-03-31T12:05:52.995Z 2026-04-08T12:43:35.295Z
9597079 9597079 20260330150918_BJ3iY NZ0014 2026-03-31T12:05:37.075Z 2026-04-08T12:43:32.107Z
9597013 9597013 20260330145724_mB1eu NZ0014 2026-03-31T12:05:29.473Z 2026-04-08T12:43:30.461Z
9596995 9596995 20260330145359_ce7GV NZ0014 2026-03-31T12:05:26.814Z 2026-04-08T12:43:29.841Z
9596966 9596966 20260330144952_3G4iJ NZ0014 2026-03-31T12:05:22.836Z 2026-04-08T12:43:29.180Z
9596962 9596962 20260330144712_FiZQm NZ0014 2026-03-31T12:05:22.408Z 2026-04-08T12:43:29.117Z
9596143 9596143 20260330112448_WMeET NZ0014 2026-03-31T12:03:35.704Z 2026-04-08T12:42:42.459Z
9596048 9596048 20260330105018_BEBMW NZ0014 2026-03-31T12:03:14.198Z 2026-04-08T12:42:39.544Z
9595967 9595967 20260330101802_3rqYu NZ0014 2026-03-31T12:03:01.301Z 2026-04-08T12:42:37.422Z
9595959 9595959 20260330101552_71OCh NZ0014 2026-03-31T12:03:00.393Z 2026-04-08T12:42:37.344Z
9595932 9595932 20260330101211_AdT9b NZ0014 2026-03-31T12:02:54.275Z 2026-04-08T12:42:36.638Z
9595777 9595777 20260330083627_TLY3e NZ0014 2026-03-31T12:02:27.855Z 2026-04-08T12:42:31.911Z
9595739 9595739 20260330081854_gOjw6 NZ0014 2026-03-31T12:02:20.925Z 2026-04-08T12:42:30.999Z
9595641 9595641 20260330073757_11Upz NZ0014 2026-03-31T12:02:03.621Z 2026-04-08T12:42:28.017Z
9591550 9591550 20260328170802_7kxcb NZ0014 2026-03-29T12:04:36.091Z 2026-04-06T12:39:22.645Z
9591399 9591399 20260328162026_tx4ct NZ0014 2026-03-29T12:04:21.681Z 2026-04-06T12:39:14.183Z
9590917 9590917 20260328115652_nk481 NZ0014 2026-03-29T12:03:29.685Z 2026-04-06T12:38:40.620Z
9590722 9590722 20260328105501_Px9as NZ0014 2026-03-29T12:03:11.143Z 2026-04-06T12:38:31.841Z
9590696 9590696 20260328104836_joA3r NZ0014 2026-03-29T12:03:09.182Z 2026-04-06T12:38:30.739Z
9590307 9590307 20260328080804_DGEVr NZ0014 2026-03-29T12:02:24.289Z 2026-04-06T12:38:00.806Z
9568565 9568565 20260323165609_aM3wj NZ0014 2026-03-24T12:15:18.000Z 2026-03-31T12:28:30.788Z
9568435 9568435 20260323164402_5ExHU NZ0014 2026-03-24T12:15:06.849Z 2026-03-31T12:28:29.249Z
9568327 9568327 20260323163157_ww0bN NZ0014 2026-03-24T12:14:53.246Z 2026-03-31T12:28:27.395Z
9567485 9567485 20260323152146_wNkEO NZ0014 2026-03-24T12:13:41.090Z 2026-03-31T12:28:14.670Z
9566475 9566475 20260323134143_w5nqz NZ0014 2026-03-24T12:11:56.309Z 2026-03-31T12:27:52.514Z
9566358 9566358 20260323132914_dvqm3 NZ0014 2026-03-24T12:11:43.617Z 2026-03-31T12:27:49.440Z
9544197 9544197 20260321075740_a126x NZ0014 2026-03-22T12:06:04.576Z 2026-03-29T12:19:17.628Z
9539709 9539709 20260320162303_j1usp NZ0014 2026-03-21T12:20:04.180Z 2026-03-28T12:36:28.613Z
9539633 9539633 20260320154908_0Pvxd NZ0014 2026-03-21T12:19:54.797Z 2026-03-28T12:36:22.632Z
9538985 9538985 20260320140057_lxe18 NZ0014 2026-03-21T12:18:42.727Z 2026-03-28T12:35:55.495Z
9536072 9536072 20260320090857_ypC9J NZ0014 2026-03-21T12:12:33.463Z 2026-03-28T12:34:57.161Z
9529190 9529190 20260318172655_ZO96e NZ0014 2026-03-20T12:22:57.109Z 2026-03-26T12:38:49.835Z
9527657 9527657 20260318150452_0Dsxu NZ0014 2026-03-20T12:21:36.715Z 2026-03-26T12:38:30.371Z
9527596 9527596 20260318150009_OesmK NZ0014 2026-03-20T12:21:33.354Z 2026-03-26T12:38:29.900Z
9527510 9527510 20260318144932_q7oqB NZ0014 2026-03-20T12:21:21.550Z 2026-03-26T12:38:29.106Z
9527453 9527453 20260318144249_xFH9I NZ0014 2026-03-20T12:21:18.428Z 2026-03-26T12:38:28.713Z
9527286 9527286 20260318142526_2tw2Q NZ0014 2026-03-20T12:21:10.065Z 2026-03-26T12:38:27.571Z
9527150 9527150 20260318140719_78X3V NZ0014 2026-03-20T12:21:02.061Z 2026-03-26T12:38:26.354Z
9526991 9526991 20260318134523_eOnZs NZ0014 2026-03-20T12:20:53.961Z 2026-03-26T12:38:25.232Z
9526702 9526702 20260319172203_UFS0F NZ0014 2026-03-20T12:15:28.692Z 2026-03-27T12:42:29.555Z
9526689 9526689 20260319172103_asJaf NZ0014 2026-03-20T12:15:28.046Z 2026-03-27T12:42:29.492Z
9526663 9526663 20260319171512_ZWZ2E NZ0014 2026-03-20T12:15:26.552Z 2026-03-27T12:42:29.280Z
9526416 9526416 20260319163741_CGsTk NZ0014 2026-03-20T12:15:12.042Z 2026-03-27T12:42:25.958Z
9526369 9526369 20260319163235_EtQHX NZ0014 2026-03-20T12:15:09.798Z 2026-03-27T12:42:25.572Z
9526284 9526284 20260319161933_m7zAQ NZ0014 2026-03-20T12:15:03.743Z 2026-03-27T12:42:24.676Z
9526255 9526255 20260319161500_EG1Ej NZ0014 2026-03-20T12:14:58.499Z 2026-03-27T12:42:24.332Z
9526137 9526137 20260319160601_aBT67 NZ0014 2026-03-20T12:14:52.137Z 2026-03-27T12:42:23.475Z
9526075 9526075 20260319155419_2s36g NZ0014 2026-03-20T12:14:48.361Z 2026-03-27T12:42:22.890Z
9526070 9526070 20260319155250_zhpg5 NZ0014 2026-03-20T12:14:48.156Z 2026-03-27T12:42:22.863Z
9525944 9525944 20260319153407_rkds8 NZ0014 2026-03-20T12:14:42.047Z 2026-03-27T12:42:21.323Z
9525378 9525378 20260319142109_VEush NZ0014 2026-03-20T12:14:11.118Z 2026-03-27T12:42:03.232Z
9525237 9525237 20260319135745_5vopU NZ0014 2026-03-20T12:14:03.592Z 2026-03-27T12:42:02.052Z
9525210 9525210 20260319134702_qjRQB NZ0014 2026-03-20T12:13:58.194Z 2026-03-27T12:42:01.740Z
9525177 9525177 20260319133807_5cQ5g NZ0014 2026-03-20T12:13:54.950Z 2026-03-27T12:42:01.208Z
9525139 9525139 20260319133224_aJUqa NZ0014 2026-03-20T12:13:51.476Z 2026-03-27T12:42:00.825Z
9524962 9524962 20260319130311_pA1sq NZ0014 2026-03-20T12:13:42.995Z 2026-03-27T12:41:58.698Z
9524944 9524944 20260319130142_SkodZ NZ0014 2026-03-20T12:13:42.039Z 2026-03-27T12:41:58.509Z
9524839 9524839 20260319124253_h5z02 NZ0014 2026-03-20T12:13:35.091Z 2026-03-27T12:41:57.501Z
9524713 9524713 20260319122742_e48dt NZ0014 2026-03-20T12:13:24.289Z 2026-03-27T12:41:55.789Z
9524657 9524657 20260319122039_k3jA3 NZ0014 2026-03-20T12:13:18.776Z 2026-03-27T12:41:54.974Z
9524508 9524508 20260319120654_MdU2n NZ0014 2026-03-20T12:13:05.032Z 2026-03-27T12:41:53.631Z

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