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

2,025 rows where station_code = "NL0017" 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
8666818 8666818 20251201035145_J4RVT NL0017 2025-12-02T14:28:02.532Z 2025-12-05T14:36:17.235Z
8666540 8666540 20251201061634_bkhX1 NL0017 2025-12-02T14:26:25.231Z 2025-12-02T14:26:25.231Z
8666513 8666513 20251201060029_eBnQw NL0017 2025-12-02T14:26:21.877Z 2025-12-05T14:37:00.810Z
8666485 8666485 20251201054806_SvuLr NL0017 2025-12-02T14:26:18.808Z 2025-12-05T14:36:59.689Z
8666339 8666339 20251201051713_EYUAk NL0017 2025-12-02T14:25:48.731Z 2025-12-05T14:36:54.613Z
8666320 8666320 20251201051118_WqMHv NL0017 2025-12-02T14:25:46.237Z 2025-12-05T14:36:54.140Z
8666077 8666077 20251201043026_PwirV NL0017 2025-12-02T14:25:11.805Z 2025-12-05T14:36:31.491Z
8665961 8665961 20251201041351_vPr25 NL0017 2025-12-02T14:24:59.230Z 2025-12-05T14:36:25.135Z
8665491 8665491 20251201032526_APX1a NL0017 2025-12-02T14:23:46.480Z 2025-12-05T14:36:09.190Z
8665336 8665336 20251201030824_P42by NL0017 2025-12-02T14:23:32.469Z 2025-12-05T14:35:52.605Z
8665303 8665303 20251201030327_CAg26 NL0017 2025-12-02T14:23:18.866Z 2025-12-05T14:35:51.330Z
8665270 8665270 20251201025720_bhC0f NL0017 2025-12-02T14:23:15.700Z 2025-12-05T14:35:48.078Z
8665163 8665163 20251201023918_g5m9A NL0017 2025-12-02T14:23:02.735Z 2025-12-05T14:35:44.250Z
8665101 8665101 20251201022813_6lfr4 NL0017 2025-12-02T14:22:55.489Z 2025-12-05T14:35:42.380Z
8665076 8665076 20251201022556_9t60Z NL0017 2025-12-02T14:22:47.974Z 2025-12-05T14:35:41.809Z
8664871 8664871 20251201015431_q2M02 NL0017 2025-12-02T14:22:15.033Z 2025-12-05T14:35:34.303Z
8664810 8664810 20251201014259_TlG5x NL0017 2025-12-02T14:22:07.362Z 2025-12-05T14:35:18.873Z
8664609 8664609 20251201011047_B7b6B NL0017 2025-12-02T14:21:37.218Z 2025-12-05T14:35:10.133Z
8664360 8664360 20251201000912_vihjo NL0017 2025-12-02T14:20:47.566Z 2025-12-05T14:35:01.924Z
8664342 8664342 20251201000600_Lyp1T NL0017 2025-12-02T14:20:44.685Z 2025-12-05T14:35:01.069Z
8664265 8664265 20251130235326_MZ7ei NL0017 2025-12-02T14:20:36.481Z 2025-12-05T14:34:58.898Z
8664191 8664191 20251130233806_Ood6c NL0017 2025-12-02T14:20:17.908Z 2025-12-05T14:34:56.312Z
8664177 8664177 20251130233137_HeYXf NL0017 2025-12-02T14:20:15.290Z 2025-12-05T14:34:55.707Z
8664097 8664097 20251130231700_147Eb NL0017 2025-12-02T14:20:04.803Z 2025-12-05T14:34:52.202Z
8663982 8663982 20251130225316_7RxMw NL0017 2025-12-02T14:19:44.802Z 2025-12-05T14:34:40.822Z
8654263 8654263 20251130030622_70qGU NL0017 2025-12-01T14:25:03.286Z 2025-12-05T14:43:52.271Z
8645558 8645558 20251128224537_spfUL NL0017 2025-11-30T14:24:01.940Z 2025-12-05T14:50:50.563Z
8645512 8645512 20251128223240_iaaq7 NL0017 2025-11-30T14:23:53.617Z 2025-12-05T14:50:45.304Z
8645435 8645435 20251128221006_hB3g3 NL0017 2025-11-30T14:23:43.676Z 2025-12-05T14:50:38.845Z
8623228 8623228 20251126232412_yoOQi NL0017 2025-11-28T14:21:08.144Z 2025-12-05T15:03:38.893Z
8622900 8622900 20251126220214_iMHvE NL0017 2025-11-28T14:20:16.874Z 2025-12-05T15:03:19.158Z
8621954 8621954 20251126171710_zkAKt NL0017 2025-11-28T14:17:08.244Z 2025-12-05T15:02:49.916Z
8615994 8615994 20251126053122_OuMKq NL0017 2025-11-27T14:30:20.361Z 2025-12-04T15:11:34.340Z
8615295 8615295 20251126045425_lYLYg NL0017 2025-11-27T14:29:25.187Z 2025-12-04T15:11:27.506Z
8606521 8606521 20251125190939_RB1Fi NL0017 2025-11-27T14:10:27.671Z 2025-12-04T15:06:46.542Z
8591950 8591950 20251124052052_CA82X NL0017 2025-11-25T14:25:26.148Z 2025-12-02T15:13:01.190Z
8591689 8591689 20251124044515_3zZpA NL0017 2025-11-25T14:24:45.011Z 2025-12-02T15:12:59.935Z
8591111 8591111 20251124034659_HkgD2 NL0017 2025-11-25T14:23:37.217Z 2025-12-02T15:12:57.108Z
8591101 8591101 20251124034635_AiV1o NL0017 2025-11-25T14:23:36.489Z 2025-12-02T15:12:57.095Z
8586589 8586589 20251123201400_kCqto NL0017 2025-11-25T14:13:25.810Z 2025-12-02T15:10:56.061Z
8579488 8579488 20251122235431_ieP2S NL0017 2025-11-24T14:14:27.133Z 2025-12-01T15:20:29.173Z
8579481 8579481 20251122235313_p84HE NL0017 2025-11-24T14:14:26.397Z 2025-12-01T15:20:28.992Z
8579250 8579250 20251122225454_njvni NL0017 2025-11-24T14:13:51.773Z 2025-12-01T15:20:11.440Z
8579082 8579082 20251122221929_aQh9B NL0017 2025-11-24T14:13:28.764Z 2025-12-01T15:20:01.776Z
8578963 8578963 20251122215812_OHNaI NL0017 2025-11-24T14:13:11.657Z 2025-12-01T15:19:57.333Z
8578756 8578756 20251122212331_kKPxl NL0017 2025-11-24T14:12:37.738Z 2025-12-01T15:19:51.565Z
8578370 8578370 20251122203037_orEun NL0017 2025-11-24T14:11:37.258Z 2025-12-01T15:19:33.450Z
8577900 8577900 20251122190917_TnsVc NL0017 2025-11-24T14:10:08.060Z 2025-12-01T15:19:01.888Z
8577797 8577797 20251122185529_ccibK NL0017 2025-11-24T14:09:40.991Z 2025-12-01T15:18:57.756Z
8577682 8577682 20251122184611_QCEeT NL0017 2025-11-24T14:09:25.745Z 2025-12-01T15:18:56.365Z
8577478 8577478 20251122181532_55JB3 NL0017 2025-11-24T14:08:44.998Z 2025-12-01T15:18:51.397Z
8577372 8577372 20251122175954_cZ9DV NL0017 2025-11-24T14:08:29.308Z 2025-12-01T15:18:48.445Z
8577068 8577068 20251122171512_EBmmF NL0017 2025-11-24T14:07:27.120Z 2025-12-01T15:18:42.939Z
8576991 8576991 20251122165833_tqTiX NL0017 2025-11-24T14:07:16.906Z 2025-12-01T15:18:42.289Z
8576979 8576979 20251122165554_eMEZD NL0017 2025-11-24T14:07:14.675Z 2025-12-01T15:18:42.065Z
8576923 8576923 20251122164253_PwmTd NL0017 2025-11-24T14:07:01.490Z 2025-12-01T15:18:41.442Z
8576913 8576913 20251122163928_brygO NL0017 2025-11-24T14:06:58.614Z 2025-12-01T15:18:41.256Z
8576911 8576911 20251122163826_2RdzH NL0017 2025-11-24T14:06:58.174Z 2025-12-01T15:18:41.198Z
8574085 8574085 20251122050638_o1KDg NL0017 2025-11-23T14:42:15.423Z 2025-11-30T15:06:58.081Z
8573898 8573898 20251122043346_2LGHR NL0017 2025-11-23T14:42:05.726Z 2025-11-30T15:06:48.563Z
8569532 8569532 20251121060108_i7SR1 NL0017 2025-11-23T14:32:18.990Z 2025-11-29T14:54:48.457Z
8568456 8568456 20251121051952_9Lo6v NL0017 2025-11-23T14:31:08.905Z 2025-11-29T14:54:46.820Z
8567344 8567344 20251122054542_7l3zc NL0017 2025-11-23T14:19:33.588Z 2025-11-30T15:07:04.740Z
8567093 8567093 20251122040451_XBnvh NL0017 2025-11-23T14:18:43.187Z 2025-11-30T15:06:36.789Z
8567039 8567039 20251122034821_GE42h NL0017 2025-11-23T14:18:34.883Z 2025-11-30T15:06:34.057Z
8567027 8567027 20251122034402_qDalj NL0017 2025-11-23T14:18:33.340Z 2025-11-30T15:06:32.854Z
8566940 8566940 20251122030929_deeiz NL0017 2025-11-23T14:18:09.764Z 2025-11-30T15:06:23.017Z
8560484 8560484 20251121045755_ZE4DH NL0017 2025-11-22T14:42:53.344Z 2025-11-29T14:54:45.843Z
8560250 8560250 20251121044748_iTqfj NL0017 2025-11-22T14:42:40.407Z 2025-11-29T14:54:45.361Z
8560211 8560211 20251121044610_q2s2p NL0017 2025-11-22T14:42:35.652Z 2025-11-29T14:54:45.236Z
8560099 8560099 20251121044013_gttAd NL0017 2025-11-22T14:42:14.923Z 2025-11-29T14:54:44.991Z
8536898 8536898 20251120053037_C32AM NL0017 2025-11-21T14:19:16.294Z 2025-11-28T14:58:05.547Z
8536241 8536241 20251120035426_Jdndo NL0017 2025-11-21T14:17:59.517Z 2025-11-28T14:57:28.829Z
8536174 8536174 20251120034529_IJRrn NL0017 2025-11-21T14:17:44.755Z 2025-11-28T14:57:26.175Z
8536152 8536152 20251120034259_KtVSz NL0017 2025-11-21T14:17:40.243Z 2025-11-28T14:57:26.021Z
8535989 8535989 20251120032107_hdLyz NL0017 2025-11-21T14:17:23.083Z 2025-11-28T14:57:16.903Z
8535906 8535906 20251120031206_PuNrX NL0017 2025-11-21T14:17:07.803Z 2025-11-28T14:57:13.013Z
8535792 8535792 20251120030136_X4nNJ NL0017 2025-11-21T14:16:59.642Z 2025-11-28T14:57:02.347Z
8535788 8535788 20251120030123_iPjM6 NL0017 2025-11-21T14:16:58.877Z 2025-11-28T14:57:01.699Z
8535698 8535698 20251120024033_ZlZK2 NL0017 2025-11-21T14:16:38.771Z 2025-11-28T14:56:57.886Z
8535633 8535633 20251120023313_goj75 NL0017 2025-11-21T14:16:33.422Z 2025-11-28T14:56:52.284Z
8535626 8535626 20251120023151_FNEnt NL0017 2025-11-21T14:16:32.948Z 2025-11-28T14:56:52.173Z
8535181 8535181 20251120012904_kA1rS NL0017 2025-11-21T14:15:26.692Z 2025-11-28T14:56:20.643Z
8535160 8535160 20251120012444_iYVCG NL0017 2025-11-21T14:15:23.695Z 2025-11-28T14:56:19.057Z
8534991 8534991 20251120005559_wjqBG NL0017 2025-11-21T14:15:04.886Z 2025-11-28T14:56:11.027Z
8534938 8534938 20251120004646_cg6zv NL0017 2025-11-21T14:14:54.287Z 2025-11-28T14:56:08.670Z
8534851 8534851 20251120003132_VKtVk NL0017 2025-11-21T14:14:43.416Z 2025-11-28T14:56:03.257Z
8534112 8534112 20251119221042_20s79 NL0017 2025-11-21T14:13:07.406Z 2025-11-28T14:55:36.821Z
8533940 8533940 20251119211004_mGMPX NL0017 2025-11-21T14:12:38.051Z 2025-11-28T14:55:25.193Z
8507097 8507097 20251117224436_dg7oB NL0017 2025-11-19T14:14:22.791Z 2025-11-26T15:07:44.900Z
8506850 8506850 20251117222124_Sx1Tk NL0017 2025-11-19T14:13:47.162Z 2025-11-26T15:07:43.626Z
8506779 8506779 20251117221047_3Rd84 NL0017 2025-11-19T14:13:38.328Z 2025-11-26T15:07:43.331Z
8506224 8506224 20251117211256_pCYqU NL0017 2025-11-19T14:12:27.031Z 2025-11-26T15:07:41.068Z
8506085 8506085 20251117210252_bCxnC NL0017 2025-11-19T14:12:02.651Z 2025-11-26T15:07:40.653Z
8506045 8506045 20251117210130_V1dzW NL0017 2025-11-19T14:11:57.912Z 2025-11-26T15:07:40.559Z
8505951 8505951 20251117205638_gThu5 NL0017 2025-11-19T14:11:39.468Z 2025-11-26T15:07:40.287Z
8505625 8505625 20251117202956_fFv7O NL0017 2025-11-19T14:10:56.934Z 2025-11-26T15:07:39.122Z
8505586 8505586 20251117202755_ti137 NL0017 2025-11-19T14:10:52.620Z 2025-11-26T15:07:39.022Z
8505214 8505214 20251117195612_DR3US NL0017 2025-11-19T14:09:42.892Z 2025-11-26T15:07:37.267Z
8504978 8504978 20251117193900_jE744 NL0017 2025-11-19T14:09:10.548Z 2025-11-26T15:07:35.941Z

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