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,857 rows where station_code = "FR0014" 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
9273430 9273430 20260128060940_5F5t1 FR0014 2026-01-29T14:29:45.925Z 2026-01-29T14:30:25.810Z
9273398 9273398 20260128060512_Yrqxv FR0014 2026-01-29T14:29:40.019Z 2026-01-29T14:30:25.802Z
9273138 9273138 20260128045049_PicPL FR0014 2026-01-29T14:28:49.726Z 2026-01-29T14:30:25.757Z
9273072 9273072 20260128043132_j1fOF FR0014 2026-01-29T14:28:41.912Z 2026-01-29T14:30:25.744Z
9260212 9260212 20260125030954_8TZlf FR0014 2026-01-26T14:20:48.832Z 2026-01-29T14:43:59.963Z
9260101 9260101 20260125023625_d2DPE FR0014 2026-01-26T14:20:17.122Z 2026-01-29T14:43:48.598Z
9260056 9260056 20260125021755_8nnqf FR0014 2026-01-26T14:19:58.891Z 2026-01-29T14:43:43.885Z
9260000 9260000 20260125015342_tEOxb FR0014 2026-01-26T14:19:43.879Z 2026-01-29T14:43:40.296Z
9256100 9256100 20260124055601_lGChb FR0014 2026-01-25T14:15:51.082Z 2026-01-29T14:48:23.270Z
9255871 9255871 20260124050949_JCmw1 FR0014 2026-01-25T14:15:00.567Z 2026-01-29T14:48:02.251Z
9255776 9255776 20260124045430_x9Zib FR0014 2026-01-25T14:14:39.943Z 2026-01-29T14:47:56.763Z
9255770 9255770 20260124045244_f8udp FR0014 2026-01-25T14:14:38.752Z 2026-01-29T14:47:56.521Z
9255700 9255700 20260124043320_sFE5y FR0014 2026-01-25T14:14:25.853Z 2026-01-29T14:47:52.542Z
9255569 9255569 20260124041317_raMd3 FR0014 2026-01-25T14:13:59.420Z 2026-01-29T14:47:40.618Z
9255511 9255511 20260124035549_MRivo FR0014 2026-01-25T14:13:43.495Z 2026-01-29T14:47:35.172Z
9255484 9255484 20260124034852_Y5uB4 FR0014 2026-01-25T14:13:36.201Z 2026-01-29T14:47:33.748Z
9255463 9255463 20260124034219_D9oK4 FR0014 2026-01-25T14:13:32.139Z 2026-01-29T14:47:32.214Z
9255434 9255434 20260124033110_6pu3V FR0014 2026-01-25T14:13:26.260Z 2026-01-29T14:47:30.529Z
9255408 9255408 20260124032233_ekYJ2 FR0014 2026-01-25T14:13:15.985Z 2026-01-29T14:47:28.843Z
9255307 9255307 20260124024327_xWwPT FR0014 2026-01-25T14:12:47.993Z 2026-01-29T14:47:22.745Z
9255253 9255253 20260124021103_SjgEq FR0014 2026-01-25T14:12:32.627Z 2026-01-29T14:47:12.339Z
9255202 9255202 20260124013638_7uEhs FR0014 2026-01-25T14:12:16.859Z 2026-01-29T14:47:07.965Z
9255116 9255116 20260124010039_FHh3q FR0014 2026-01-25T14:11:56.740Z 2026-01-29T14:47:03.195Z
9251760 9251760 20260122222905_p2sSL FR0014 2026-01-24T14:13:08.708Z 2026-01-29T14:52:08.342Z
9251376 9251376 20260122195218_gEJAM FR0014 2026-01-24T14:11:29.327Z 2026-01-29T14:51:37.686Z
9237374 9237374 20260120050718_AQl8m FR0014 2026-01-21T14:26:20.474Z 2026-01-28T15:01:22.462Z
9235470 9235470 20260120011801_1PhN2 FR0014 2026-01-21T14:19:01.907Z 2026-01-28T14:58:56.873Z
9235343 9235343 20260120005829_rORa5 FR0014 2026-01-21T14:18:38.364Z 2026-01-28T14:58:50.082Z
9213438 9213438 20260116033205_qHwsB FR0014 2026-01-17T14:16:54.127Z 2026-01-24T15:12:14.198Z
9213180 9213180 20260116023045_bnz00 FR0014 2026-01-17T14:15:49.078Z 2026-01-24T15:11:48.111Z
9180951 9180951 20260110233305_TYspX FR0014 2026-01-12T14:09:02.600Z 2026-01-19T15:16:40.048Z
9180691 9180691 20260110213320_YpF6z FR0014 2026-01-12T14:08:01.204Z 2026-01-19T15:16:27.819Z
9179738 9179738 20260110173655_om2cx FR0014 2026-01-12T14:04:06.717Z 2026-01-19T15:15:14.048Z
9176354 9176354 20260110051848_sCiaD FR0014 2026-01-11T14:08:47.413Z 2026-01-18T15:08:35.584Z
9159409 9159409 20260106023330_K8TKF FR0014 2026-01-07T14:09:15.181Z 2026-01-13T15:08:24.477Z
9157575 9157575 20260105175758_dCYnc FR0014 2026-01-07T14:02:41.806Z 2026-01-13T15:06:18.243Z
9155429 9155429 20260104055556_xuz87 FR0014 2026-01-06T14:37:22.434Z 2026-01-12T15:11:00.766Z
9154877 9154877 20260104052119_QnX2S FR0014 2026-01-06T14:36:18.797Z 2026-01-12T15:10:25.013Z
9150814 9150814 20260105033617_hWzmx FR0014 2026-01-06T14:11:31.675Z 2026-01-13T15:14:02.537Z
9150599 9150599 20260105025709_6Y5L4 FR0014 2026-01-06T14:10:41.650Z 2026-01-13T15:13:43.688Z
9149842 9149842 20260104235241_GBGrn FR0014 2026-01-06T14:07:28.011Z 2026-01-13T15:12:42.217Z
9144592 9144592 20260104025011_8GYWc FR0014 2026-01-05T14:19:25.514Z 2026-01-05T14:30:33.960Z
9143561 9143561 20260104021551_dBWhg FR0014 2026-01-05T14:17:51.097Z 2026-01-12T15:06:27.117Z
9143439 9143439 20260104020922_I8bVH FR0014 2026-01-05T14:17:30.836Z 2026-01-12T15:06:23.236Z
9143437 9143437 20260104020921_0k83X FR0014 2026-01-05T14:17:30.709Z 2026-01-12T15:06:23.165Z
9140069 9140069 20260103235705_ocbcd FR0014 2026-01-05T14:12:26.030Z 2026-01-12T15:03:57.341Z
9139792 9139792 20260103234619_WlZ5v FR0014 2026-01-05T14:12:12.389Z 2026-01-12T15:03:51.131Z
9135571 9135571 20260103190151_Hks3C FR0014 2026-01-05T14:04:48.727Z 2026-01-12T15:00:40.926Z
9135122 9135122 20260103184112_Dbz1b FR0014 2026-01-05T14:03:44.509Z 2026-01-12T15:00:10.518Z
9130166 9130166 20260103022330_EFIvp FR0014 2026-01-04T14:08:43.954Z 2026-01-10T14:58:48.505Z
9130110 9130110 20260103020906_aWo8v FR0014 2026-01-04T14:08:26.113Z 2026-01-10T14:58:43.913Z
9127715 9127715 20260102045731_b3b2c FR0014 2026-01-03T14:11:34.806Z 2026-01-09T14:50:09.596Z
9126937 9126937 20260102014315_U3vq0 FR0014 2026-01-03T14:07:33.208Z 2026-01-09T14:49:19.217Z
9126805 9126805 20260102005256_78xvV FR0014 2026-01-03T14:06:49.465Z 2026-01-09T14:49:04.493Z
9126608 9126608 20260101231941_Y5hK4 FR0014 2026-01-03T14:05:37.502Z 2026-01-09T14:48:53.772Z
9121752 9121752 20260101022245_sEzPG FR0014 2026-01-02T14:09:12.733Z 2026-01-09T14:52:33.045Z
9119849 9119849 20251230191756_HK3GA FR0014 2026-01-01T14:57:26.098Z 2026-01-07T15:13:23.392Z
9119612 9119612 20251230182722_2RdZj FR0014 2026-01-01T14:56:40.198Z 2026-01-07T15:12:56.441Z
9119506 9119506 20251230181129_COMjJ FR0014 2026-01-01T14:56:20.242Z 2026-01-07T15:12:48.952Z
9116503 9116503 20251231061612_c60kX FR0014 2026-01-01T14:28:13.920Z 2026-01-08T15:11:50.764Z
9116338 9116338 20251231060408_nEXlt FR0014 2026-01-01T14:27:48.102Z 2026-01-08T15:11:43.694Z
9116165 9116165 20251231055347_zkk1B FR0014 2026-01-01T14:27:25.038Z 2026-01-08T15:11:36.777Z
9115687 9115687 20251231052239_xU4Sc FR0014 2026-01-01T14:26:10.473Z 2026-01-08T15:11:08.089Z
9115459 9115459 20251231050807_yDrXb FR0014 2026-01-01T14:25:25.455Z 2026-01-08T15:10:48.437Z
9114649 9114649 20251231042343_9SNaI FR0014 2026-01-01T14:23:09.907Z 2026-01-08T15:09:58.367Z
9114464 9114464 20251231041814_pk4zS FR0014 2026-01-01T14:22:35.831Z 2026-01-08T15:09:49.237Z
9114310 9114310 20251231041120_bvEcM FR0014 2026-01-01T14:22:08.015Z 2026-01-08T15:09:42.184Z
9113933 9113933 20251231035559_T3omN FR0014 2026-01-01T14:20:54.981Z 2026-01-08T15:09:16.723Z
9113643 9113643 20251231034035_NS9i6 FR0014 2026-01-01T14:19:51.625Z 2026-01-08T15:08:55.193Z
9112489 9112489 20251231023031_wkflX FR0014 2026-01-01T14:15:17.904Z 2026-01-08T15:07:46.548Z
9111724 9111724 20251231013856_BQeIX FR0014 2026-01-01T14:12:35.551Z 2026-01-08T15:06:54.231Z
9111680 9111680 20251231013446_E4VbK FR0014 2026-01-01T14:12:28.254Z 2026-01-08T15:06:50.791Z
9111354 9111354 20251231010502_vUN5z FR0014 2026-01-01T14:11:14.590Z 2026-01-08T15:06:36.449Z
9111232 9111232 20251231005144_BZtsd FR0014 2026-01-01T14:10:35.338Z 2026-01-08T15:06:23.788Z
9111140 9111140 20251231004200_7EOgl FR0014 2026-01-01T14:10:16.260Z 2026-01-08T15:06:17.755Z
9110749 9110749 20251230235551_MUYxG FR0014 2026-01-01T14:08:38.021Z 2026-01-08T15:05:48.855Z
9110576 9110576 20251230233222_I3223 FR0014 2026-01-01T14:07:56.468Z 2026-01-08T15:05:40.186Z
9110561 9110561 20251230233012_o2XNb FR0014 2026-01-01T14:07:50.455Z 2026-01-08T15:05:31.568Z
9110073 9110073 20251230221235_4O04A FR0014 2026-01-01T14:05:41.853Z 2026-01-08T15:04:57.638Z
9109900 9109900 20251230211720_vVoaD FR0014 2026-01-01T14:04:30.107Z 2026-01-08T15:04:44.329Z
9106913 9106913 20251229031905_G3gsO FR0014 2025-12-31T14:35:18.980Z 2026-01-06T15:17:13.457Z
9084346 9084346 20251228013447_Olyyl FR0014 2025-12-30T14:35:30.745Z 2026-01-05T15:08:39.941Z
9084295 9084295 20251228013018_35aUz FR0014 2025-12-30T14:35:15.934Z 2026-01-05T15:08:38.258Z
9083648 9083648 20251228001640_O9spW FR0014 2025-12-30T14:33:15.184Z 2026-01-05T15:08:01.733Z
9083376 9083376 20251227234743_RzEH0 FR0014 2025-12-30T14:32:28.693Z 2026-01-05T15:07:46.371Z
9083172 9083172 20251227230853_H3i3t FR0014 2025-12-30T14:31:51.775Z 2026-01-05T15:07:39.651Z
9081138 9081138 20251229055216_dLBEC FR0014 2025-12-30T14:23:56.029Z 2026-01-06T15:18:52.521Z
9080873 9080873 20251229051451_93R6K FR0014 2025-12-30T14:22:54.074Z 2026-01-06T15:18:33.675Z
9080564 9080564 20251229045025_zAWiY FR0014 2025-12-30T14:21:39.995Z 2026-01-06T15:18:21.144Z
9080401 9080401 20251229043612_POsjR FR0014 2025-12-30T14:21:05.446Z 2026-01-06T15:18:15.374Z
9080303 9080303 20251229043007_sBYoP FR0014 2025-12-30T14:20:43.936Z 2026-01-06T15:18:00.321Z
9079920 9079920 20251229035826_QwUpa FR0014 2025-12-30T14:18:58.353Z 2026-01-06T15:17:44.668Z
9079447 9079447 20251229031905_tFE2Q FR0014 2025-12-30T14:17:09.549Z 2026-01-06T15:17:13.511Z
9079190 9079190 20251229030026_CwrKX FR0014 2025-12-30T14:16:06.489Z 2026-01-06T15:17:04.021Z
9078933 9078933 20251229024046_YrETk FR0014 2025-12-30T14:15:01.543Z 2026-01-06T15:16:45.930Z
9078794 9078794 20251229023003_tjUxf FR0014 2025-12-30T14:14:31.050Z 2026-01-06T15:16:41.761Z
9075482 9075482 20251225213758_hVIxE FR0014 2025-12-29T15:02:05.417Z 2026-01-02T15:48:52.482Z
9073427 9073427 20251225174305_SNdqz FR0014 2025-12-29T14:59:17.111Z 2026-01-02T15:47:50.962Z
9071426 9071426 20251226183845_Y3TD6 FR0014 2025-12-29T14:49:29.039Z 2026-01-03T15:42:54.726Z
9071000 9071000 20251226173922_WIR4F FR0014 2025-12-29T14:48:47.509Z 2026-01-03T15:42:22.874Z

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