participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
16,230 rows where station_code = "HR000K" 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 |
---|---|---|---|---|---|
4041438 | 4041438 | 20240307035930_8Cfsu | HR000K | 2024-03-08T14:08:54.418Z | 2024-03-15T12:19:34.379Z |
4033363 | 4033363 | 20240305184548_LkUTg | HR000K | 2024-03-07T14:04:24.013Z | 2024-03-14T12:24:55.756Z |
4020789 | 4020789 | 20240303030822_E9g1N | HR000K | 2024-03-04T14:06:24.088Z | 2024-03-11T12:18:38.791Z |
3981675 | 3981675 | 20240217024401_OwBHT | HR000K | 2024-02-18T14:07:05.780Z | 2024-02-25T14:18:43.441Z |
3971504 | 3971504 | 20240215045106_3wpu5 | HR000K | 2024-02-16T14:06:42.934Z | 2024-02-23T14:21:09.584Z |
3971471 | 3971471 | 20240215043338_24XQB | HR000K | 2024-02-16T14:06:38.647Z | 2024-02-23T14:21:08.745Z |
3971396 | 3971396 | 20240215035029_uH656 | HR000K | 2024-02-16T14:06:27.823Z | 2024-02-23T14:21:06.744Z |
3971353 | 3971353 | 20240215033047_oSX4L | HR000K | 2024-02-16T14:06:12.148Z | 2024-02-23T14:21:05.955Z |
3971337 | 3971337 | 20240215032549_weUP8 | HR000K | 2024-02-16T14:06:09.949Z | 2024-02-23T14:21:04.663Z |
3971296 | 3971296 | 20240215025353_ezfOo | HR000K | 2024-02-16T14:06:02.113Z | 2024-02-23T14:21:03.494Z |
3971112 | 3971112 | 20240215010516_G6DsO | HR000K | 2024-02-16T14:05:26.892Z | 2024-02-23T14:20:58.764Z |
3970978 | 3970978 | 20240214212530_6lLfH | HR000K | 2024-02-16T14:04:55.191Z | 2024-02-23T14:20:53.946Z |
3970973 | 3970973 | 20240214211433_vvkYE | HR000K | 2024-02-16T14:04:54.583Z | 2024-02-23T14:20:53.664Z |
3970968 | 3970968 | 20240214211411_nCh6l | HR000K | 2024-02-16T14:04:54.165Z | 2024-02-23T14:20:53.568Z |
3970963 | 3970963 | 20240214210608_b3Jor | HR000K | 2024-02-16T14:04:53.222Z | 2024-02-23T14:20:53.439Z |
3966133 | 3966133 | 20240214045608_rePd8 | HR000K | 2024-02-15T14:08:22.848Z | 2024-02-22T14:24:17.520Z |
3965990 | 3965990 | 20240214040914_nEnWv | HR000K | 2024-02-15T14:08:09.174Z | 2024-02-22T14:24:11.573Z |
3965671 | 3965671 | 20240214015539_LW2HH | HR000K | 2024-02-15T14:07:18.814Z | 2024-02-22T14:23:55.268Z |
3965610 | 3965610 | 20240214013714_1g5UD | HR000K | 2024-02-15T14:07:13.401Z | 2024-02-22T14:23:52.737Z |
3938378 | 3938378 | 20240208182804_M3ENv | HR000K | 2024-02-10T14:03:10.198Z | 2024-02-17T14:26:02.786Z |
2369083 | 2369083 | 20230407195057_Z5kqI | HR000K | 2024-01-05T23:56:41.731Z | 2024-01-05T23:56:41.731Z |
2355006 | 2355006 | 20230329031222_zZyk6 | HR000K | 2024-01-05T23:56:28.955Z | 2024-01-05T23:56:28.955Z |
2354998 | 2354998 | 20230329030648_z6AM7 | HR000K | 2024-01-05T23:56:28.954Z | 2024-01-05T23:56:28.954Z |
2354982 | 2354982 | 20230329025126_gsDOF | HR000K | 2024-01-05T23:56:28.952Z | 2024-01-05T23:56:28.952Z |
2354968 | 2354968 | 20230329023531_OSnPt | HR000K | 2024-01-05T23:56:28.950Z | 2024-01-05T23:56:28.950Z |
2354948 | 2354948 | 20230329020041_MCgZz | HR000K | 2024-01-05T23:56:28.947Z | 2024-01-05T23:56:28.947Z |
2354906 | 2354906 | 20230329011232_C0KJD | HR000K | 2024-01-05T23:56:28.940Z | 2024-01-05T23:56:28.940Z |
2354870 | 2354870 | 20230329004202_4qamI | HR000K | 2024-01-05T23:56:28.935Z | 2024-01-05T23:56:28.935Z |
2354853 | 2354853 | 20230329002920_IhZJL | HR000K | 2024-01-05T23:56:28.932Z | 2024-01-05T23:56:28.932Z |
2354754 | 2354754 | 20230328215204_dGX6y | HR000K | 2024-01-05T23:56:28.916Z | 2024-01-05T23:56:28.916Z |
2347789 | 2347789 | 20230325225757_KxxgH | HR000K | 2024-01-05T23:56:24.291Z | 2024-01-05T23:56:24.291Z |
2347791 | 2347791 | 20230325230148_dKHS0 | HR000K | 2024-01-05T23:56:24.291Z | 2024-01-05T23:56:24.291Z |
2347787 | 2347787 | 20230325225226_4hpHd | HR000K | 2024-01-05T23:56:24.290Z | 2024-01-05T23:56:24.290Z |
2347774 | 2347774 | 20230325224246_JyW3R | HR000K | 2024-01-05T23:56:24.287Z | 2024-01-05T23:56:24.287Z |
2347776 | 2347776 | 20230325224301_l52Tb | HR000K | 2024-01-05T23:56:24.287Z | 2024-01-05T23:56:24.287Z |
2347765 | 2347765 | 20230325223153_ZrTWz | HR000K | 2024-01-05T23:56:24.284Z | 2024-01-05T23:56:24.284Z |
2347760 | 2347760 | 20230325222607_gvUxC | HR000K | 2024-01-05T23:56:24.282Z | 2024-01-05T23:56:24.282Z |
2347753 | 2347753 | 20230325221348_QTFPH | HR000K | 2024-01-05T23:56:24.281Z | 2024-01-05T23:56:24.281Z |
2347724 | 2347724 | 20230325211711_TKHXE | HR000K | 2024-01-05T23:56:24.273Z | 2024-01-05T23:56:24.273Z |
2345890 | 2345890 | 20230324210607_tQw3q | HR000K | 2024-01-05T23:56:22.529Z | 2024-01-05T23:56:22.529Z |
2344675 | 2344675 | 20230324032843_KHwzY | HR000K | 2024-01-05T23:56:21.017Z | 2024-01-05T23:56:21.017Z |
2344601 | 2344601 | 20230324031605_hs2AI | HR000K | 2024-01-05T23:56:21.005Z | 2024-01-05T23:56:21.005Z |
2344525 | 2344525 | 20230324030102_YjhgZ | HR000K | 2024-01-05T23:56:20.993Z | 2024-01-05T23:56:20.993Z |
2344487 | 2344487 | 20230324025129_K0Juf | HR000K | 2024-01-05T23:56:20.986Z | 2024-01-05T23:56:20.986Z |
2344308 | 2344308 | 20230324022959_82wMA | HR000K | 2024-01-05T23:56:20.963Z | 2024-01-05T23:56:20.963Z |
2344175 | 2344175 | 20230324020321_wHftU | HR000K | 2024-01-05T23:56:20.942Z | 2024-01-05T23:56:20.942Z |
2343998 | 2343998 | 20230324012206_MEcEk | HR000K | 2024-01-05T23:56:20.921Z | 2024-01-05T23:56:20.921Z |
2343856 | 2343856 | 20230324003401_n64ih | HR000K | 2024-01-05T23:56:20.900Z | 2024-01-05T23:56:20.900Z |
2343788 | 2343788 | 20230324000331_n9lFk | HR000K | 2024-01-05T23:56:20.890Z | 2024-01-05T23:56:20.890Z |
2343757 | 2343757 | 20230323234359_10rNV | HR000K | 2024-01-05T23:56:20.886Z | 2024-01-05T23:56:20.886Z |
2343685 | 2343685 | 20230323230922_tc8gc | HR000K | 2024-01-05T23:56:20.874Z | 2024-01-05T23:56:20.874Z |
2343653 | 2343653 | 20230323224732_iAJRu | HR000K | 2024-01-05T23:56:20.869Z | 2024-01-05T23:56:20.869Z |
2343645 | 2343645 | 20230323224311_hbjWS | HR000K | 2024-01-05T23:56:20.867Z | 2024-01-05T23:56:20.867Z |
2343567 | 2343567 | 20230323214306_u3iGE | HR000K | 2024-01-05T23:56:20.854Z | 2024-01-05T23:56:20.854Z |
2343463 | 2343463 | 20230323193531_vjoLS | HR000K | 2024-01-05T23:56:20.834Z | 2024-01-05T23:56:20.834Z |
2342215 | 2342215 | 20230323035517_UL2My | HR000K | 2024-01-05T23:56:19.388Z | 2024-01-05T23:56:19.388Z |
2342078 | 2342078 | 20230323031303_76S6U | HR000K | 2024-01-05T23:56:19.356Z | 2024-01-05T23:56:19.356Z |
2341904 | 2341904 | 20230323015846_xbY3w | HR000K | 2024-01-05T23:56:19.307Z | 2024-01-05T23:56:19.307Z |
2341784 | 2341784 | 20230323013826_QbavG | HR000K | 2024-01-05T23:56:19.279Z | 2024-01-05T23:56:19.279Z |
2341703 | 2341703 | 20230323010815_kAnym | HR000K | 2024-01-05T23:56:19.254Z | 2024-01-05T23:56:19.254Z |
2341705 | 2341705 | 20230323011202_4FZpI | HR000K | 2024-01-05T23:56:19.254Z | 2024-01-05T23:56:19.254Z |
2341528 | 2341528 | 20230322233553_Y9bq8 | HR000K | 2024-01-05T23:56:19.202Z | 2024-01-05T23:56:19.202Z |
2341450 | 2341450 | 20230322221257_sZwAu | HR000K | 2024-01-05T23:56:19.179Z | 2024-01-05T23:56:19.179Z |
2341435 | 2341435 | 20230322220045_Qjedx | HR000K | 2024-01-05T23:56:19.173Z | 2024-01-05T23:56:19.173Z |
2341405 | 2341405 | 20230322211739_FCpoP | HR000K | 2024-01-05T23:56:19.163Z | 2024-01-05T23:56:19.163Z |
2341374 | 2341374 | 20230322204329_QiksB | HR000K | 2024-01-05T23:56:19.155Z | 2024-01-05T23:56:19.155Z |
2340005 | 2340005 | 20230322003059_iPggP | HR000K | 2024-01-05T23:56:17.198Z | 2024-01-05T23:56:17.198Z |
2339992 | 2339992 | 20230322002137_PlZr0 | HR000K | 2024-01-05T23:56:17.196Z | 2024-01-05T23:56:17.196Z |
2339996 | 2339996 | 20230322002400_iITHJ | HR000K | 2024-01-05T23:56:17.196Z | 2024-01-05T23:56:17.196Z |
2339969 | 2339969 | 20230321235606_ekvA5 | HR000K | 2024-01-05T23:56:17.192Z | 2024-01-05T23:56:17.192Z |
2339940 | 2339940 | 20230321233836_dcDRb | HR000K | 2024-01-05T23:56:17.188Z | 2024-01-05T23:56:17.188Z |
2339932 | 2339932 | 20230321232949_l4j0f | HR000K | 2024-01-05T23:56:17.187Z | 2024-01-05T23:56:17.187Z |
2339844 | 2339844 | 20230321204747_3FObx | HR000K | 2024-01-05T23:56:17.173Z | 2024-01-05T23:56:17.173Z |
2336076 | 2336076 | 20230319030009_RsGVi | HR000K | 2024-01-05T23:56:13.319Z | 2024-01-05T23:56:13.319Z |
2335910 | 2335910 | 20230319021043_0qsLJ | HR000K | 2024-01-05T23:56:13.301Z | 2024-01-05T23:56:13.301Z |
2335841 | 2335841 | 20230319014653_S1xAK | HR000K | 2024-01-05T23:56:13.293Z | 2024-01-05T23:56:13.293Z |
2335820 | 2335820 | 20230319014211_GdLaw | HR000K | 2024-01-05T23:56:13.290Z | 2024-01-05T23:56:13.290Z |
2335667 | 2335667 | 20230319004549_AEBYo | HR000K | 2024-01-05T23:56:13.272Z | 2024-01-05T23:56:13.272Z |
2335637 | 2335637 | 20230319003227_OtSZo | HR000K | 2024-01-05T23:56:13.268Z | 2024-01-05T23:56:13.268Z |
2335521 | 2335521 | 20230318232138_Z3m38 | HR000K | 2024-01-05T23:56:13.251Z | 2024-01-05T23:56:13.251Z |
2335449 | 2335449 | 20230318224046_rwk90 | HR000K | 2024-01-05T23:56:13.242Z | 2024-01-05T23:56:13.242Z |
2335452 | 2335452 | 20230318224622_bUj3G | HR000K | 2024-01-05T23:56:13.242Z | 2024-01-05T23:56:13.242Z |
2335348 | 2335348 | 20230318210927_s0n3D | HR000K | 2024-01-05T23:56:13.227Z | 2024-01-05T23:56:13.227Z |
2335245 | 2335245 | 20230318201616_TLlxz | HR000K | 2024-01-05T23:56:13.214Z | 2024-01-05T23:56:13.214Z |
2333147 | 2333147 | 20230318035420_98ZnO | HR000K | 2024-01-05T23:56:11.774Z | 2024-01-05T23:56:11.774Z |
2333130 | 2333130 | 20230318034825_aUosi | HR000K | 2024-01-05T23:56:11.771Z | 2024-01-05T23:56:11.771Z |
2333114 | 2333114 | 20230318034303_7SDO9 | HR000K | 2024-01-05T23:56:11.769Z | 2024-01-05T23:56:11.769Z |
2333072 | 2333072 | 20230318033141_KR5JC | HR000K | 2024-01-05T23:56:11.765Z | 2024-01-05T23:56:11.765Z |
2333028 | 2333028 | 20230318031731_p8sKk | HR000K | 2024-01-05T23:56:11.759Z | 2024-01-05T23:56:11.759Z |
2332988 | 2332988 | 20230318025543_oCRkK | HR000K | 2024-01-05T23:56:11.753Z | 2024-01-05T23:56:11.753Z |
2332979 | 2332979 | 20230318025413_V7wXN | HR000K | 2024-01-05T23:56:11.751Z | 2024-01-05T23:56:11.751Z |
2332901 | 2332901 | 20230318021133_mY38k | HR000K | 2024-01-05T23:56:11.741Z | 2024-01-05T23:56:11.741Z |
2332898 | 2332898 | 20230318021133_PeCag | HR000K | 2024-01-05T23:56:11.740Z | 2024-01-05T23:56:11.740Z |
2332868 | 2332868 | 20230318015628_lIHNe | HR000K | 2024-01-05T23:56:11.736Z | 2024-01-05T23:56:11.736Z |
2332804 | 2332804 | 20230318011959_PgFG8 | HR000K | 2024-01-05T23:56:11.727Z | 2024-01-05T23:56:11.727Z |
2332666 | 2332666 | 20230318000001_ZuID3 | HR000K | 2024-01-05T23:56:11.706Z | 2024-01-05T23:56:11.706Z |
2332627 | 2332627 | 20230317232340_13wCE | HR000K | 2024-01-05T23:56:11.701Z | 2024-01-05T23:56:11.701Z |
2332605 | 2332605 | 20230317224551_8KB4Z | HR000K | 2024-01-05T23:56:11.698Z | 2024-01-05T23:56:11.698Z |
2332573 | 2332573 | 20230317211445_24AM7 | HR000K | 2024-01-05T23:56:11.693Z | 2024-01-05T23:56:11.693Z |
2332555 | 2332555 | 20230317205626_N2tUX | HR000K | 2024-01-05T23:56:11.690Z | 2024-01-05T23:56:11.690Z |
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);