participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,418 rows where station_code = "CA000U" 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 |
---|---|---|---|---|---|
5134395 | 5134395 | 20240916085132_Wa3X2 | CA000U | 2024-09-19T12:17:42.098Z | 2024-09-19T12:17:42.098Z |
5134387 | 5134387 | 20240916085017_pahOL | CA000U | 2024-09-19T12:17:40.521Z | 2024-09-19T12:17:40.521Z |
5134360 | 5134360 | 20240916083445_33A5r | CA000U | 2024-09-19T12:17:39.213Z | 2024-09-19T12:17:39.213Z |
5134314 | 5134314 | 20240916081102_kqRM7 | CA000U | 2024-09-19T12:17:36.462Z | 2024-09-19T12:17:36.462Z |
5134263 | 5134263 | 20240916073552_uOzWQ | CA000U | 2024-09-19T12:17:34.270Z | 2024-09-19T12:17:34.270Z |
5134128 | 5134128 | 20240916052231_n5ssA | CA000U | 2024-09-19T12:17:23.874Z | 2024-09-19T12:17:23.874Z |
5134076 | 5134076 | 20240916044314_xrnSV | CA000U | 2024-09-19T12:17:18.229Z | 2024-09-19T12:17:18.229Z |
5133531 | 5133531 | 20240916033653_i1YeS | CA000U | 2024-09-19T12:17:00.777Z | 2024-09-19T12:17:00.777Z |
5132276 | 5132276 | 20240916001956_sLImZ | CA000U | 2024-09-19T12:16:03.088Z | 2024-09-19T12:16:03.088Z |
5129076 | 5129076 | 20240917031439_2T9SA | CA000U | 2024-09-19T12:11:14.072Z | 2024-09-19T12:11:14.072Z |
5129074 | 5129074 | 20240917031428_sCOk0 | CA000U | 2024-09-19T12:11:13.814Z | 2024-09-19T12:11:13.814Z |
5127981 | 5127981 | 20240917001559_SzHr3 | CA000U | 2024-09-19T12:09:52.172Z | 2024-09-19T12:09:52.172Z |
5126167 | 5126167 | 20240918090803_StkPO | CA000U | 2024-09-19T12:05:15.462Z | 2024-09-19T12:06:42.153Z |
5126116 | 5126116 | 20240918082641_y4qvQ | CA000U | 2024-09-19T12:05:08.990Z | 2024-09-19T12:06:42.143Z |
5126110 | 5126110 | 20240918082431_C38EY | CA000U | 2024-09-19T12:05:08.192Z | 2024-09-19T12:06:42.142Z |
5126011 | 5126011 | 20240918063251_iDUR6 | CA000U | 2024-09-19T12:04:44.837Z | 2024-09-19T12:06:42.124Z |
5125977 | 5125977 | 20240918054549_3hRf3 | CA000U | 2024-09-19T12:04:40.996Z | 2024-09-19T12:06:42.119Z |
5125890 | 5125890 | 20240918042658_Fx3PY | CA000U | 2024-09-19T12:04:29.582Z | 2024-09-19T12:06:42.102Z |
5125839 | 5125839 | 20240918040946_XBVuZ | CA000U | 2024-09-19T12:04:13.825Z | 2024-09-19T12:06:42.094Z |
5125743 | 5125743 | 20240918033602_dFUCF | CA000U | 2024-09-19T12:04:00.024Z | 2024-09-19T12:06:42.078Z |
5125644 | 5125644 | 20240918031310_naHtf | CA000U | 2024-09-19T12:03:47.293Z | 2024-09-19T12:06:42.062Z |
5125532 | 5125532 | 20240918025450_82K6E | CA000U | 2024-09-19T12:03:27.718Z | 2024-09-19T12:06:42.048Z |
5125346 | 5125346 | 20240918021725_0THvM | CA000U | 2024-09-19T12:03:01.797Z | 2024-09-19T12:06:42.017Z |
5125130 | 5125130 | 20240918002452_LFODO | CA000U | 2024-09-19T12:02:22.481Z | 2024-09-19T12:06:41.980Z |
5123127 | 5123127 | 20240914085824_HZEhT | CA000U | 2024-09-18T12:11:40.483Z | 2024-09-19T12:20:08.045Z |
5122969 | 5122969 | 20240914082853_AuVzb | CA000U | 2024-09-18T12:11:35.652Z | 2024-09-19T12:20:06.968Z |
5122809 | 5122809 | 20240914080232_3uhPY | CA000U | 2024-09-18T12:11:31.728Z | 2024-09-19T12:20:06.308Z |
5122795 | 5122795 | 20240914075959_QO66X | CA000U | 2024-09-18T12:11:31.385Z | 2024-09-19T12:20:06.210Z |
5122756 | 5122756 | 20240914075347_kRTCW | CA000U | 2024-09-18T12:11:30.543Z | 2024-09-19T12:20:06.018Z |
5122607 | 5122607 | 20240914072220_T3Nkk | CA000U | 2024-09-18T12:11:24.856Z | 2024-09-19T12:20:05.380Z |
5122313 | 5122313 | 20240914053325_QxDFA | CA000U | 2024-09-18T12:11:13.763Z | 2024-09-19T12:20:03.891Z |
5121502 | 5121502 | 20240914040608_rjKF3 | CA000U | 2024-09-18T12:10:57.618Z | 2024-09-19T12:20:02.008Z |
5118301 | 5118301 | 20240915091155_DSCU2 | CA000U | 2024-09-18T12:08:36.552Z | 2024-09-19T12:19:21.966Z |
5117986 | 5117986 | 20240915080516_DzuaU | CA000U | 2024-09-18T12:08:15.579Z | 2024-09-19T12:19:19.528Z |
5117844 | 5117844 | 20240915072211_40I3v | CA000U | 2024-09-18T12:08:03.027Z | 2024-09-19T12:19:18.483Z |
5117767 | 5117767 | 20240915065637_tb26X | CA000U | 2024-09-18T12:07:57.292Z | 2024-09-19T12:19:17.671Z |
5117671 | 5117671 | 20240915061819_jfsOV | CA000U | 2024-09-18T12:07:51.707Z | 2024-09-19T12:19:16.873Z |
5117668 | 5117668 | 20240915061732_XrJT1 | CA000U | 2024-09-18T12:07:51.561Z | 2024-09-19T12:19:16.866Z |
5116319 | 5116319 | 20240915032114_4swip | CA000U | 2024-09-18T12:06:57.036Z | 2024-09-19T12:19:10.351Z |
5115867 | 5115867 | 20240915025640_18Uz3 | CA000U | 2024-09-18T12:06:30.106Z | 2024-09-19T12:19:07.585Z |
5115246 | 5115246 | 20240915022853_wJF4z | CA000U | 2024-09-18T12:06:07.788Z | 2024-09-19T12:19:03.317Z |
5109125 | 5109125 | 20240913085357_petgZ | CA000U | 2024-09-17T12:14:31.041Z | 2024-09-19T12:20:51.787Z |
5109111 | 5109111 | 20240913085030_3ohw8 | CA000U | 2024-09-17T12:14:30.529Z | 2024-09-19T12:20:51.752Z |
5108810 | 5108810 | 20240913073754_ieS7j | CA000U | 2024-09-17T12:14:08.309Z | 2024-09-19T12:20:50.832Z |
5108772 | 5108772 | 20240913072658_20rnI | CA000U | 2024-09-17T12:14:05.520Z | 2024-09-19T12:20:50.729Z |
5105150 | 5105150 | 20240913023247_3HD0T | CA000U | 2024-09-17T12:11:59.391Z | 2024-09-19T12:20:44.001Z |
5102090 | 5102090 | 20240914010604_ma35e | CA000U | 2024-09-17T12:06:47.983Z | 2024-09-19T12:19:52.445Z |
5081849 | 5081849 | 20240911085233_Pgt75 | CA000U | 2024-09-15T12:17:51.252Z | 2024-09-19T12:21:46.567Z |
5081738 | 5081738 | 20240911083633_ihRLX | CA000U | 2024-09-15T12:17:44.967Z | 2024-09-19T12:21:46.360Z |
5081647 | 5081647 | 20240911081630_C6OL3 | CA000U | 2024-09-15T12:17:39.705Z | 2024-09-19T12:21:45.935Z |
5081396 | 5081396 | 20240911073638_BcvEs | CA000U | 2024-09-15T12:17:32.173Z | 2024-09-19T12:21:45.239Z |
5081028 | 5081028 | 20240911060523_yiIRm | CA000U | 2024-09-15T12:17:20.949Z | 2024-09-19T12:21:44.400Z |
5080959 | 5080959 | 20240911054108_W94Hd | CA000U | 2024-09-15T12:17:18.313Z | 2024-09-19T12:21:44.111Z |
5080858 | 5080858 | 20240911050546_fYsrV | CA000U | 2024-09-15T12:17:15.876Z | 2024-09-19T12:21:43.892Z |
5080762 | 5080762 | 20240911044102_8x2kz | CA000U | 2024-09-15T12:17:12.485Z | 2024-09-19T12:21:43.606Z |
5080648 | 5080648 | 20240911041901_8bIZO | CA000U | 2024-09-15T12:17:09.588Z | 2024-09-19T12:21:43.376Z |
5079860 | 5079860 | 20240911031620_v235d | CA000U | 2024-09-15T12:16:39.164Z | 2024-09-19T12:21:42.707Z |
5078678 | 5078678 | 20240911021123_5wPfx | CA000U | 2024-09-15T12:15:49.277Z | 2024-09-19T12:21:40.664Z |
5078525 | 5078525 | 20240911020253_Jsd9X | CA000U | 2024-09-15T12:15:42.253Z | 2024-09-19T12:21:40.482Z |
5078097 | 5078097 | 20240911013939_PxUdC | CA000U | 2024-09-15T12:15:20.011Z | 2024-09-19T12:21:39.992Z |
5067304 | 5067304 | 20240910091745_A5Fo0 | CA000U | 2024-09-14T12:18:38.765Z | 2024-09-18T12:15:23.766Z |
5067012 | 5067012 | 20240910084345_fgEtV | CA000U | 2024-09-14T12:18:26.819Z | 2024-09-18T12:15:23.200Z |
5066932 | 5066932 | 20240910083229_Xjd7x | CA000U | 2024-09-14T12:18:19.840Z | 2024-09-18T12:15:22.995Z |
5066810 | 5066810 | 20240910082005_vE1d5 | CA000U | 2024-09-14T12:18:14.063Z | 2024-09-18T12:15:22.780Z |
5066640 | 5066640 | 20240910075830_dRO2e | CA000U | 2024-09-14T12:18:05.577Z | 2024-09-18T12:15:22.366Z |
5066513 | 5066513 | 20240910074318_cbLI7 | CA000U | 2024-09-14T12:17:59.934Z | 2024-09-18T12:15:22.111Z |
5066450 | 5066450 | 20240910073104_fzdjp | CA000U | 2024-09-14T12:17:57.514Z | 2024-09-18T12:15:21.987Z |
5066418 | 5066418 | 20240910072648_JwE5f | CA000U | 2024-09-14T12:17:55.751Z | 2024-09-18T12:15:21.861Z |
5066413 | 5066413 | 20240910072506_IPMgZ | CA000U | 2024-09-14T12:17:55.345Z | 2024-09-18T12:15:21.852Z |
5066409 | 5066409 | 20240910072453_lcWRF | CA000U | 2024-09-14T12:17:55.156Z | 2024-09-18T12:15:21.845Z |
5066078 | 5066078 | 20240910063302_SXLg2 | CA000U | 2024-09-14T12:17:38.080Z | 2024-09-18T12:15:21.115Z |
5065702 | 5065702 | 20240910051644_aPYcs | CA000U | 2024-09-14T12:17:19.580Z | 2024-09-18T12:15:20.185Z |
5065678 | 5065678 | 20240910050640_3O3Cv | CA000U | 2024-09-14T12:17:18.569Z | 2024-09-18T12:15:20.146Z |
5065628 | 5065628 | 20240910045337_gn88m | CA000U | 2024-09-14T12:17:15.211Z | 2024-09-18T12:15:19.983Z |
5065574 | 5065574 | 20240910044214_OC8AX | CA000U | 2024-09-14T12:17:12.128Z | 2024-09-18T12:15:19.853Z |
5065493 | 5065493 | 20240910042330_meP36 | CA000U | 2024-09-14T12:17:07.633Z | 2024-09-18T12:15:19.592Z |
5065454 | 5065454 | 20240910041325_CJ2mN | CA000U | 2024-09-14T12:17:06.280Z | 2024-09-18T12:15:19.514Z |
5065395 | 5065395 | 20240910040237_ODK15 | CA000U | 2024-09-14T12:17:03.849Z | 2024-09-18T12:15:19.312Z |
5065305 | 5065305 | 20240910034003_MD6CX | CA000U | 2024-09-14T12:16:56.687Z | 2024-09-18T12:15:18.976Z |
5065218 | 5065218 | 20240910032141_xTaSF | CA000U | 2024-09-14T12:16:42.983Z | 2024-09-18T12:15:18.763Z |
5065169 | 5065169 | 20240910031635_Aqvaj | CA000U | 2024-09-14T12:16:32.192Z | 2024-09-18T12:15:18.584Z |
5065166 | 5065166 | 20240910031633_Figl9 | CA000U | 2024-09-14T12:16:31.937Z | 2024-09-18T12:15:18.583Z |
5065106 | 5065106 | 20240910030701_4Aigt | CA000U | 2024-09-14T12:16:26.042Z | 2024-09-18T12:15:18.408Z |
5064481 | 5064481 | 20240910011704_oObso | CA000U | 2024-09-14T12:15:30.219Z | 2024-09-18T12:15:16.708Z |
5064261 | 5064261 | 20240910003105_6iCcE | CA000U | 2024-09-14T12:15:10.662Z | 2024-09-18T12:15:15.983Z |
5055582 | 5055582 | 20240908082516_HpdSr | CA000U | 2024-09-13T12:17:17.923Z | 2024-09-16T12:21:20.407Z |
5041837 | 5041837 | 20240906091201_7lN9J | CA000U | 2024-09-12T12:16:49.357Z | 2024-09-14T12:23:14.911Z |
5041566 | 5041566 | 20240906083223_6feke | CA000U | 2024-09-12T12:16:44.467Z | 2024-09-14T12:23:13.954Z |
5041514 | 5041514 | 20240906082832_wnmd1 | CA000U | 2024-09-12T12:16:43.533Z | 2024-09-14T12:23:13.830Z |
5041434 | 5041434 | 20240906081401_2jpMS | CA000U | 2024-09-12T12:16:41.420Z | 2024-09-14T12:23:13.501Z |
5041429 | 5041429 | 20240906081324_J2LdB | CA000U | 2024-09-12T12:16:41.394Z | 2024-09-14T12:23:13.498Z |
5041404 | 5041404 | 20240906080855_AWyYT | CA000U | 2024-09-12T12:16:40.961Z | 2024-09-14T12:23:13.447Z |
5041224 | 5041224 | 20240906074050_iOIGt | CA000U | 2024-09-12T12:16:36.664Z | 2024-09-14T12:23:12.265Z |
5040999 | 5040999 | 20240906065541_SAu7v | CA000U | 2024-09-12T12:16:31.653Z | 2024-09-14T12:23:11.286Z |
5040956 | 5040956 | 20240906063635_h4wBf | CA000U | 2024-09-12T12:16:29.327Z | 2024-09-14T12:23:11.090Z |
5040801 | 5040801 | 20240906055505_vJ2Yy | CA000U | 2024-09-12T12:16:25.298Z | 2024-09-14T12:23:10.625Z |
5040563 | 5040563 | 20240906045346_MkZHb | CA000U | 2024-09-12T12:16:16.477Z | 2024-09-14T12:23:09.949Z |
5040352 | 5040352 | 20240906034830_KpuRm | CA000U | 2024-09-12T12:16:07.334Z | 2024-09-14T12:23:08.815Z |
5040272 | 5040272 | 20240906032841_2yd2P | CA000U | 2024-09-12T12:16:04.820Z | 2024-09-14T12:23:08.505Z |
5040063 | 5040063 | 20240906024925_NCK5q | CA000U | 2024-09-12T12:15:57.190Z | 2024-09-14T12:23:07.243Z |
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);