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,353 rows where station_code = "ES000N" 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
6714719 6714719 20250512025922_hssXb ES000N 2025-05-13T12:05:40.693Z 2025-05-20T12:33:37.193Z
6714633 6714633 20250512021813_W1hYR ES000N 2025-05-13T12:05:24.398Z 2025-05-20T12:33:34.814Z
6713831 6713831 20250511224412_NdEsW ES000N 2025-05-13T12:02:37.707Z 2025-05-20T12:33:17.362Z
6713385 6713385 20250511205417_za5hr ES000N 2025-05-13T12:00:57.513Z 2025-05-20T12:33:09.527Z
6713304 6713304 20250511201645_Y1rhD ES000N 2025-05-13T12:00:37.633Z 2025-05-20T12:33:07.814Z
6605665 6605665 20250429031741_GtsZ2 ES000N 2025-04-30T12:22:02.548Z 2025-05-07T12:35:11.398Z
6031104 6031104 20250130234406_3D8M0 ES000N 2025-02-01T14:23:43.475Z 2025-02-08T15:13:20.404Z
6030468 6030468 20250130205825_dvsj4 ES000N 2025-02-01T14:22:26.043Z 2025-02-08T15:12:40.864Z
6025850 6025850 20250131024958_Prq56 ES000N 2025-02-01T14:03:43.855Z 2025-02-02T14:15:41.017Z
6025465 6025465 20250131012014_JKJk8 ES000N 2025-02-01T14:01:46.665Z 2025-02-02T14:15:11.771Z
6019950 6019950 20250130034344_hEoVq ES000N 2025-01-31T14:04:59.147Z 2025-02-08T15:08:55.327Z
6019052 6019052 20250130022734_DWuFn ES000N 2025-01-31T14:02:56.593Z 2025-02-08T15:08:23.688Z
6018707 6018707 20250130014608_9BiAB ES000N 2025-01-31T14:01:58.115Z 2025-02-08T15:08:09.087Z
6018096 6018096 20250124051534_Qju4b ES000N 2025-01-30T14:29:11.250Z 2025-02-02T14:36:37.498Z
6018094 6018094 20250124044702_0R5o0 ES000N 2025-01-30T14:29:09.282Z 2025-02-02T14:36:36.492Z
5843322 5843322 20241220053408_1F3L2 ES000N 2024-12-24T14:23:57.159Z 2024-12-28T14:40:12.725Z
5843309 5843309 20241220053057_FCnrk ES000N 2024-12-24T14:23:55.782Z 2024-12-28T14:40:12.559Z
5843216 5843216 20241220050610_lKzyo ES000N 2024-12-24T14:23:49.137Z 2024-12-28T14:40:09.843Z
5843202 5843202 20241220050350_VxAz3 ES000N 2024-12-24T14:23:48.088Z 2024-12-28T14:40:09.493Z
5842948 5842948 20241220040923_Gfv5U ES000N 2024-12-24T14:23:10.323Z 2024-12-28T14:40:03.957Z
5842781 5842781 20241220034257_Yp7OT ES000N 2024-12-24T14:22:55.514Z 2024-12-28T14:39:58.861Z
5842742 5842742 20241220033214_6g3Cz ES000N 2024-12-24T14:22:51.587Z 2024-12-28T14:39:57.599Z
5842621 5842621 20241220031010_QRy7c ES000N 2024-12-24T14:22:29.122Z 2024-12-28T14:39:55.579Z
5842608 5842608 20241220030705_wyEl5 ES000N 2024-12-24T14:22:24.972Z 2024-12-28T14:39:55.209Z
5842384 5842384 20241220021332_PT3w6 ES000N 2024-12-24T14:21:55.204Z 2024-12-28T14:39:48.368Z
5842177 5842177 20241220012556_22EUb ES000N 2024-12-24T14:21:32.307Z 2024-12-28T14:39:41.431Z
5842149 5842149 20241220011706_xJ8MT ES000N 2024-12-24T14:21:25.289Z 2024-12-28T14:39:41.081Z
5841966 5841966 20241220003419_EOcNm ES000N 2024-12-24T14:21:02.396Z 2024-12-28T14:39:33.943Z
5841857 5841857 20241220000657_E26GG ES000N 2024-12-24T14:20:54.307Z 2024-12-28T14:39:30.658Z
5841827 5841827 20241219235937_MTAGE ES000N 2024-12-24T14:20:52.587Z 2024-12-28T14:39:29.711Z
5841772 5841772 20241219234939_1c4t0 ES000N 2024-12-24T14:20:48.359Z 2024-12-28T14:39:28.115Z
5841700 5841700 20241219233738_o5Li9 ES000N 2024-12-24T14:20:44.376Z 2024-12-28T14:39:26.513Z
5841565 5841565 20241219231352_TU5aI ES000N 2024-12-24T14:20:20.422Z 2024-12-28T14:39:21.025Z
5841434 5841434 20241219225115_RB4Y2 ES000N 2024-12-24T14:20:10.458Z 2024-12-28T14:39:19.035Z
5841368 5841368 20241219223946_xicIX ES000N 2024-12-24T14:20:05.499Z 2024-12-28T14:39:17.821Z
5837490 5837490 20241219203445_PXJLW ES000N 2024-12-23T14:36:07.008Z 2024-12-28T14:39:07.795Z
5758227 5758227 20241205225806_gFIsw ES000N 2024-12-11T14:29:00.762Z 2024-12-14T14:47:41.519Z
5704275 5704275 20241203233309_UEozc ES000N 2024-12-06T14:31:44.413Z 2024-12-12T14:38:36.980Z
5704273 5704273 20241203233249_JexYK ES000N 2024-12-06T14:31:44.267Z 2024-12-12T14:38:36.945Z
3483664 3483664 20231127225343_JdGzo ES000N 2024-01-06T00:04:47.226Z 2024-01-06T00:04:47.226Z
3483659 3483659 20231127224329_sUFWT ES000N 2024-01-06T00:04:47.225Z 2024-01-06T00:04:47.225Z
3483606 3483606 20231127211135_8bYDJ ES000N 2024-01-06T00:04:47.219Z 2024-01-06T00:04:47.219Z
3483503 3483503 20231127185441_2C6w1 ES000N 2024-01-06T00:04:46.035Z 2024-01-06T00:04:46.035Z
3481965 3481965 20231126054515_y9N9e ES000N 2024-01-06T00:04:44.711Z 2024-01-06T00:04:44.711Z
3481559 3481559 20231125215336_W7MzT ES000N 2024-01-06T00:04:44.656Z 2024-01-06T00:04:44.656Z
3478534 3478534 20231125051151_MYS0m ES000N 2024-01-06T00:04:43.222Z 2024-01-06T00:04:43.222Z
3478453 3478453 20231125050902_UuKKA ES000N 2024-01-06T00:04:43.218Z 2024-01-06T00:04:43.218Z
3477455 3477455 20231125042645_WNG7i ES000N 2024-01-06T00:04:43.161Z 2024-01-06T00:04:43.161Z
3476071 3476071 20231125025725_WG3MP ES000N 2024-01-06T00:04:43.066Z 2024-01-06T00:04:43.066Z
3472375 3472375 20231124193117_NGIDh ES000N 2024-01-06T00:04:41.546Z 2024-01-06T00:04:41.546Z
3468200 3468200 20231124042916_McTlu ES000N 2024-01-06T00:04:41.137Z 2024-01-06T00:04:41.137Z
3467723 3467723 20231124033411_k2XpV ES000N 2024-01-06T00:04:41.095Z 2024-01-06T00:04:41.095Z
3467636 3467636 20231124032432_Wsqcj ES000N 2024-01-06T00:04:41.089Z 2024-01-06T00:04:41.089Z
3467510 3467510 20231124030833_2DEh1 ES000N 2024-01-06T00:04:41.079Z 2024-01-06T00:04:41.079Z
3467292 3467292 20231124023803_M77Y2 ES000N 2024-01-06T00:04:41.060Z 2024-01-06T00:04:41.060Z
3467259 3467259 20231124023338_24k6E ES000N 2024-01-06T00:04:41.056Z 2024-01-06T00:04:41.056Z
3467230 3467230 20231124022500_Q2iWo ES000N 2024-01-06T00:04:41.053Z 2024-01-06T00:04:41.053Z
3467190 3467190 20231124021807_nabDI ES000N 2024-01-06T00:04:41.048Z 2024-01-06T00:04:41.048Z
3466364 3466364 20231123215121_o61Us ES000N 2024-01-06T00:04:40.961Z 2024-01-06T00:04:40.961Z
3465877 3465877 20231123202616_piV67 ES000N 2024-01-06T00:04:39.668Z 2024-01-06T00:04:39.668Z
3465858 3465858 20231123202511_tWdfx ES000N 2024-01-06T00:04:39.667Z 2024-01-06T00:04:39.667Z
3464711 3464711 20231123175843_gGUT8 ES000N 2024-01-06T00:04:39.567Z 2024-01-06T00:04:39.567Z
3462448 3462448 20231123054523_3aAmH ES000N 2024-01-06T00:04:39.313Z 2024-01-06T00:04:39.313Z
3462376 3462376 20231123054056_6ksdL ES000N 2024-01-06T00:04:39.307Z 2024-01-06T00:04:39.307Z
3462241 3462241 20231123052431_eVs99 ES000N 2024-01-06T00:04:39.294Z 2024-01-06T00:04:39.294Z
3462177 3462177 20231123051936_CUfS0 ES000N 2024-01-06T00:04:39.288Z 2024-01-06T00:04:39.288Z
3461831 3461831 20231123044855_fAaEz ES000N 2024-01-06T00:04:39.252Z 2024-01-06T00:04:39.252Z
3461742 3461742 20231123043812_Db7h6 ES000N 2024-01-06T00:04:39.243Z 2024-01-06T00:04:39.243Z
3461737 3461737 20231123043759_pQBHg ES000N 2024-01-06T00:04:39.242Z 2024-01-06T00:04:39.242Z
3461490 3461490 20231123040049_O6dBu ES000N 2024-01-06T00:04:39.213Z 2024-01-06T00:04:39.213Z
3461469 3461469 20231123035607_jUAI4 ES000N 2024-01-06T00:04:39.210Z 2024-01-06T00:04:39.210Z
3461228 3461228 20231123031759_qRgEl ES000N 2024-01-06T00:04:39.180Z 2024-01-06T00:04:39.180Z
3461196 3461196 20231123031212_CNUj0 ES000N 2024-01-06T00:04:39.176Z 2024-01-06T00:04:39.176Z
3461137 3461137 20231123030555_lKo8M ES000N 2024-01-06T00:04:39.170Z 2024-01-06T00:04:39.170Z
3460973 3460973 20231123024238_KNbaw ES000N 2024-01-06T00:04:39.152Z 2024-01-06T00:04:39.152Z
3460976 3460976 20231123024309_y0Yal ES000N 2024-01-06T00:04:39.152Z 2024-01-06T00:04:39.152Z
3460947 3460947 20231123023857_ZG3uW ES000N 2024-01-06T00:04:39.149Z 2024-01-06T00:04:39.149Z
3460909 3460909 20231123023227_102KA ES000N 2024-01-06T00:04:39.144Z 2024-01-06T00:04:39.144Z
3460838 3460838 20231123022502_WK3NP ES000N 2024-01-06T00:04:39.137Z 2024-01-06T00:04:39.137Z
3460826 3460826 20231123022139_AGW2H ES000N 2024-01-06T00:04:39.135Z 2024-01-06T00:04:39.135Z
3460715 3460715 20231123020336_D99cW ES000N 2024-01-06T00:04:39.122Z 2024-01-06T00:04:39.122Z
3460696 3460696 20231123020110_jUgSH ES000N 2024-01-06T00:04:39.120Z 2024-01-06T00:04:39.120Z
3460688 3460688 20231123020030_WpKMj ES000N 2024-01-06T00:04:39.119Z 2024-01-06T00:04:39.119Z
3460550 3460550 20231123013931_cCkV2 ES000N 2024-01-06T00:04:39.103Z 2024-01-06T00:04:39.103Z
3460522 3460522 20231123013714_pPwe8 ES000N 2024-01-06T00:04:39.100Z 2024-01-06T00:04:39.100Z
3460507 3460507 20231123013136_quaqK ES000N 2024-01-06T00:04:39.098Z 2024-01-06T00:04:39.098Z
3460476 3460476 20231123012712_bTQ9X ES000N 2024-01-06T00:04:39.095Z 2024-01-06T00:04:39.095Z
3460244 3460244 20231123004744_O923A ES000N 2024-01-06T00:04:39.069Z 2024-01-06T00:04:39.069Z
3459995 3459995 20231122223532_CNU33 ES000N 2024-01-06T00:04:39.037Z 2024-01-06T00:04:39.037Z
3459917 3459917 20231122214516_wJqzs ES000N 2024-01-06T00:04:37.779Z 2024-01-06T00:04:37.779Z
3459887 3459887 20231122212126_meR9f ES000N 2024-01-06T00:04:37.776Z 2024-01-06T00:04:37.776Z
3459796 3459796 20231122200144_kw2a1 ES000N 2024-01-06T00:04:37.762Z 2024-01-06T00:04:37.762Z
3459746 3459746 20231122194103_Cfv2D ES000N 2024-01-06T00:04:37.754Z 2024-01-06T00:04:37.754Z
3456827 3456827 20231122060039_oiA8b ES000N 2024-01-06T00:04:37.433Z 2024-01-06T00:04:37.433Z
3456809 3456809 20231122055934_ejRlG ES000N 2024-01-06T00:04:37.432Z 2024-01-06T00:04:37.432Z
3456691 3456691 20231122052057_Rr2Jd ES000N 2024-01-06T00:04:37.415Z 2024-01-06T00:04:37.415Z
3456636 3456636 20231122050739_qFAOf ES000N 2024-01-06T00:04:37.407Z 2024-01-06T00:04:37.407Z
3456591 3456591 20231122045714_TMazp ES000N 2024-01-06T00:04:37.401Z 2024-01-06T00:04:37.401Z
3456520 3456520 20231122044501_fq9F2 ES000N 2024-01-06T00:04:37.392Z 2024-01-06T00:04:37.392Z
3456446 3456446 20231122042720_Jpapr ES000N 2024-01-06T00:04:37.382Z 2024-01-06T00:04:37.382Z

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