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

6,588 rows where station_code = "NL0001" 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
8687247 8687247 20251204061222_CemXn NL0001 2025-12-05T14:14:29.935Z 2025-12-05T14:14:35.665Z
8664095 8664095 20251130231621_j3xwo NL0001 2025-12-02T14:20:04.438Z 2025-12-05T14:34:51.930Z
8663875 8663875 20251130222159_3wOAA NL0001 2025-12-02T14:19:29.174Z 2025-12-05T14:34:35.072Z
8663863 8663863 20251130222056_c86jz NL0001 2025-12-02T14:19:27.366Z 2025-12-05T14:34:34.668Z
8663630 8663630 20251130211212_wX3Qy NL0001 2025-12-02T14:18:37.731Z 2025-12-05T14:34:26.375Z
8654543 8654543 20251130031952_9P8FM NL0001 2025-12-01T14:25:34.181Z 2025-12-05T14:44:10.637Z
8652641 8652641 20251130012556_5PbjH NL0001 2025-12-01T14:21:54.642Z 2025-12-05T14:42:49.265Z
8651452 8651452 20251129234420_nE85N NL0001 2025-12-01T14:19:08.918Z 2025-12-05T14:41:58.272Z
8651191 8651191 20251129230314_ViI2q NL0001 2025-12-01T14:18:20.209Z 2025-12-05T14:41:51.469Z
8651040 8651040 20251129222831_VEotI NL0001 2025-12-01T14:17:53.122Z 2025-12-05T14:41:35.150Z
8646000 8646000 20251129004624_t0GRy NL0001 2025-11-30T14:25:03.000Z 2025-12-05T14:51:30.762Z
8645914 8645914 20251129002653_D3wax NL0001 2025-11-30T14:24:54.368Z 2025-12-05T14:51:28.180Z
8645364 8645364 20251128212925_iDkLg NL0001 2025-11-30T14:23:36.849Z 2025-12-05T14:50:37.531Z
8623008 8623008 20251126222736_aMz3Y NL0001 2025-11-28T14:20:28.535Z 2025-12-05T15:03:25.080Z
8622887 8622887 20251126220002_BGvQA NL0001 2025-11-28T14:20:15.979Z 2025-12-05T15:03:17.567Z
8615432 8615432 20251126050318_hE9IB NL0001 2025-11-27T14:29:32.066Z 2025-12-04T15:11:28.826Z
8615366 8615366 20251126045846_NYw4T NL0001 2025-11-27T14:29:28.945Z 2025-12-04T15:11:28.069Z
8614668 8614668 20251126042311_feIbJ NL0001 2025-11-27T14:28:26.615Z 2025-12-04T15:10:57.615Z
8614587 8614587 20251126041910_fAnsq NL0001 2025-11-27T14:28:03.841Z 2025-12-04T15:10:53.044Z
8614527 8614527 20251126041632_sO72R NL0001 2025-11-27T14:27:58.130Z 2025-12-04T15:10:48.030Z
8614049 8614049 20251126034913_FHGYv NL0001 2025-11-27T14:27:08.245Z 2025-12-04T15:10:12.273Z
8613114 8613114 20251126030236_0mCG2 NL0001 2025-11-27T14:25:24.398Z 2025-12-04T15:09:37.329Z
8612161 8612161 20251126022006_59HBU NL0001 2025-11-27T14:23:34.177Z 2025-12-04T15:09:28.029Z
8612068 8612068 20251126021556_bIbhS NL0001 2025-11-27T14:23:28.137Z 2025-12-04T15:09:27.236Z
8611849 8611849 20251126020219_kVm5O NL0001 2025-11-27T14:22:58.513Z 2025-12-04T15:09:24.781Z
8611790 8611790 20251126020018_asavM NL0001 2025-11-27T14:22:52.769Z 2025-12-04T15:09:24.192Z
8611560 8611560 20251126015118_HgLuk NL0001 2025-11-27T14:22:19.328Z 2025-12-04T15:09:22.547Z
8609593 8609593 20251125234848_FpFPg NL0001 2025-11-27T14:18:27.877Z 2025-12-04T15:07:55.473Z
8608346 8608346 20251125220852_EgQvO NL0001 2025-11-27T14:15:43.281Z 2025-12-04T15:07:43.821Z
8608322 8608322 20251125220717_13dtH NL0001 2025-11-27T14:15:41.459Z 2025-12-04T15:07:43.561Z
8607812 8607812 20251125212456_lRCCV NL0001 2025-11-27T14:14:33.463Z 2025-12-04T15:07:32.198Z
8606179 8606179 20251125181026_A0HU3 NL0001 2025-11-27T14:09:17.061Z 2025-12-04T15:06:29.941Z
8602478 8602478 20251125045818_gCRsi NL0001 2025-11-26T14:26:02.854Z 2025-12-02T15:09:31.149Z
8602305 8602305 20251125044648_pu0fR NL0001 2025-11-26T14:25:31.155Z 2025-12-02T15:09:30.354Z
8601239 8601239 20251125034111_JfKIM NL0001 2025-11-26T14:23:49.754Z 2025-12-02T15:09:06.098Z
8600150 8600150 20251125024551_AR1Jv NL0001 2025-11-26T14:22:04.949Z 2025-12-02T15:08:34.938Z
8599805 8599805 20251125022421_BHykE NL0001 2025-11-26T14:21:29.867Z 2025-12-02T15:08:32.158Z
8599497 8599497 20251125020833_XNvjI NL0001 2025-11-26T14:21:10.876Z 2025-12-02T15:08:27.058Z
8599465 8599465 20251125020651_O82Vy NL0001 2025-11-26T14:20:57.249Z 2025-12-02T15:08:24.486Z
8599150 8599150 20251125014936_pdJyY NL0001 2025-11-26T14:20:35.759Z 2025-12-02T15:08:20.429Z
8598636 8598636 20251125011214_HyzRp NL0001 2025-11-26T14:19:22.940Z 2025-12-02T15:08:01.497Z
8598631 8598631 20251125011101_3Fw9j NL0001 2025-11-26T14:19:22.139Z 2025-12-02T15:08:01.444Z
8598439 8598439 20251125005720_qkn9O NL0001 2025-11-26T14:19:06.029Z 2025-12-02T15:07:54.518Z
8591643 8591643 20251124043949_8JWuz NL0001 2025-11-25T14:24:41.926Z 2025-12-02T15:12:59.778Z
8590807 8590807 20251124031259_sbbbD NL0001 2025-11-25T14:22:50.481Z 2025-12-02T15:12:55.551Z
8590685 8590685 20251124030321_bpPzk NL0001 2025-11-25T14:22:22.701Z 2025-12-02T15:12:54.201Z
8590224 8590224 20251124022933_FhpG3 NL0001 2025-11-25T14:21:33.472Z 2025-12-02T15:12:43.400Z
8590154 8590154 20251124022651_NK2sa NL0001 2025-11-25T14:21:29.767Z 2025-12-02T15:12:43.015Z
8589871 8589871 20251124020044_O0ouz NL0001 2025-11-25T14:20:50.846Z 2025-12-02T15:12:37.788Z
8589835 8589835 20251124015842_rV11p NL0001 2025-11-25T14:20:47.898Z 2025-12-02T15:12:37.233Z
8589808 8589808 20251124015527_WTxXX NL0001 2025-11-25T14:20:44.979Z 2025-12-02T15:12:36.069Z
8589785 8589785 20251124015255_cYymP NL0001 2025-11-25T14:20:42.482Z 2025-12-02T15:12:35.743Z
8589434 8589434 20251124013403_NNPN3 NL0001 2025-11-25T14:20:04.483Z 2025-12-02T15:12:30.732Z
8588729 8588729 20251124002750_W2RJO NL0001 2025-11-25T14:18:12.431Z 2025-12-02T15:11:51.103Z
8588692 8588692 20251124002120_RH9qL NL0001 2025-11-25T14:18:08.415Z 2025-12-02T15:11:50.025Z
8588504 8588504 20251124000258_VeMXs NL0001 2025-11-25T14:17:40.090Z 2025-12-02T15:11:47.751Z
8588245 8588245 20251123233437_Sabo1 NL0001 2025-11-25T14:17:07.451Z 2025-12-02T15:11:38.516Z
8587603 8587603 20251123222231_uNrat NL0001 2025-11-25T14:15:38.307Z 2025-12-02T15:11:17.763Z
8587504 8587504 20251123221033_UeGME NL0001 2025-11-25T14:15:24.521Z 2025-12-02T15:11:16.461Z
8586682 8586682 20251123203026_YPEKX NL0001 2025-11-25T14:13:35.890Z 2025-12-02T15:10:58.768Z
8574066 8574066 20251122050454_mw3G2 NL0001 2025-11-23T14:42:14.400Z 2025-11-30T15:06:56.557Z
8573829 8573829 20251122041849_bHIc3 NL0001 2025-11-23T14:42:02.305Z 2025-11-30T15:06:41.459Z
8573699 8573699 20251122035544_9XRd2 NL0001 2025-11-23T14:41:55.172Z 2025-11-30T15:06:35.885Z
8573608 8573608 20251122034230_5tLv6 NL0001 2025-11-23T14:41:25.865Z 2025-11-30T15:06:32.658Z
8573445 8573445 20251122031212_WX3Zg NL0001 2025-11-23T14:41:11.706Z 2025-11-30T15:06:24.533Z
8573405 8573405 20251122030754_IZUxO NL0001 2025-11-23T14:41:10.436Z 2025-11-30T15:06:22.500Z
8573202 8573202 20251122024309_5x5BN NL0001 2025-11-23T14:41:00.165Z 2025-11-30T15:06:12.444Z
8573107 8573107 20251122022938_SGnXi NL0001 2025-11-23T14:40:44.397Z 2025-11-23T14:40:44.397Z
8573083 8573083 20251122022648_VhtPX NL0001 2025-11-23T14:40:43.295Z 2025-11-30T15:06:09.484Z
8573070 8573070 20251122022508_zRcrg NL0001 2025-11-23T14:40:42.575Z 2025-11-30T15:06:09.068Z
8572732 8572732 20251122013415_EzynN NL0001 2025-11-23T14:39:40.444Z 2025-11-30T15:05:57.148Z
8571154 8571154 20251121192329_3vtdk NL0001 2025-11-23T14:36:00.498Z 2025-11-30T15:04:30.055Z
8570993 8570993 20251121182503_SYbNw NL0001 2025-11-23T14:35:51.645Z 2025-11-30T15:04:18.308Z
8569047 8569047 20251121054341_7qKQx NL0001 2025-11-23T14:31:52.278Z 2025-11-29T14:54:47.720Z
8568827 8568827 20251121053809_A4HK5 NL0001 2025-11-23T14:31:43.231Z 2025-11-29T14:54:47.502Z
8568793 8568793 20251121053726_lMT2O NL0001 2025-11-23T14:31:27.588Z 2025-11-29T14:54:47.410Z
8567197 8567197 20251122043510_VYwvR NL0001 2025-11-23T14:19:07.808Z 2025-11-30T15:06:48.830Z
8567184 8567184 20251122043205_saBfX NL0001 2025-11-23T14:19:05.623Z 2025-11-30T15:06:48.018Z
8567097 8567097 20251122040649_D3Oc3 NL0001 2025-11-23T14:18:49.959Z 2025-11-30T15:06:37.372Z
8567052 8567052 20251122035051_ImqEA NL0001 2025-11-23T14:18:37.293Z 2025-11-30T15:06:35.053Z
8566954 8566954 20251122031527_Fk7Ut NL0001 2025-11-23T14:18:13.328Z 2025-11-30T15:06:27.802Z
8566931 8566931 20251122030135_sRLG8 NL0001 2025-11-23T14:18:07.877Z 2025-11-30T15:06:19.544Z
8566918 8566918 20251122025908_IN22L NL0001 2025-11-23T14:18:05.213Z 2025-11-30T15:06:16.480Z
8566865 8566865 20251122024404_U1XSB NL0001 2025-11-23T14:17:47.936Z 2025-11-30T15:06:12.616Z
8566827 8566827 20251122023406_02m8a NL0001 2025-11-23T14:17:39.564Z 2025-11-30T15:06:10.749Z
8566679 8566679 20251122014708_ehW7u NL0001 2025-11-23T14:17:02.632Z 2025-11-30T15:06:03.383Z
8566653 8566653 20251122014047_r9YjB NL0001 2025-11-23T14:16:58.496Z 2025-11-30T15:05:58.292Z
8566143 8566143 20251121230736_wdA4M NL0001 2025-11-23T14:15:09.854Z 2025-11-30T15:05:29.947Z
8565856 8565856 20251121214355_K16IZ NL0001 2025-11-23T14:14:23.396Z 2025-11-30T15:05:11.893Z
8565565 8565565 20251121204826_EbHVE NL0001 2025-11-23T14:13:41.302Z 2025-11-30T15:05:05.926Z
8565275 8565275 20251121201138_LOWvM NL0001 2025-11-23T14:12:53.853Z 2025-11-30T15:04:53.519Z
8565170 8565170 20251121195920_t9dYF NL0001 2025-11-23T14:12:41.372Z 2025-11-30T15:04:43.886Z
8565034 8565034 20251121193917_Ukrs9 NL0001 2025-11-23T14:12:18.628Z 2025-11-30T15:04:39.349Z
8564563 8564563 20251121184004_Uy47D NL0001 2025-11-23T14:11:06.746Z 2025-11-30T15:04:24.210Z
8559439 8559439 20251121041055_YIqn3 NL0001 2025-11-22T14:41:55.744Z 2025-11-29T14:54:38.558Z
8555523 8555523 20251121011019_trs9D NL0001 2025-11-22T14:38:46.369Z 2025-11-29T14:54:30.656Z
8550596 8550596 20251120235444_wti5T NL0001 2025-11-22T14:21:16.412Z 2025-11-29T14:54:27.212Z
8528595 8528595 20251119043732_qm00O NL0001 2025-11-20T14:43:23.263Z 2025-11-27T15:13:07.754Z
8528565 8528565 20251119043445_zAQsn NL0001 2025-11-20T14:43:17.874Z 2025-11-27T15:13:07.269Z
8528500 8528500 20251119042510_IYGNl NL0001 2025-11-20T14:43:05.845Z 2025-11-27T15:13:06.361Z

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