participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
208 rows where station_code = "MY000B" sorted by created_at descending
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 |
---|---|---|---|---|---|
2429942 | 2429942 | 20230429202817_1NlZH | MY000B | 2024-01-05T23:57:19.251Z | 2024-01-05T23:57:19.251Z |
2429920 | 2429920 | 20230429200846_5Z8be | MY000B | 2024-01-05T23:57:19.248Z | 2024-01-05T23:57:19.248Z |
2429703 | 2429703 | 20230429180636_1bgga | MY000B | 2024-01-05T23:57:19.224Z | 2024-01-05T23:57:19.224Z |
2426918 | 2426918 | 20230428151619_lDQ3i | MY000B | 2024-01-05T23:57:17.686Z | 2024-01-05T23:57:17.686Z |
2425519 | 2425519 | 20230427201026_U9pxl | MY000B | 2024-01-05T23:57:16.257Z | 2024-01-05T23:57:16.257Z |
2425490 | 2425490 | 20230427194301_snqRf | MY000B | 2024-01-05T23:57:16.254Z | 2024-01-05T23:57:16.254Z |
2425419 | 2425419 | 20230427190935_yeB3j | MY000B | 2024-01-05T23:57:16.247Z | 2024-01-05T23:57:16.247Z |
2425424 | 2425424 | 20230427191323_fglrX | MY000B | 2024-01-05T23:57:16.247Z | 2024-01-05T23:57:16.247Z |
2425355 | 2425355 | 20230427183309_7HbiF | MY000B | 2024-01-05T23:57:16.241Z | 2024-01-05T23:57:16.241Z |
2424988 | 2424988 | 20230427161709_RG58l | MY000B | 2024-01-05T23:57:16.195Z | 2024-01-05T23:57:16.195Z |
2424684 | 2424684 | 20230427132108_fJkj8 | MY000B | 2024-01-05T23:57:16.157Z | 2024-01-05T23:57:16.157Z |
2422414 | 2422414 | 20230426205014_0P1VA | MY000B | 2024-01-05T23:57:15.900Z | 2024-01-05T23:57:15.900Z |
2419535 | 2419535 | 20230425205537_KO2tM | MY000B | 2024-01-05T23:57:14.366Z | 2024-01-05T23:57:14.366Z |
2419484 | 2419484 | 20230425202841_h332Y | MY000B | 2024-01-05T23:57:14.361Z | 2024-01-05T23:57:14.361Z |
2419445 | 2419445 | 20230425195135_iE759 | MY000B | 2024-01-05T23:57:14.355Z | 2024-01-05T23:57:14.355Z |
2419434 | 2419434 | 20230425193913_Zgr3L | MY000B | 2024-01-05T23:57:14.354Z | 2024-01-05T23:57:14.354Z |
2419438 | 2419438 | 20230425194203_CGrIw | MY000B | 2024-01-05T23:57:14.354Z | 2024-01-05T23:57:14.354Z |
2419425 | 2419425 | 20230425192750_zJoiv | MY000B | 2024-01-05T23:57:14.352Z | 2024-01-05T23:57:14.352Z |
2419411 | 2419411 | 20230425185933_8DOFf | MY000B | 2024-01-05T23:57:13.201Z | 2024-01-05T23:57:13.201Z |
2419347 | 2419347 | 20230425175722_Td0yZ | MY000B | 2024-01-05T23:57:13.192Z | 2024-01-05T23:57:13.192Z |
2419259 | 2419259 | 20230425161148_d13Dh | MY000B | 2024-01-05T23:57:13.180Z | 2024-01-05T23:57:13.180Z |
2416947 | 2416947 | 20230424205545_rkdZF | MY000B | 2024-01-05T23:57:12.952Z | 2024-01-05T23:57:12.952Z |
2416937 | 2416937 | 20230424204218_sFlF9 | MY000B | 2024-01-05T23:57:12.951Z | 2024-01-05T23:57:12.951Z |
2416939 | 2416939 | 20230424204516_dSEmj | MY000B | 2024-01-05T23:57:12.951Z | 2024-01-05T23:57:12.951Z |
2416942 | 2416942 | 20230424204920_LEvXe | MY000B | 2024-01-05T23:57:12.951Z | 2024-01-05T23:57:12.951Z |
2416906 | 2416906 | 20230424201436_GbxVD | MY000B | 2024-01-05T23:57:12.945Z | 2024-01-05T23:57:12.945Z |
2416838 | 2416838 | 20230424185715_t0RVx | MY000B | 2024-01-05T23:57:12.937Z | 2024-01-05T23:57:12.937Z |
2416825 | 2416825 | 20230424183955_U3Evm | MY000B | 2024-01-05T23:57:12.936Z | 2024-01-05T23:57:12.936Z |
2416796 | 2416796 | 20230424182326_G3twe | MY000B | 2024-01-05T23:57:11.802Z | 2024-01-05T23:57:11.802Z |
2416472 | 2416472 | 20230424164208_iGVkk | MY000B | 2024-01-05T23:57:11.761Z | 2024-01-05T23:57:11.761Z |
2416244 | 2416244 | 20230424151539_VF0GH | MY000B | 2024-01-05T23:57:11.731Z | 2024-01-05T23:57:11.731Z |
2416158 | 2416158 | 20230424144356_wA654 | MY000B | 2024-01-05T23:57:11.721Z | 2024-01-05T23:57:11.721Z |
2416035 | 2416035 | 20230424134125_XaDIw | MY000B | 2024-01-05T23:57:11.706Z | 2024-01-05T23:57:11.706Z |
2415899 | 2415899 | 20230424122007_7KDAe | MY000B | 2024-01-05T23:57:11.688Z | 2024-01-05T23:57:11.688Z |
2413968 | 2413968 | 20230423202749_QMJGm | MY000B | 2024-01-05T23:57:11.471Z | 2024-01-05T23:57:11.471Z |
2413953 | 2413953 | 20230423201330_bFsUO | MY000B | 2024-01-05T23:57:11.469Z | 2024-01-05T23:57:11.469Z |
2413958 | 2413958 | 20230423201632_X9nu0 | MY000B | 2024-01-05T23:57:11.469Z | 2024-01-05T23:57:11.469Z |
2413948 | 2413948 | 20230423201100_tvxVw | MY000B | 2024-01-05T23:57:11.468Z | 2024-01-05T23:57:11.468Z |
2413917 | 2413917 | 20230423192307_k3m2P | MY000B | 2024-01-05T23:57:11.464Z | 2024-01-05T23:57:11.464Z |
2413823 | 2413823 | 20230423173856_K8Gk4 | MY000B | 2024-01-05T23:57:10.284Z | 2024-01-05T23:57:10.284Z |
2413754 | 2413754 | 20230423165527_6c69L | MY000B | 2024-01-05T23:57:10.274Z | 2024-01-05T23:57:10.274Z |
2413742 | 2413742 | 20230423164559_En22a | MY000B | 2024-01-05T23:57:10.272Z | 2024-01-05T23:57:10.272Z |
2413670 | 2413670 | 20230423160120_hdaiS | MY000B | 2024-01-05T23:57:10.262Z | 2024-01-05T23:57:10.262Z |
2413659 | 2413659 | 20230423155630_EeiPx | MY000B | 2024-01-05T23:57:10.261Z | 2024-01-05T23:57:10.261Z |
2413653 | 2413653 | 20230423155104_UFuv0 | MY000B | 2024-01-05T23:57:10.260Z | 2024-01-05T23:57:10.260Z |
2413649 | 2413649 | 20230423154550_n5drJ | MY000B | 2024-01-05T23:57:10.259Z | 2024-01-05T23:57:10.259Z |
2413623 | 2413623 | 20230423153017_2YGv4 | MY000B | 2024-01-05T23:57:10.256Z | 2024-01-05T23:57:10.256Z |
2413627 | 2413627 | 20230423153406_AL06x | MY000B | 2024-01-05T23:57:10.256Z | 2024-01-05T23:57:10.256Z |
2413515 | 2413515 | 20230423140858_8RtCf | MY000B | 2024-01-05T23:57:10.243Z | 2024-01-05T23:57:10.243Z |
2409767 | 2409767 | 20230422205503_wqm0p | MY000B | 2024-01-05T23:57:09.781Z | 2024-01-05T23:57:09.781Z |
2409715 | 2409715 | 20230422204648_FClxY | MY000B | 2024-01-05T23:57:09.774Z | 2024-01-05T23:57:09.774Z |
2409707 | 2409707 | 20230422204253_S5PAl | MY000B | 2024-01-05T23:57:09.773Z | 2024-01-05T23:57:09.773Z |
2409693 | 2409693 | 20230422204011_eevpA | MY000B | 2024-01-05T23:57:09.770Z | 2024-01-05T23:57:09.770Z |
2409678 | 2409678 | 20230422203340_eZheB | MY000B | 2024-01-05T23:57:09.768Z | 2024-01-05T23:57:09.768Z |
2409642 | 2409642 | 20230422202538_5Fmbt | MY000B | 2024-01-05T23:57:09.762Z | 2024-01-05T23:57:09.762Z |
2409605 | 2409605 | 20230422201819_ew3xf | MY000B | 2024-01-05T23:57:09.757Z | 2024-01-05T23:57:09.757Z |
2409597 | 2409597 | 20230422201641_GTnUN | MY000B | 2024-01-05T23:57:09.756Z | 2024-01-05T23:57:09.756Z |
2409568 | 2409568 | 20230422200537_z3U3n | MY000B | 2024-01-05T23:57:09.752Z | 2024-01-05T23:57:09.752Z |
2409492 | 2409492 | 20230422193439_lo4GX | MY000B | 2024-01-05T23:57:09.743Z | 2024-01-05T23:57:09.743Z |
2409370 | 2409370 | 20230422191133_0Z4cp | MY000B | 2024-01-05T23:57:09.731Z | 2024-01-05T23:57:09.731Z |
2409244 | 2409244 | 20230422183834_Knf7b | MY000B | 2024-01-05T23:57:09.717Z | 2024-01-05T23:57:09.717Z |
2409095 | 2409095 | 20230422174845_4a7q2 | MY000B | 2024-01-05T23:57:09.699Z | 2024-01-05T23:57:09.699Z |
2409072 | 2409072 | 20230422174617_V2jGa | MY000B | 2024-01-05T23:57:09.696Z | 2024-01-05T23:57:09.696Z |
2408981 | 2408981 | 20230422172829_WkO46 | MY000B | 2024-01-05T23:57:09.685Z | 2024-01-05T23:57:09.685Z |
2408925 | 2408925 | 20230422171628_vZCTQ | MY000B | 2024-01-05T23:57:09.680Z | 2024-01-05T23:57:09.680Z |
2408914 | 2408914 | 20230422171508_enTaA | MY000B | 2024-01-05T23:57:09.679Z | 2024-01-05T23:57:09.679Z |
2408826 | 2408826 | 20230422170021_q1VwM | MY000B | 2024-01-05T23:57:08.429Z | 2024-01-05T23:57:08.429Z |
2408775 | 2408775 | 20230422165306_hHGyY | MY000B | 2024-01-05T23:57:08.422Z | 2024-01-05T23:57:08.422Z |
2408641 | 2408641 | 20230422162925_3subj | MY000B | 2024-01-05T23:57:08.406Z | 2024-01-05T23:57:08.406Z |
2408611 | 2408611 | 20230422162254_eFErF | MY000B | 2024-01-05T23:57:08.402Z | 2024-01-05T23:57:08.402Z |
2408571 | 2408571 | 20230422161147_4jJZR | MY000B | 2024-01-05T23:57:08.397Z | 2024-01-05T23:57:08.397Z |
2408379 | 2408379 | 20230422153759_hvxQ8 | MY000B | 2024-01-05T23:57:08.376Z | 2024-01-05T23:57:08.376Z |
2407928 | 2407928 | 20230422125654_MmSN6 | MY000B | 2024-01-05T23:57:08.320Z | 2024-01-05T23:57:08.320Z |
2404227 | 2404227 | 20230421193652_9ElfN | MY000B | 2024-01-05T23:57:07.880Z | 2024-01-05T23:57:07.880Z |
2404095 | 2404095 | 20230421180108_Ee4i3 | MY000B | 2024-01-05T23:57:07.861Z | 2024-01-05T23:57:07.861Z |
2404073 | 2404073 | 20230421174817_c7ind | MY000B | 2024-01-05T23:57:07.859Z | 2024-01-05T23:57:07.859Z |
2404059 | 2404059 | 20230421174320_LhqgF | MY000B | 2024-01-05T23:57:07.856Z | 2024-01-05T23:57:07.856Z |
2403803 | 2403803 | 20230421145656_5NV2g | MY000B | 2024-01-05T23:57:06.568Z | 2024-01-05T23:57:06.568Z |
2400919 | 2400919 | 20230420210132_WueT9 | MY000B | 2024-01-05T23:57:05.533Z | 2024-01-05T23:57:05.533Z |
2400760 | 2400760 | 20230420195524_5W2T3 | MY000B | 2024-01-05T23:57:05.468Z | 2024-01-05T23:57:05.468Z |
2400672 | 2400672 | 20230420190312_5bIIZ | MY000B | 2024-01-05T23:57:05.433Z | 2024-01-05T23:57:05.433Z |
2400510 | 2400510 | 20230420161418_gz0ds | MY000B | 2024-01-05T23:57:05.360Z | 2024-01-05T23:57:05.360Z |
2396041 | 2396041 | 20230419195211_XBZaX | MY000B | 2024-01-05T23:57:02.999Z | 2024-01-05T23:57:02.999Z |
2396000 | 2396000 | 20230419191749_mES8p | MY000B | 2024-01-05T23:57:02.985Z | 2024-01-05T23:57:02.985Z |
2395948 | 2395948 | 20230419184317_O883K | MY000B | 2024-01-05T23:57:02.968Z | 2024-01-05T23:57:02.968Z |
2395946 | 2395946 | 20230419183950_AaOwm | MY000B | 2024-01-05T23:57:02.967Z | 2024-01-05T23:57:02.967Z |
2395491 | 2395491 | 20230419150409_Yl0Uf | MY000B | 2024-01-05T23:57:01.260Z | 2024-01-05T23:57:01.260Z |
2393416 | 2393416 | 20230418195142_Lxllg | MY000B | 2024-01-05T23:57:00.437Z | 2024-01-05T23:57:00.437Z |
2393408 | 2393408 | 20230418194219_K840e | MY000B | 2024-01-05T23:57:00.433Z | 2024-01-05T23:57:00.433Z |
2393318 | 2393318 | 20230418174630_Eb3b3 | MY000B | 2024-01-05T23:57:00.401Z | 2024-01-05T23:57:00.401Z |
2393048 | 2393048 | 20230418142156_2D2lu | MY000B | 2024-01-05T23:56:58.799Z | 2024-01-05T23:56:58.799Z |
2393051 | 2393051 | 20230418142357_wWhq4 | MY000B | 2024-01-05T23:56:58.799Z | 2024-01-05T23:56:58.799Z |
2389087 | 2389087 | 20230416171024_XZ9Al | MY000B | 2024-01-05T23:56:57.153Z | 2024-01-05T23:56:57.153Z |
2380286 | 2380286 | 20230413134102_m8S3J | MY000B | 2024-01-05T23:56:52.618Z | 2024-01-05T23:56:52.618Z |
2378910 | 2378910 | 20230412195220_XU2jg | MY000B | 2024-01-05T23:56:51.276Z | 2024-01-05T23:56:51.276Z |
2378912 | 2378912 | 20230412200604_jQbkx | MY000B | 2024-01-05T23:56:51.276Z | 2024-01-05T23:56:51.276Z |
2378904 | 2378904 | 20230412193748_X9XpC | MY000B | 2024-01-05T23:56:51.275Z | 2024-01-05T23:56:51.275Z |
2378670 | 2378670 | 20230412145439_4v3L1 | MY000B | 2024-01-05T23:56:51.246Z | 2024-01-05T23:56:51.246Z |
2378629 | 2378629 | 20230412141846_cPfi6 | MY000B | 2024-01-05T23:56:51.240Z | 2024-01-05T23:56:51.240Z |
2376666 | 2376666 | 20230411211715_OJRvw | MY000B | 2024-01-05T23:56:49.861Z | 2024-01-05T23:56:49.861Z |
Advanced export
JSON shape: default, array, newline-delimited
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);