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

4,898 rows where station_code = "NL000N" 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
9606886 9606886 20260402230334_OUfjW NL000N 2026-04-04T12:12:09.671Z 2026-04-06T12:23:54.090Z
9606820 9606820 20260402215753_s7zu2 NL000N 2026-04-04T12:11:50.588Z 2026-04-06T12:23:46.944Z
9606819 9606819 20260402214122_sSl2i NL000N 2026-04-04T12:11:50.120Z 2026-04-06T12:23:46.812Z
9600741 9600741 20260331014031_oQZdI NL000N 2026-04-01T12:11:42.308Z 2026-04-06T12:33:49.206Z
9600731 9600731 20260331013726_xM5qb NL000N 2026-04-01T12:11:40.683Z 2026-04-06T12:33:48.620Z
9600592 9600592 20260330235013_CaEzj NL000N 2026-04-01T12:11:16.685Z 2026-04-06T12:33:41.621Z
9600590 9600590 20260330234634_z3Og5 NL000N 2026-04-01T12:11:16.285Z 2026-04-06T12:33:41.476Z
9600533 9600533 20260330231507_dyALT NL000N 2026-04-01T12:11:06.412Z 2026-04-06T12:33:32.933Z
9600495 9600495 20260330224034_w7wk6 NL000N 2026-04-01T12:10:55.365Z 2026-04-06T12:33:28.375Z
9600363 9600363 20260330204423_sR2Lj NL000N 2026-04-01T12:10:26.175Z 2026-04-06T12:33:19.725Z
9598647 9598647 20260331020814_gYzu9 NL000N 2026-04-01T12:00:20.006Z 2026-04-06T12:26:41.883Z
9595404 9595404 20260330035314_jVK2Q NL000N 2026-03-31T12:01:18.214Z 2026-04-06T12:30:01.473Z
9594716 9594716 20260329000919_W3T2o NL000N 2026-03-30T12:10:12.500Z 2026-04-06T12:40:13.401Z
9592930 9592930 20260329035703_P44A8 NL000N 2026-03-30T12:02:21.298Z 2026-04-06T12:34:41.034Z
9592832 9592832 20260329033430_KCXuk NL000N 2026-03-30T12:02:02.652Z 2026-04-06T12:34:36.383Z
9592591 9592591 20260329024143_23nD4 NL000N 2026-03-30T12:01:23.597Z 2026-04-06T12:34:16.773Z
9588488 9588488 20260326232336_Xc3wg NL000N 2026-03-28T12:11:15.873Z 2026-04-04T12:42:16.290Z
9588353 9588353 20260326220345_0qJmL NL000N 2026-03-28T12:10:55.977Z 2026-04-04T12:42:00.674Z
9586148 9586148 20260327041407_d2SbU NL000N 2026-03-28T12:02:20.963Z 2026-04-05T12:33:03.468Z
9586090 9586090 20260327035116_YDYRS NL000N 2026-03-28T12:02:09.019Z 2026-04-05T12:33:00.541Z
9586055 9586055 20260327034349_hKpyo NL000N 2026-03-28T12:02:04.082Z 2026-04-05T12:32:58.612Z
9586041 9586041 20260327034038_WgN2N NL000N 2026-03-28T12:02:02.288Z 2026-04-05T12:32:57.977Z
9585804 9585804 20260327023911_fmOGK NL000N 2026-03-28T12:01:24.027Z 2026-04-05T12:32:46.558Z
9585735 9585735 20260327021758_IMZG3 NL000N 2026-03-28T12:01:09.805Z 2026-04-05T12:32:36.811Z
9585561 9585561 20260327013741_6lR3j NL000N 2026-03-28T12:00:39.482Z 2026-04-05T12:32:27.442Z
9585430 9585430 20260327005659_X23S7 NL000N 2026-03-28T12:00:19.905Z 2026-04-05T12:32:20.936Z
9585421 9585421 20260327005601_knKzP NL000N 2026-03-28T12:00:17.082Z 2026-04-05T12:32:20.503Z
9585394 9585394 20260327004703_j2nJ2 NL000N 2026-03-28T12:00:12.342Z 2026-04-05T12:32:19.214Z
9584906 9584906 20260325223638_ornQ2 NL000N 2026-03-27T12:16:20.569Z 2026-04-03T12:39:43.753Z
9581971 9581971 20260326041711_842oy NL000N 2026-03-27T12:04:17.214Z 2026-04-04T12:39:33.162Z
9581720 9581720 20260326035045_9yGef NL000N 2026-03-27T12:03:45.014Z 2026-04-04T12:39:16.679Z
9581182 9581182 20260326023323_8U3nu NL000N 2026-03-27T12:02:18.695Z 2026-04-04T12:38:44.875Z
9581110 9581110 20260326022602_yc1cr NL000N 2026-03-27T12:02:10.296Z 2026-04-04T12:38:43.120Z
9579380 9579380 20260324193243_w9JFi NL000N 2026-03-26T12:13:31.070Z 2026-04-02T12:37:07.144Z
9577035 9577035 20260325034355_3g9w9 NL000N 2026-03-26T12:03:57.187Z 2026-04-03T12:36:30.286Z
9570670 9570670 20260322222738_W2y1Z NL000N 2026-03-24T12:23:37.289Z 2026-03-30T12:30:47.497Z
9570544 9570544 20260322215957_ksIjS NL000N 2026-03-24T12:23:26.650Z 2026-03-30T12:30:45.204Z
9570472 9570472 20260322213644_7L7Qd NL000N 2026-03-24T12:23:20.214Z 2026-03-30T12:30:43.751Z
9561825 9561825 20260323004820_FPTOV NL000N 2026-03-24T12:01:24.164Z 2026-03-31T12:25:54.387Z
9561818 9561818 20260323004819_Mw2w6 NL000N 2026-03-24T12:01:23.660Z 2026-03-31T12:25:54.290Z
9561279 9561279 20260321231513_lJg00 NL000N 2026-03-23T12:12:15.255Z 2026-03-29T12:21:06.054Z
9560579 9560579 20260321214324_9VOkg NL000N 2026-03-23T12:11:54.258Z 2026-03-29T12:21:01.554Z
9559653 9559653 20260321190009_jKzQm NL000N 2026-03-23T12:11:24.961Z 2026-03-29T12:20:42.356Z
9554968 9554968 20260322034914_PZMPf NL000N 2026-03-23T12:02:59.605Z 2026-03-30T12:28:12.444Z
9554894 9554894 20260322034115_SxLTZ NL000N 2026-03-23T12:02:55.291Z 2026-03-30T12:28:11.037Z
9554734 9554734 20260322033229_HP5Fm NL000N 2026-03-23T12:02:48.483Z 2026-03-30T12:28:08.111Z
9552710 9552710 20260322003312_B2mGR NL000N 2026-03-23T12:00:44.848Z 2026-03-30T12:27:28.712Z
9552035 9552035 20260320224041_waCoV NL000N 2026-03-22T12:27:23.572Z 2026-03-28T12:37:05.710Z
9551563 9551563 20260320201954_tnU2z NL000N 2026-03-22T12:26:48.035Z 2026-03-28T12:36:58.100Z
9541345 9541345 20260319201844_eBros NL000N 2026-03-21T12:28:50.692Z 2026-03-27T12:42:36.664Z
9541164 9541164 20260319194650_BEa5n NL000N 2026-03-21T12:28:40.557Z 2026-03-27T12:42:34.766Z
9541128 9541128 20260319193504_uztRY NL000N 2026-03-21T12:28:37.970Z 2026-03-27T12:42:34.332Z
9533266 9533266 20260320022046_mfSMr NL000N 2026-03-21T12:04:58.635Z 2026-03-28T12:33:51.223Z
9532544 9532544 20260320010629_XxqYn NL000N 2026-03-21T12:03:02.115Z 2026-03-28T12:33:33.791Z
9532351 9532351 20260320004811_U6TNB NL000N 2026-03-21T12:02:26.973Z 2026-03-28T12:33:28.118Z
9530698 9530698 20260318212539_ks2oe NL000N 2026-03-20T12:24:36.155Z 2026-03-26T12:39:14.847Z
9521731 9521731 20260319044027_OerF6 NL000N 2026-03-20T12:08:28.846Z 2026-03-27T12:41:09.914Z
9521549 9521549 20260319042623_4LUCb NL000N 2026-03-20T12:08:12.972Z 2026-03-27T12:40:55.746Z
9521296 9521296 20260319040321_XOVNn NL000N 2026-03-20T12:07:49.528Z 2026-03-27T12:40:53.646Z
9520743 9520743 20260319033431_21lAt NL000N 2026-03-20T12:06:54.554Z 2026-03-27T12:40:46.889Z
9519757 9519757 20260319023352_RNyFN NL000N 2026-03-20T12:05:02.770Z 2026-03-27T12:40:35.203Z
9519620 9519620 20260319022313_eWEwA NL000N 2026-03-20T12:04:45.393Z 2026-03-27T12:40:33.407Z
9517618 9517618 20260318234751_uPRgc NL000N 2026-03-20T12:00:52.931Z 2026-03-27T12:40:01.703Z
9516328 9516328 20260317203448_9UJCd NL000N 2026-03-19T12:26:02.067Z 2026-03-25T12:42:54.200Z
9516288 9516288 20260317202417_dJ6Gl NL000N 2026-03-19T12:25:53.365Z 2026-03-25T12:42:53.117Z
9516259 9516259 20260317202105_YICJF NL000N 2026-03-19T12:25:50.525Z 2026-03-25T12:42:52.348Z
9516024 9516024 20260317194357_cEaov NL000N 2026-03-19T12:25:31.826Z 2026-03-25T12:42:46.166Z
9515906 9515906 20260317191937_YltR2 NL000N 2026-03-19T12:25:15.162Z 2026-03-25T12:42:41.620Z
9515838 9515838 20260317190036_vda2c NL000N 2026-03-19T12:25:02.740Z 2026-03-25T12:42:40.025Z
9511411 9511411 20260318035129_c2OtZ NL000N 2026-03-19T12:10:07.134Z 2026-03-26T12:37:36.633Z
9511288 9511288 20260318034407_Ijg8l NL000N 2026-03-19T12:09:51.643Z 2026-03-26T12:37:33.745Z
9510791 9510791 20260318031610_5mIix NL000N 2026-03-19T12:08:41.339Z 2026-03-26T12:37:16.711Z
9509462 9509462 20260318014937_Z4tG3 NL000N 2026-03-19T12:05:21.331Z 2026-03-26T12:37:05.510Z
9509455 9509455 20260318014936_V8cAk NL000N 2026-03-19T12:05:20.639Z 2026-03-26T12:37:05.507Z
9509351 9509351 20260318014440_GpoRf NL000N 2026-03-19T12:05:10.998Z 2026-03-26T12:37:05.108Z
9508819 9508819 20260318011145_rODP2 NL000N 2026-03-19T12:03:51.590Z 2026-03-26T12:37:01.121Z
9508609 9508609 20260318010501_Riwwk NL000N 2026-03-19T12:03:29.753Z 2026-03-26T12:36:59.770Z
9508234 9508234 20260318003509_yp9cE NL000N 2026-03-19T12:02:41.564Z 2026-03-26T12:36:57.165Z
9507774 9507774 20260317234224_iRRL7 NL000N 2026-03-19T12:01:14.010Z 2026-03-26T12:36:53.344Z
9494994 9494994 20260316034918_j3hsE NL000N 2026-03-17T12:05:45.636Z 2026-03-24T12:40:52.377Z
9493048 9493048 20260314223707_Rp7ta NL000N 2026-03-16T12:29:23.921Z 2026-03-22T12:42:56.574Z
9492900 9492900 20260314221224_WOIDK NL000N 2026-03-16T12:29:09.382Z 2026-03-22T12:42:55.662Z
9485850 9485850 20260315040344_7bbzy NL000N 2026-03-16T12:07:50.507Z 2026-03-23T12:21:54.312Z
9485774 9485774 20260315035217_zXluK NL000N 2026-03-16T12:07:36.124Z 2026-03-23T12:21:53.850Z
9485478 9485478 20260315031050_3Siws NL000N 2026-03-16T12:06:33.138Z 2026-03-23T12:21:52.395Z
9485382 9485382 20260315025749_AIXBI NL000N 2026-03-16T12:06:14.490Z 2026-03-23T12:21:51.646Z
9485368 9485368 20260315025709_8R993 NL000N 2026-03-16T12:06:10.468Z 2026-03-23T12:21:51.475Z
9485314 9485314 20260315025024_qVuIX NL000N 2026-03-16T12:06:01.287Z 2026-03-23T12:21:50.920Z
9485202 9485202 20260315023945_3toji NL000N 2026-03-16T12:05:36.340Z 2026-03-23T12:21:50.437Z
9485167 9485167 20260315023555_rut5z NL000N 2026-03-16T12:05:29.965Z 2026-03-23T12:21:50.269Z
9485134 9485134 20260315023407_eP7vK NL000N 2026-03-16T12:05:24.940Z 2026-03-23T12:21:50.163Z
9485074 9485074 20260315022213_4c24w NL000N 2026-03-16T12:05:10.625Z 2026-03-23T12:21:49.881Z
9484859 9484859 20260315015119_WWC22 NL000N 2026-03-16T12:04:24.480Z 2026-03-23T12:21:48.714Z
9484853 9484853 20260315014943_9rEoL NL000N 2026-03-16T12:04:22.552Z 2026-03-23T12:21:48.684Z
9484800 9484800 20260315014240_1yYRu NL000N 2026-03-16T12:04:10.935Z 2026-03-23T12:21:48.432Z
9484699 9484699 20260315013102_ZFi90 NL000N 2026-03-16T12:03:49.036Z 2026-03-23T12:21:47.990Z
9467460 9467460 20260311214825_hNlJk NL000N 2026-03-13T12:19:16.417Z 2026-03-19T12:45:52.481Z
9467354 9467354 20260311212852_lpafA NL000N 2026-03-13T12:19:06.951Z 2026-03-19T12:45:51.745Z
9467302 9467302 20260311211507_I5ws1 NL000N 2026-03-13T12:19:02.112Z 2026-03-19T12:45:51.418Z
9467139 9467139 20260311202033_SM3H6 NL000N 2026-03-13T12:18:30.648Z 2026-03-19T12:45:49.035Z

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