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

7,110 rows where station_code = "FR0013" 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
8687180 8687180 20251204053245_GsKAg FR0013 2025-12-05T14:14:19.432Z 2025-12-05T14:14:35.643Z
8666150 8666150 20251201044236_3Q9SN FR0013 2025-12-02T14:25:29.153Z 2025-12-05T14:36:34.337Z
8665915 8665915 20251201041053_Ntt1Q FR0013 2025-12-02T14:24:55.062Z 2025-12-05T14:36:24.075Z
8665906 8665906 20251201040902_Yus6D FR0013 2025-12-02T14:24:54.243Z 2025-12-05T14:36:23.785Z
8665786 8665786 20251201035749_30PU3 FR0013 2025-12-02T14:24:28.962Z 2025-12-05T14:36:19.272Z
8665610 8665610 20251201034328_wgxRn FR0013 2025-12-02T14:24:04.911Z 2025-12-05T14:36:13.600Z
8665597 8665597 20251201034119_JFVGB FR0013 2025-12-02T14:24:00.031Z 2025-12-05T14:36:13.183Z
8665558 8665558 20251201033433_VONtY FR0013 2025-12-02T14:23:53.851Z 2025-12-05T14:36:11.624Z
8665547 8665547 20251201033423_5mw32 FR0013 2025-12-02T14:23:52.278Z 2025-12-05T14:36:11.283Z
8665526 8665526 20251201033109_HG3Kg FR0013 2025-12-02T14:23:49.507Z 2025-12-05T14:36:10.562Z
8665384 8665384 20251201031414_ki4pK FR0013 2025-12-02T14:23:36.287Z 2025-12-05T14:35:54.335Z
8665350 8665350 20251201030949_Yz8ig FR0013 2025-12-02T14:23:33.227Z 2025-12-05T14:35:52.975Z
8665291 8665291 20251201030218_6WGbt FR0013 2025-12-02T14:23:17.887Z 2025-12-05T14:35:51.034Z
8665253 8665253 20251201025216_mWMn7 FR0013 2025-12-02T14:23:12.622Z 2025-12-05T14:35:47.470Z
8665190 8665190 20251201024521_Nlosc FR0013 2025-12-02T14:23:06.119Z 2025-12-05T14:35:45.293Z
8665033 8665033 20251201021928_UDPJu FR0013 2025-12-02T14:22:38.746Z 2025-12-05T14:35:40.005Z
8664788 8664788 20251201013748_vasAD FR0013 2025-12-02T14:22:04.433Z 2025-12-05T14:35:17.831Z
8664725 8664725 20251201013118_y2zoJ FR0013 2025-12-02T14:21:58.885Z 2025-12-05T14:35:16.175Z
8664371 8664371 20251201001022_dRH6H FR0013 2025-12-02T14:20:48.664Z 2025-12-05T14:35:02.263Z
8664319 8664319 20251201000309_Z5xGq FR0013 2025-12-02T14:20:42.243Z 2025-12-05T14:35:00.497Z
8664276 8664276 20251130235606_o3ERG FR0013 2025-12-02T14:20:37.952Z 2025-12-05T14:34:59.286Z
8664153 8664153 20251130232608_u9hg2 FR0013 2025-12-02T14:20:11.944Z 2025-12-05T14:34:54.578Z
8663902 8663902 20251130223117_8w25X FR0013 2025-12-02T14:19:33.257Z 2025-12-05T14:34:36.152Z
8663813 8663813 20251130220903_E3V1J FR0013 2025-12-02T14:19:14.176Z 2025-12-05T14:34:33.218Z
8663801 8663801 20251130220710_BKnzL FR0013 2025-12-02T14:19:11.451Z 2025-12-05T14:34:32.653Z
8663776 8663776 20251130215927_vUDpk FR0013 2025-12-02T14:19:05.719Z 2025-12-05T14:34:31.618Z
8663717 8663717 20251130213111_WqABu FR0013 2025-12-02T14:18:56.629Z 2025-12-05T14:34:29.440Z
8663715 8663715 20251130212923_ZadJV FR0013 2025-12-02T14:18:56.219Z 2025-12-05T14:34:29.287Z
8663692 8663692 20251130212547_kBxkI FR0013 2025-12-02T14:18:53.151Z 2025-12-05T14:34:28.471Z
8663432 8663432 20251130204451_NTIS2 FR0013 2025-12-02T14:18:16.832Z 2025-12-05T14:34:07.314Z
8663391 8663391 20251130204124_0eHRl FR0013 2025-12-02T14:18:05.894Z 2025-12-05T14:34:06.330Z
8662446 8662446 20251130185048_k30gz FR0013 2025-12-02T14:15:35.006Z 2025-12-05T14:33:24.438Z
8662131 8662131 20251130180255_qcHqX FR0013 2025-12-02T14:14:27.323Z 2025-12-05T14:33:08.427Z
8662104 8662104 20251130175733_2D0Xs FR0013 2025-12-02T14:14:19.550Z 2025-12-05T14:32:59.825Z
8661875 8661875 20251130172643_5ao50 FR0013 2025-12-02T14:13:29.108Z 2025-12-05T14:32:39.245Z
8661802 8661802 20251130171255_qFW9z FR0013 2025-12-02T14:13:05.102Z 2025-12-05T14:32:35.949Z
8625576 8625576 20251126030839_Ut4oo FR0013 2025-11-28T14:35:09.751Z 2025-12-04T15:09:38.210Z
8624374 8624374 20251127043040_83mCR FR0013 2025-11-28T14:24:33.623Z 2025-12-05T15:05:00.239Z
8623079 8623079 20251126224609_ldyzx FR0013 2025-11-28T14:20:50.314Z 2025-12-05T15:03:27.668Z
8622883 8622883 20251126215715_esjiq FR0013 2025-11-28T14:20:15.284Z 2025-12-05T15:03:17.367Z
8622590 8622590 20251126200934_RIWjz FR0013 2025-11-28T14:19:26.475Z 2025-12-05T15:03:03.785Z
8622560 8622560 20251126195557_UD32i FR0013 2025-11-28T14:19:22.415Z 2025-12-05T15:03:03.473Z
8622310 8622310 20251126184330_7NREl FR0013 2025-11-28T14:18:22.135Z 2025-12-05T15:02:55.320Z
8622308 8622308 20251126184306_0zvT4 FR0013 2025-11-28T14:18:21.762Z 2025-12-05T15:02:55.281Z
8622194 8622194 20251126181057_LaSiz FR0013 2025-11-28T14:18:06.451Z 2025-12-05T15:02:53.430Z
8622187 8622187 20251126180844_39NU1 FR0013 2025-11-28T14:18:05.121Z 2025-12-05T15:02:53.320Z
8622113 8622113 20251126175301_9bOLI FR0013 2025-11-28T14:17:44.059Z 2025-12-05T15:02:52.435Z
8622082 8622082 20251126174556_Lhbbv FR0013 2025-11-28T14:17:38.467Z 2025-12-05T15:02:51.746Z
8622021 8622021 20251126173151_e1Wst FR0013 2025-11-28T14:17:26.309Z 2025-12-05T15:02:50.721Z
8621926 8621926 20251126170857_hXruT FR0013 2025-11-28T14:17:03.247Z 2025-12-05T15:02:49.509Z
8616082 8616082 20251126053734_2SJoa FR0013 2025-11-27T14:30:29.191Z 2025-12-04T15:11:35.424Z
8616066 8616066 20251126053503_YM9C2 FR0013 2025-11-27T14:30:27.424Z 2025-12-04T15:11:35.072Z
8614038 8614038 20251126034814_xYFJD FR0013 2025-11-27T14:27:07.669Z 2025-12-04T15:10:11.838Z
8613996 8613996 20251126034644_OlOxU FR0013 2025-11-27T14:27:04.221Z 2025-12-04T15:10:07.025Z
8613955 8613955 20251126034301_paf3z FR0013 2025-11-27T14:27:00.169Z 2025-12-04T15:09:56.937Z
8613953 8613953 20251126034233_1buhH FR0013 2025-11-27T14:26:59.804Z 2025-12-04T15:09:56.886Z
8613745 8613745 20251126033251_eDKXS FR0013 2025-11-27T14:26:29.034Z 2025-11-27T14:32:45.869Z
8613528 8613528 20251126032019_vpYyq FR0013 2025-11-27T14:26:10.572Z 2025-12-04T15:09:41.504Z
8613462 8613462 20251126031849_VqMnr FR0013 2025-11-27T14:26:06.575Z 2025-12-04T15:09:40.818Z
8612581 8612581 20251126023849_Hcny5 FR0013 2025-11-27T14:24:23.200Z 2025-12-04T15:09:32.127Z
8608715 8608715 20251125223758_v3nx7 FR0013 2025-11-27T14:16:34.750Z 2025-12-04T15:07:47.955Z
8608646 8608646 20251125223230_iMIuQ FR0013 2025-11-27T14:16:25.886Z 2025-12-04T15:07:47.409Z
8607503 8607503 20251125205825_PeYN2 FR0013 2025-11-27T14:13:52.843Z 2025-12-04T15:07:03.151Z
8607357 8607357 20251125204344_QS1hV FR0013 2025-11-27T14:13:27.611Z 2025-12-04T15:07:01.130Z
8606088 8606088 20251125175122_xh3eh FR0013 2025-11-27T14:08:54.843Z 2025-12-04T15:06:04.826Z
8577965 8577965 20251122191825_3Id5q FR0013 2025-11-24T14:10:18.827Z 2025-12-01T15:19:04.880Z
8577832 8577832 20251122185957_QTpLp FR0013 2025-11-24T14:09:50.728Z 2025-12-01T15:19:00.085Z
8577824 8577824 20251122185927_0i2WL FR0013 2025-11-24T14:09:49.328Z 2025-12-01T15:18:59.483Z
8577559 8577559 20251122183106_lsV38 FR0013 2025-11-24T14:09:02.938Z 2025-12-01T15:18:54.008Z
8577557 8577557 20251122182920_4dtEm FR0013 2025-11-24T14:09:02.600Z 2025-12-01T15:18:53.945Z
8577482 8577482 20251122181644_2QjMQ FR0013 2025-11-24T14:08:46.191Z 2025-12-01T15:18:51.897Z
8574270 8574270 20251122054016_zchse FR0013 2025-11-23T14:43:03.281Z 2025-11-30T15:07:04.073Z
8574241 8574241 20251122053525_XbrMS FR0013 2025-11-23T14:43:00.928Z 2025-11-30T15:07:03.572Z
8574069 8574069 20251122050457_5jxGg FR0013 2025-11-23T14:42:14.727Z 2025-11-30T15:06:56.623Z
8574043 8574043 20251122050148_qZyIv FR0013 2025-11-23T14:42:13.260Z 2025-11-30T15:06:56.203Z
8574031 8574031 20251122050052_3yUjr FR0013 2025-11-23T14:42:12.531Z 2025-11-30T15:06:55.832Z
8573942 8573942 20251122044551_t33A0 FR0013 2025-11-23T14:42:08.066Z 2025-11-30T15:06:51.313Z
8573922 8573922 20251122043927_4twuO FR0013 2025-11-23T14:42:07.076Z 2025-11-30T15:06:49.808Z
8573916 8573916 20251122043754_1fq2C FR0013 2025-11-23T14:42:06.785Z 2025-11-30T15:06:49.457Z
8573905 8573905 20251122043626_m2EDw FR0013 2025-11-23T14:42:06.294Z 2025-11-30T15:06:49.003Z
8573824 8573824 20251122041817_idC6v FR0013 2025-11-23T14:42:02.064Z 2025-11-30T15:06:41.385Z
8573715 8573715 20251122035808_m115U FR0013 2025-11-23T14:41:55.804Z 2025-11-30T15:06:36.217Z
8573536 8573536 20251122032712_QxC5J FR0013 2025-11-23T14:41:15.935Z 2025-11-30T15:06:30.160Z
8573343 8573343 20251122025808_ZOAjr FR0013 2025-11-23T14:41:06.786Z 2025-11-30T15:06:16.334Z
8573310 8573310 20251122025532_333E2 FR0013 2025-11-23T14:41:05.787Z 2025-11-30T15:06:16.045Z
8573247 8573247 20251122024742_hEMlP FR0013 2025-11-23T14:41:02.178Z 2025-11-30T15:06:12.916Z
8573028 8573028 20251122021831_1aMJb FR0013 2025-11-23T14:40:40.353Z 2025-11-30T15:06:08.709Z
8573014 8573014 20251122021649_BAunQ FR0013 2025-11-23T14:40:39.864Z 2025-11-30T15:06:08.467Z
8573011 8573011 20251122021645_gg9hw FR0013 2025-11-23T14:40:39.748Z 2025-11-30T15:06:08.461Z
8572969 8572969 20251122021136_wmwdE FR0013 2025-11-23T14:40:27.870Z 2025-11-30T15:06:07.461Z
8572955 8572955 20251122020901_4tTQv FR0013 2025-11-23T14:40:20.278Z 2025-11-30T15:06:07.152Z
8572917 8572917 20251122020007_gKShP FR0013 2025-11-23T14:40:06.757Z 2025-11-30T15:06:06.168Z
8572903 8572903 20251122015645_qGZm3 FR0013 2025-11-23T14:40:02.501Z 2025-11-30T15:06:05.718Z
8572832 8572832 20251122014720_aYeGx FR0013 2025-11-23T14:39:46.013Z 2025-11-30T15:06:04.300Z
8572803 8572803 20251122014340_ta3Bo FR0013 2025-11-23T14:39:44.844Z 2025-11-30T15:06:01.148Z
8572797 8572797 20251122014311_N5wAz FR0013 2025-11-23T14:39:44.572Z 2025-11-30T15:06:01.088Z
8572682 8572682 20251122012852_8q2lv FR0013 2025-11-23T14:39:38.240Z 2025-11-30T15:05:55.106Z
8572668 8572668 20251122012458_9lTwT FR0013 2025-11-23T14:39:37.437Z 2025-11-30T15:05:54.861Z
8572650 8572650 20251122012327_N23Yu FR0013 2025-11-23T14:39:36.669Z 2025-11-30T15:05:54.615Z
8572508 8572508 20251122010244_oEG9T FR0013 2025-11-23T14:39:29.479Z 2025-11-30T15:05:51.331Z

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