participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,413 rows where station_code = "CA0032" 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 |
---|---|---|---|---|---|
5134363 | 5134363 | 20240916083445_33A5r | CA0032 | 2024-09-19T12:17:39.213Z | 2024-09-19T12:17:39.213Z |
5134147 | 5134147 | 20240916053243_YxHVd | CA0032 | 2024-09-19T12:17:25.172Z | 2024-09-19T12:17:25.172Z |
5134131 | 5134131 | 20240916052233_bnARM | CA0032 | 2024-09-19T12:17:24.341Z | 2024-09-19T12:17:24.341Z |
5134118 | 5134118 | 20240916051321_9h3fe | CA0032 | 2024-09-19T12:17:22.478Z | 2024-09-19T12:17:22.478Z |
5133973 | 5133973 | 20240916042415_tmk4u | CA0032 | 2024-09-19T12:17:15.119Z | 2024-09-19T12:17:15.119Z |
5132439 | 5132439 | 20240916010846_PHRGo | CA0032 | 2024-09-19T12:16:12.876Z | 2024-09-19T12:16:12.876Z |
5132291 | 5132291 | 20240916002556_dzC6A | CA0032 | 2024-09-19T12:16:03.598Z | 2024-09-19T12:16:03.598Z |
5130012 | 5130012 | 20240917075055_TiwJ1 | CA0032 | 2024-09-19T12:12:25.644Z | 2024-09-19T12:12:25.644Z |
5129993 | 5129993 | 20240917073500_IHRPP | CA0032 | 2024-09-19T12:12:23.958Z | 2024-09-19T12:12:23.958Z |
5129969 | 5129969 | 20240917070955_Vdnz3 | CA0032 | 2024-09-19T12:12:21.146Z | 2024-09-19T12:12:21.146Z |
5129950 | 5129950 | 20240917065635_yagzj | CA0032 | 2024-09-19T12:12:19.208Z | 2024-09-19T12:12:19.208Z |
5128651 | 5128651 | 20240917022138_AL6J3 | CA0032 | 2024-09-19T12:10:54.041Z | 2024-09-19T12:10:54.041Z |
5128347 | 5128347 | 20240917012802_M4nTE | CA0032 | 2024-09-19T12:10:28.390Z | 2024-09-19T12:10:28.390Z |
5126191 | 5126191 | 20240918092026_a5BMR | CA0032 | 2024-09-19T12:05:19.031Z | 2024-09-19T12:06:42.157Z |
5123190 | 5123190 | 20240914091344_W8Qyt | CA0032 | 2024-09-18T12:11:42.120Z | 2024-09-19T12:20:08.886Z |
5123023 | 5123023 | 20240914084152_3fw2N | CA0032 | 2024-09-18T12:11:38.446Z | 2024-09-19T12:20:07.348Z |
5122812 | 5122812 | 20240914080232_3uhPY | CA0032 | 2024-09-18T12:11:31.728Z | 2024-09-19T12:20:06.308Z |
5122797 | 5122797 | 20240914075959_QO66X | CA0032 | 2024-09-18T12:11:31.385Z | 2024-09-19T12:20:06.210Z |
5122758 | 5122758 | 20240914075347_kRTCW | CA0032 | 2024-09-18T12:11:30.543Z | 2024-09-19T12:20:06.018Z |
5122357 | 5122357 | 20240914055157_d0SCX | CA0032 | 2024-09-18T12:11:15.515Z | 2024-09-19T12:20:03.999Z |
5122347 | 5122347 | 20240914054818_3TexW | CA0032 | 2024-09-18T12:11:15.166Z | 2024-09-19T12:20:03.975Z |
5122340 | 5122340 | 20240914054628_PlCyO | CA0032 | 2024-09-18T12:11:15.014Z | 2024-09-19T12:20:03.950Z |
5122338 | 5122338 | 20240914054614_X9Tid | CA0032 | 2024-09-18T12:11:15.001Z | 2024-09-19T12:20:03.948Z |
5121187 | 5121187 | 20240914035454_SGUAr | CA0032 | 2024-09-18T12:10:52.213Z | 2024-09-19T12:20:01.474Z |
5119742 | 5119742 | 20240914024638_b9NyC | CA0032 | 2024-09-18T12:10:25.451Z | 2024-09-19T12:19:58.840Z |
5118311 | 5118311 | 20240915091442_hT0SG | CA0032 | 2024-09-18T12:08:36.978Z | 2024-09-19T12:19:21.992Z |
5118132 | 5118132 | 20240915083931_98Gy3 | CA0032 | 2024-09-18T12:08:26.214Z | 2024-09-19T12:19:20.690Z |
5118117 | 5118117 | 20240915083601_ayeU9 | CA0032 | 2024-09-18T12:08:24.987Z | 2024-09-19T12:19:20.571Z |
5117951 | 5117951 | 20240915075445_3TFUt | CA0032 | 2024-09-18T12:08:10.197Z | 2024-09-19T12:19:19.261Z |
5117843 | 5117843 | 20240915072205_lIaEo | CA0032 | 2024-09-18T12:08:02.846Z | 2024-09-19T12:19:18.482Z |
5117747 | 5117747 | 20240915064146_4DrVT | CA0032 | 2024-09-18T12:07:54.968Z | 2024-09-19T12:19:17.495Z |
5117737 | 5117737 | 20240915064132_13jMO | CA0032 | 2024-09-18T12:07:54.513Z | 2024-09-19T12:19:17.357Z |
5117656 | 5117656 | 20240915060807_kNADQ | CA0032 | 2024-09-18T12:07:51.197Z | 2024-09-19T12:19:16.788Z |
5116986 | 5116986 | 20240915035323_OM7p5 | CA0032 | 2024-09-18T12:07:27.659Z | 2024-09-19T12:19:12.983Z |
5116313 | 5116313 | 20240915032109_vJ9jd | CA0032 | 2024-09-18T12:06:56.571Z | 2024-09-19T12:19:10.315Z |
5115986 | 5115986 | 20240915030225_aLZS0 | CA0032 | 2024-09-18T12:06:33.322Z | 2024-09-19T12:19:08.085Z |
5115731 | 5115731 | 20240915025107_UiSIu | CA0032 | 2024-09-18T12:06:22.299Z | 2024-09-19T12:19:06.522Z |
5114827 | 5114827 | 20240915020037_NqMo3 | CA0032 | 2024-09-18T12:05:36.159Z | 2024-09-19T12:19:00.094Z |
5113318 | 5113318 | 20240915003716_qWUd4 | CA0032 | 2024-09-18T12:04:07.804Z | 2024-09-19T12:18:48.456Z |
5112905 | 5112905 | 20240915000450_qW6ow | CA0032 | 2024-09-18T12:03:45.944Z | 2024-09-19T12:18:45.571Z |
5108870 | 5108870 | 20240913075216_XpqLK | CA0032 | 2024-09-17T12:14:12.809Z | 2024-09-19T12:20:50.970Z |
5108861 | 5108861 | 20240913074804_HZC66 | CA0032 | 2024-09-17T12:14:11.035Z | 2024-09-19T12:20:50.955Z |
5108811 | 5108811 | 20240913073754_ieS7j | CA0032 | 2024-09-17T12:14:08.309Z | 2024-09-19T12:20:50.832Z |
5108797 | 5108797 | 20240913073336_CMyrm | CA0032 | 2024-09-17T12:14:07.598Z | 2024-09-19T12:20:50.793Z |
5108494 | 5108494 | 20240913055901_rrWj6 | CA0032 | 2024-09-17T12:13:47.677Z | 2024-09-19T12:20:49.045Z |
5108142 | 5108142 | 20240913042630_DZOZI | CA0032 | 2024-09-17T12:13:31.373Z | 2024-09-19T12:20:47.867Z |
5102749 | 5102749 | 20240914014129_IUfFW | CA0032 | 2024-09-17T12:07:34.468Z | 2024-09-19T12:19:55.524Z |
5102197 | 5102197 | 20240914011209_Te3w7 | CA0032 | 2024-09-17T12:06:54.508Z | 2024-09-19T12:19:52.869Z |
5102003 | 5102003 | 20240914005923_LlUPT | CA0032 | 2024-09-17T12:06:39.053Z | 2024-09-19T12:19:52.162Z |
5094729 | 5094729 | 20240912042002_sLEPp | CA0032 | 2024-09-16T12:14:57.322Z | 2024-09-19T12:21:16.407Z |
5094034 | 5094034 | 20240912034543_cMpd7 | CA0032 | 2024-09-16T12:14:31.241Z | 2024-09-19T12:21:15.822Z |
5093776 | 5093776 | 20240912033450_67tMy | CA0032 | 2024-09-16T12:14:25.159Z | 2024-09-19T12:21:15.644Z |
5092985 | 5092985 | 20240912030417_jpFod | CA0032 | 2024-09-16T12:14:08.854Z | 2024-09-19T12:21:14.793Z |
5092907 | 5092907 | 20240912030133_9V6Vc | CA0032 | 2024-09-16T12:14:07.037Z | 2024-09-19T12:21:14.705Z |
5091460 | 5091460 | 20240912021004_MmpGg | CA0032 | 2024-09-16T12:13:06.678Z | 2024-09-19T12:21:13.055Z |
5090241 | 5090241 | 20240912011725_EEVU3 | CA0032 | 2024-09-16T12:12:08.067Z | 2024-09-19T12:21:11.088Z |
5081216 | 5081216 | 20240911065753_Oa0J7 | CA0032 | 2024-09-15T12:17:27.084Z | 2024-09-19T12:21:44.780Z |
5081134 | 5081134 | 20240911064038_W3dEt | CA0032 | 2024-09-15T12:17:24.775Z | 2024-09-19T12:21:44.665Z |
5081053 | 5081053 | 20240911061442_35edX | CA0032 | 2024-09-15T12:17:21.944Z | 2024-09-19T12:21:44.509Z |
5080790 | 5080790 | 20240911044808_18lJG | CA0032 | 2024-09-15T12:17:13.278Z | 2024-09-19T12:21:43.662Z |
5080650 | 5080650 | 20240911041901_8bIZO | CA0032 | 2024-09-15T12:17:09.588Z | 2024-09-19T12:21:43.376Z |
5080627 | 5080627 | 20240911041359_ouY2w | CA0032 | 2024-09-15T12:17:09.189Z | 2024-09-19T12:21:43.359Z |
5079615 | 5079615 | 20240911030615_LWloz | CA0032 | 2024-09-15T12:16:30.614Z | 2024-09-19T12:21:42.505Z |
5078099 | 5078099 | 20240911013939_PxUdC | CA0032 | 2024-09-15T12:15:20.023Z | 2024-09-19T12:21:39.992Z |
5077890 | 5077890 | 20240911012718_upPoj | CA0032 | 2024-09-15T12:15:10.133Z | 2024-09-19T12:21:39.766Z |
5067305 | 5067305 | 20240910091745_A5Fo0 | CA0032 | 2024-09-14T12:18:38.765Z | 2024-09-18T12:15:23.766Z |
5066813 | 5066813 | 20240910082007_YdEVi | CA0032 | 2024-09-14T12:18:14.404Z | 2024-09-18T12:15:22.784Z |
5066755 | 5066755 | 20240910081233_kRXbP | CA0032 | 2024-09-14T12:18:10.555Z | 2024-09-18T12:15:22.700Z |
5066410 | 5066410 | 20240910072453_lcWRF | CA0032 | 2024-09-14T12:17:55.156Z | 2024-09-18T12:15:21.845Z |
5066288 | 5066288 | 20240910070546_m1dFt | CA0032 | 2024-09-14T12:17:48.436Z | 2024-09-18T12:15:21.524Z |
5066254 | 5066254 | 20240910070057_twPxa | CA0032 | 2024-09-14T12:17:47.104Z | 2024-09-18T12:15:21.473Z |
5066240 | 5066240 | 20240910065729_HpPRn | CA0032 | 2024-09-14T12:17:46.201Z | 2024-09-18T12:15:21.445Z |
5065705 | 5065705 | 20240910051644_aPYcs | CA0032 | 2024-09-14T12:17:19.580Z | 2024-09-18T12:15:20.185Z |
5065680 | 5065680 | 20240910050640_3O3Cv | CA0032 | 2024-09-14T12:17:18.570Z | 2024-09-18T12:15:20.146Z |
5065576 | 5065576 | 20240910044214_OC8AX | CA0032 | 2024-09-14T12:17:12.128Z | 2024-09-18T12:15:19.853Z |
5065457 | 5065457 | 20240910041325_CJ2mN | CA0032 | 2024-09-14T12:17:06.280Z | 2024-09-18T12:15:19.515Z |
5065372 | 5065372 | 20240910035654_MogEy | CA0032 | 2024-09-14T12:17:02.369Z | 2024-09-18T12:15:19.219Z |
5065306 | 5065306 | 20240910034003_MD6CX | CA0032 | 2024-09-14T12:16:56.687Z | 2024-09-18T12:15:18.976Z |
5065243 | 5065243 | 20240910032705_DLAuR | CA0032 | 2024-09-14T12:16:48.535Z | 2024-09-18T12:15:18.816Z |
5065219 | 5065219 | 20240910032141_xTaSF | CA0032 | 2024-09-14T12:16:42.983Z | 2024-09-18T12:15:18.763Z |
5065172 | 5065172 | 20240910031635_Aqvaj | CA0032 | 2024-09-14T12:16:32.192Z | 2024-09-18T12:15:18.584Z |
5064467 | 5064467 | 20240910011326_BCYAE | CA0032 | 2024-09-14T12:15:29.323Z | 2024-09-18T12:15:16.677Z |
5064326 | 5064326 | 20240910004922_70rxH | CA0032 | 2024-09-14T12:15:17.592Z | 2024-09-18T12:15:16.123Z |
5041476 | 5041476 | 20240906082310_n7sS8 | CA0032 | 2024-09-12T12:16:42.875Z | 2024-09-14T12:23:13.629Z |
5041440 | 5041440 | 20240906081613_qrOS7 | CA0032 | 2024-09-12T12:16:41.517Z | 2024-09-14T12:23:13.504Z |
5041379 | 5041379 | 20240906080648_hvvga | CA0032 | 2024-09-12T12:16:39.598Z | 2024-09-14T12:23:13.399Z |
5041371 | 5041371 | 20240906080544_9OS7Q | CA0032 | 2024-09-12T12:16:39.478Z | 2024-09-14T12:23:13.392Z |
5040887 | 5040887 | 20240906062106_G2S3x | CA0032 | 2024-09-12T12:16:27.567Z | 2024-09-14T12:23:10.879Z |
5040857 | 5040857 | 20240906061242_3uhl3 | CA0032 | 2024-09-12T12:16:26.633Z | 2024-09-14T12:23:10.685Z |
5040816 | 5040816 | 20240906055650_JfKNG | CA0032 | 2024-09-12T12:16:25.550Z | 2024-09-14T12:23:10.630Z |
5040606 | 5040606 | 20240906050422_ypfKk | CA0032 | 2024-09-12T12:16:17.486Z | 2024-09-14T12:23:10.101Z |
5040430 | 5040430 | 20240906041122_A8QdW | CA0032 | 2024-09-12T12:16:11.040Z | 2024-09-14T12:23:09.134Z |
5040271 | 5040271 | 20240906032838_sV8ci | CA0032 | 2024-09-12T12:16:04.795Z | 2024-09-14T12:23:08.501Z |
5039649 | 5039649 | 20240906014618_cZj60 | CA0032 | 2024-09-12T12:15:41.202Z | 2024-09-14T12:23:03.887Z |
5035029 | 5035029 | 20240907083528_HEg1R | CA0032 | 2024-09-12T12:11:49.713Z | 2024-09-15T12:21:37.919Z |
5035019 | 5035019 | 20240907083244_h2SA1 | CA0032 | 2024-09-12T12:11:49.376Z | 2024-09-15T12:21:37.899Z |
5032719 | 5032719 | 20240907013930_MCy5K | CA0032 | 2024-09-12T12:07:54.005Z | 2024-09-15T12:21:27.549Z |
5032624 | 5032624 | 20240907012247_eZXkK | CA0032 | 2024-09-12T12:07:45.713Z | 2024-09-15T12:21:27.160Z |
5032503 | 5032503 | 20240907011020_60rEj | CA0032 | 2024-09-12T12:07:25.583Z | 2024-09-15T12:21:26.642Z |
5032256 | 5032256 | 20240907003604_jWIl1 | CA0032 | 2024-09-12T12:06:56.113Z | 2024-09-15T12:21:25.727Z |
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);