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 = "NZ003W" 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
9626080 9626080 20260408130544_0j2EH NZ003W 2026-04-09T12:07:32.747Z 2026-04-09T12:07:32.747Z
9610332 9610332 20260405162602_72ylp NZ003W 2026-04-06T12:07:07.798Z 2026-04-09T12:36:44.491Z
9610290 9610290 20260405155437_OLEea NZ003W 2026-04-06T12:06:53.545Z 2026-04-09T12:36:43.174Z
9610253 9610253 20260405152348_zFDyQ NZ003W 2026-04-06T12:06:42.781Z 2026-04-09T12:36:41.659Z
9610231 9610231 20260405150121_r7kG6 NZ003W 2026-04-06T12:06:27.986Z 2026-04-09T12:36:40.654Z
9609072 9609072 20260330124053_UHRsU NZ003W 2026-04-05T12:23:21.664Z 2026-04-08T12:43:13.182Z
9606363 9606363 20260403173037_aZ4PE NZ003W 2026-04-04T12:06:35.824Z 2026-04-09T12:42:15.178Z
9606318 9606318 20260403170354_ujVnU NZ003W 2026-04-04T12:06:22.637Z 2026-04-09T12:42:13.980Z
9606310 9606310 20260403170030_uKPRi NZ003W 2026-04-04T12:06:21.112Z 2026-04-09T12:42:13.800Z
9606292 9606292 20260403165908_Tlm6P NZ003W 2026-04-04T12:06:16.938Z 2026-04-09T12:42:13.503Z
9606274 9606274 20260403164737_OsEo0 NZ003W 2026-04-04T12:06:13.862Z 2026-04-09T12:42:13.049Z
9606249 9606249 20260403163724_K7NFV NZ003W 2026-04-04T12:06:09.597Z 2026-04-09T12:42:12.457Z
9605201 9605201 20260403075000_O3H5g NZ003W 2026-04-04T12:01:07.021Z 2026-04-09T12:41:16.613Z
9601836 9601836 20260401171257_FmrLT NZ003W 2026-04-02T12:03:53.211Z 2026-04-09T12:45:36.907Z
9601753 9601753 20260401165201_j68jT NZ003W 2026-04-02T12:03:36.876Z 2026-04-09T12:45:35.528Z
9597862 9597862 20260330171135_2MKXB NZ003W 2026-03-31T12:07:08.555Z 2026-04-08T12:44:19.294Z
9597419 9597419 20260330161552_LQQX9 NZ003W 2026-03-31T12:06:21.888Z 2026-04-08T12:43:42.596Z
9593986 9593986 20260329172823_CNI50 NZ003W 2026-03-30T12:05:44.013Z 2026-04-07T12:27:41.945Z
9591558 9591558 20260328170851_JtkPW NZ003W 2026-03-29T12:04:36.345Z 2026-04-06T12:39:22.745Z
9591549 9591549 20260328170715_eMYcQ NZ003W 2026-03-29T12:04:35.779Z 2026-04-06T12:39:22.574Z
9591538 9591538 20260328170358_7DWjY NZ003W 2026-03-29T12:04:33.725Z 2026-04-06T12:39:22.009Z
9591486 9591486 20260328165202_nuIfH NZ003W 2026-03-29T12:04:29.810Z 2026-04-06T12:39:17.868Z
9591481 9591481 20260328165129_GFnmM NZ003W 2026-03-29T12:04:29.529Z 2026-04-06T12:39:17.725Z
9591383 9591383 20260328161259_8d3aE NZ003W 2026-03-29T12:04:20.158Z 2026-04-06T12:39:13.377Z
9591361 9591361 20260328155710_Frtbu NZ003W 2026-03-29T12:04:18.341Z 2026-04-06T12:39:12.318Z
9591135 9591135 20260328133913_KO0lg NZ003W 2026-03-29T12:03:54.126Z 2026-04-06T12:39:02.429Z
9591066 9591066 20260328125700_FJGqG NZ003W 2026-03-29T12:03:47.162Z 2026-04-06T12:38:49.388Z
9591058 9591058 20260328125032_mmkb3 NZ003W 2026-03-29T12:03:46.356Z 2026-04-06T12:38:48.969Z
9590899 9590899 20260328114924_QVS35 NZ003W 2026-03-29T12:03:28.223Z 2026-04-06T12:38:39.675Z
9590876 9590876 20260328113706_UNrV1 NZ003W 2026-03-29T12:03:25.744Z 2026-04-06T12:38:38.466Z
9587927 9587927 20260327165406_2plof NZ003W 2026-03-28T12:06:44.335Z 2026-04-05T12:34:59.808Z
9587854 9587854 20260327162826_AwNyn NZ003W 2026-03-28T12:06:35.193Z 2026-04-05T12:34:46.908Z
9587797 9587797 20260327160439_7hbJB NZ003W 2026-03-28T12:06:21.944Z 2026-04-05T12:34:43.950Z
9587691 9587691 20260327150741_W2vg9 NZ003W 2026-03-28T12:06:08.614Z 2026-04-05T12:34:37.462Z
9587667 9587667 20260327145757_z12Vd NZ003W 2026-03-28T12:06:03.493Z 2026-04-05T12:34:36.082Z
9587616 9587616 20260327143436_EQeK3 NZ003W 2026-03-28T12:05:55.659Z 2026-04-05T12:34:33.845Z
9587567 9587567 20260327141214_aoUsY NZ003W 2026-03-28T12:05:50.101Z 2026-04-05T12:34:31.874Z
9587441 9587441 20260327124902_FFYC1 NZ003W 2026-03-28T12:05:31.672Z 2026-04-05T12:34:26.586Z
9587112 9587112 20260327111543_eGvly NZ003W 2026-03-28T12:04:47.209Z 2026-04-05T12:34:02.032Z
9587058 9587058 20260327110010_rkQ2O NZ003W 2026-03-28T12:04:41.987Z 2026-04-05T12:34:00.397Z
9586977 9586977 20260327103515_3OoOd NZ003W 2026-03-28T12:04:29.151Z 2026-04-05T12:33:56.792Z
9586900 9586900 20260327101020_KLv2d NZ003W 2026-03-28T12:04:19.178Z 2026-04-05T12:33:53.507Z
9586865 9586865 20260327100156_8z4oz NZ003W 2026-03-28T12:04:15.249Z 2026-04-05T12:33:52.378Z
9586822 9586822 20260327094603_8N4v2 NZ003W 2026-03-28T12:04:07.378Z 2026-04-05T12:33:50.420Z
9583661 9583661 20260326170409_tbTs0 NZ003W 2026-03-27T12:09:26.544Z 2026-04-04T12:41:30.276Z
9583653 9583653 20260326165751_nbHHN NZ003W 2026-03-27T12:09:25.087Z 2026-04-04T12:41:29.826Z
9583607 9583607 20260326163508_0RfRw NZ003W 2026-03-27T12:09:17.451Z 2026-04-04T12:41:27.987Z
9566023 9566023 20260323125927_rm6WT NZ003W 2026-03-24T12:11:13.715Z 2026-03-31T12:27:44.953Z
9565976 9565976 20260323125545_DsIcZ NZ003W 2026-03-24T12:11:07.582Z 2026-03-31T12:27:44.292Z
9565920 9565920 20260323125136_Ya1hC NZ003W 2026-03-24T12:11:01.660Z 2026-03-31T12:27:43.494Z
9564649 9564649 20260323105902_xi2BA NZ003W 2026-03-24T12:08:30.850Z 2026-03-31T12:27:13.008Z
9564305 9564305 20260323102300_8MCDr NZ003W 2026-03-24T12:07:50.694Z 2026-03-31T12:27:06.977Z
9564255 9564255 20260323101900_ZSUNL NZ003W 2026-03-24T12:07:44.258Z 2026-03-31T12:27:06.159Z
9559232 9559232 20260321164828_JIy7k NZ003W 2026-03-23T12:10:58.586Z 2026-03-29T12:20:35.524Z
9559186 9559186 20260321164506_LXLCF NZ003W 2026-03-23T12:10:57.011Z 2026-03-29T12:20:35.013Z
9559077 9559077 20260321162600_X58Zh NZ003W 2026-03-23T12:10:53.116Z 2026-03-29T12:20:33.651Z
9559036 9559036 20260321162119_nYLOR NZ003W 2026-03-23T12:10:52.112Z 2026-03-29T12:20:33.371Z
9558580 9558580 20260322170231_DME2W NZ003W 2026-03-23T12:06:49.853Z 2026-03-30T12:30:17.239Z
9558414 9558414 20260322163521_B2oEA NZ003W 2026-03-23T12:06:42.805Z 2026-03-30T12:30:12.847Z
9556939 9556939 20260322121401_N40NY NZ003W 2026-03-23T12:05:22.275Z 2026-03-30T12:29:15.422Z
9556937 9556937 20260322121401_lB7oe NZ003W 2026-03-23T12:05:22.019Z 2026-03-30T12:29:15.300Z
9556934 9556934 20260322121354_KwY65 NZ003W 2026-03-23T12:05:21.841Z 2026-03-30T12:29:15.270Z
9556643 9556643 20260322111541_n3qL8 NZ003W 2026-03-23T12:05:04.472Z 2026-03-30T12:29:06.862Z
9555939 9555939 20260322084607_NWPX8 NZ003W 2026-03-23T12:04:10.163Z 2026-03-30T12:28:39.732Z
9555871 9555871 20260322082720_3tocE NZ003W 2026-03-23T12:04:04.907Z 2026-03-30T12:28:37.774Z
9550657 9550657 20260320165738_o2Crr NZ003W 2026-03-22T12:25:35.030Z 2026-03-28T12:36:33.888Z
9550423 9550423 20260320163724_SUU35 NZ003W 2026-03-22T12:25:14.241Z 2026-03-28T12:36:30.569Z
9550408 9550408 20260320163720_xEE2Y NZ003W 2026-03-22T12:25:13.855Z 2026-03-28T12:36:30.535Z
9550289 9550289 20260320162758_E5Giu NZ003W 2026-03-22T12:25:06.585Z 2026-03-28T12:36:29.182Z
9550128 9550128 20260320161133_lLZxC NZ003W 2026-03-22T12:24:56.669Z 2026-03-28T12:36:27.289Z
9549639 9549639 20260320152106_x3a3A NZ003W 2026-03-22T12:24:20.145Z 2026-03-28T12:36:07.649Z
9549489 9549489 20260320150445_cbOJ9 NZ003W 2026-03-22T12:24:03.118Z 2026-03-28T12:36:04.763Z
9549439 9549439 20260320145938_0W1XY NZ003W 2026-03-22T12:23:59.679Z 2026-03-28T12:36:03.952Z
9549390 9549390 20260320145407_LBkYs NZ003W 2026-03-22T12:23:56.084Z 2026-03-28T12:36:02.009Z
9549386 9549386 20260320145352_B2wZU NZ003W 2026-03-22T12:23:55.923Z 2026-03-28T12:36:01.974Z
9548665 9548665 20260321152544_nLAAz NZ003W 2026-03-22T12:15:47.543Z 2026-03-29T12:20:27.886Z
9548506 9548506 20260321151006_gqKid NZ003W 2026-03-22T12:15:30.406Z 2026-03-29T12:20:26.863Z
9548395 9548395 20260321150034_m3RP1 NZ003W 2026-03-22T12:15:21.520Z 2026-03-29T12:20:25.966Z
9547944 9547944 20260321141513_3UBbN NZ003W 2026-03-22T12:14:33.730Z 2026-03-29T12:20:22.661Z
9547688 9547688 20260321135139_E7RRv NZ003W 2026-03-22T12:14:06.535Z 2026-03-29T12:20:11.220Z
9547582 9547582 20260321134356_P7C6w NZ003W 2026-03-22T12:13:56.619Z 2026-03-22T12:27:38.497Z
9547072 9547072 20260321125044_25o4i NZ003W 2026-03-22T12:12:56.631Z 2026-03-29T12:20:06.380Z
9546828 9546828 20260321123026_Nl3Ya NZ003W 2026-03-22T12:12:27.830Z 2026-03-29T12:20:04.651Z
9546745 9546745 20260321122347_MwE9r NZ003W 2026-03-22T12:12:19.808Z 2026-03-22T12:27:38.316Z
9546704 9546704 20260321122149_vMde5 NZ003W 2026-03-22T12:12:15.981Z 2026-03-29T12:20:03.396Z
9546692 9546692 20260321121954_32blz NZ003W 2026-03-22T12:12:15.125Z 2026-03-29T12:20:03.275Z
9546604 9546604 20260321121157_2ZyBl NZ003W 2026-03-22T12:12:04.215Z 2026-03-22T12:27:38.287Z
9546386 9546386 20260321115638_HN9go NZ003W 2026-03-22T12:11:37.635Z 2026-03-29T12:20:00.559Z
9546103 9546103 20260321113623_yiQDA NZ003W 2026-03-22T12:11:02.072Z 2026-03-22T12:27:38.185Z
9546093 9546093 20260321113559_1n6Eh NZ003W 2026-03-22T12:11:00.794Z 2026-03-29T12:19:47.481Z
9545845 9545845 20260321111331_q2HxB NZ003W 2026-03-22T12:10:24.224Z 2026-03-29T12:19:45.006Z
9545813 9545813 20260321111000_uE8Di NZ003W 2026-03-22T12:10:19.661Z 2026-03-29T12:19:44.670Z
9545593 9545593 20260321105035_bg2Nl NZ003W 2026-03-22T12:09:48.625Z 2026-03-29T12:19:41.589Z
9545485 9545485 20260321103947_Zl75a NZ003W 2026-03-22T12:09:31.271Z 2026-03-29T12:19:40.552Z
9545397 9545397 20260321103102_V7IAA NZ003W 2026-03-22T12:09:20.082Z 2026-03-22T12:27:38.028Z
9544624 9544624 20260321090429_jwuAi NZ003W 2026-03-22T12:07:19.474Z 2026-03-29T12:19:31.824Z
9544325 9544325 20260321081843_3MmUS NZ003W 2026-03-22T12:06:29.029Z 2026-03-29T12:19:28.361Z
9539883 9539883 20260319092341_f8f97 NZ003W 2026-03-21T12:24:43.435Z 2026-03-27T12:41:24.724Z
9539330 9539330 20260320143405_jhylr NZ003W 2026-03-21T12:19:17.744Z 2026-03-28T12:35:59.364Z
9539121 9539121 20260320141132_3KPA9 NZ003W 2026-03-21T12:18:58.429Z 2026-03-28T12:35:56.816Z

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