participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,459 rows where station_code = "US002M" 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 |
---|---|---|---|---|---|
5503947 | 5503947 | 20241108002329_YotxU | US002M | 2024-11-09T14:13:54.366Z | 2024-11-09T14:16:28.407Z |
5423466 | 5423466 | 20241029102702_HyDAB | US002M | 2024-10-31T12:01:32.554Z | 2024-11-07T14:26:25.895Z |
5423424 | 5423424 | 20241029102133_gSGy7 | US002M | 2024-10-31T12:01:27.352Z | 2024-11-07T14:26:25.744Z |
5421382 | 5421382 | 20241028061232_xO2zT | US002M | 2024-10-30T12:19:53.574Z | 2024-11-05T14:27:18.524Z |
5411950 | 5411950 | 20241027094406_luDFL | US002M | 2024-10-29T12:19:20.439Z | 2024-11-05T14:26:56.941Z |
5410604 | 5410604 | 20241027052233_aMKh3 | US002M | 2024-10-29T12:17:59.333Z | 2024-11-04T14:29:05.091Z |
5400142 | 5400142 | 20241026054410_vYBjH | US002M | 2024-10-28T12:20:24.560Z | 2024-11-03T14:27:41.392Z |
5391128 | 5391128 | 20241026111453_aY2fo | US002M | 2024-10-28T12:04:45.114Z | 2024-11-04T14:28:33.546Z |
5391007 | 5391007 | 20241026110204_VDnV8 | US002M | 2024-10-28T12:04:33.257Z | 2024-11-04T14:28:33.085Z |
5390521 | 5390521 | 20241026095959_1FMOW | US002M | 2024-10-28T12:03:22.009Z | 2024-11-04T14:28:29.337Z |
5389427 | 5389427 | 20241026065726_aprL6 | US002M | 2024-10-28T12:00:16.975Z | 2024-11-04T14:28:22.153Z |
5375637 | 5375637 | 20241024032216_4FXpA | US002M | 2024-10-26T12:21:34.494Z | 2024-11-01T12:27:01.143Z |
5369266 | 5369266 | 20241024111357_T6Y3l | US002M | 2024-10-26T12:06:27.074Z | 2024-11-02T12:28:17.760Z |
5369124 | 5369124 | 20241024105939_fQPkY | US002M | 2024-10-26T12:05:57.103Z | 2024-11-02T12:28:17.559Z |
5368188 | 5368188 | 20241024084156_blfrs | US002M | 2024-10-26T12:02:47.484Z | 2024-11-02T12:28:15.198Z |
5368030 | 5368030 | 20241024081850_e41D6 | US002M | 2024-10-26T12:02:20.819Z | 2024-11-02T12:28:14.950Z |
5367015 | 5367015 | 20241023050444_4S07B | US002M | 2024-10-25T12:21:40.965Z | 2024-10-31T12:30:10.522Z |
5356415 | 5356415 | 20241023064616_0hhHQ | US002M | 2024-10-25T12:00:29.426Z | 2024-11-01T12:26:35.698Z |
5337272 | 5337272 | 20241022094659_CJQgL | US002M | 2024-10-23T12:04:37.737Z | 2024-10-31T12:29:43.900Z |
5335987 | 5335987 | 20241022072520_2zx1d | US002M | 2024-10-23T12:01:00.110Z | 2024-10-31T12:29:38.203Z |
5329600 | 5329600 | 20241021103224_u3lmA | US002M | 2024-10-22T12:04:45.340Z | 2024-10-30T12:26:34.967Z |
5329423 | 5329423 | 20241021101533_jhzMH | US002M | 2024-10-22T12:04:10.764Z | 2024-10-30T12:26:34.617Z |
5329014 | 5329014 | 20241021092445_UGUed | US002M | 2024-10-22T12:03:06.555Z | 2024-10-30T12:26:33.671Z |
5328634 | 5328634 | 20241021082227_NNpV5 | US002M | 2024-10-22T12:02:03.751Z | 2024-10-30T12:26:32.642Z |
5328078 | 5328078 | 20241021063047_VHHN9 | US002M | 2024-10-22T12:00:19.819Z | 2024-10-30T12:26:31.226Z |
5324416 | 5324416 | 20241020094930_JE2Ta | US002M | 2024-10-21T12:02:46.535Z | 2024-10-29T12:26:28.730Z |
5324047 | 5324047 | 20241020082652_10B3t | US002M | 2024-10-21T12:01:32.548Z | 2024-10-29T12:26:27.981Z |
5323600 | 5323600 | 20241019051236_2FkwK | US002M | 2024-10-20T12:06:44.216Z | 2024-10-27T12:28:51.534Z |
5319328 | 5319328 | 20241018110138_b8hvq | US002M | 2024-10-19T12:01:52.734Z | 2024-10-27T12:28:47.385Z |
5308307 | 5308307 | 20241014092301_yU3pR | US002M | 2024-10-16T12:03:27.248Z | 2024-10-23T12:24:14.736Z |
5304621 | 5304621 | 20241013105351_zLF6S | US002M | 2024-10-15T12:02:18.355Z | 2024-10-22T12:24:19.933Z |
5304524 | 5304524 | 20241013103010_kWCjB | US002M | 2024-10-15T12:01:58.573Z | 2024-10-22T12:24:18.905Z |
5304471 | 5304471 | 20241013101726_vdO9f | US002M | 2024-10-15T12:01:52.142Z | 2024-10-22T12:24:18.469Z |
5296013 | 5296013 | 20241013094207_qo7I3 | US002M | 2024-10-14T12:04:00.093Z | 2024-10-22T12:24:16.822Z |
5295648 | 5295648 | 20241013083811_OFOTA | US002M | 2024-10-14T12:03:00.901Z | 2024-10-22T12:24:13.885Z |
5295262 | 5295262 | 20241013070614_7y5d0 | US002M | 2024-10-14T12:01:44.159Z | 2024-10-22T12:24:10.377Z |
5277788 | 5277788 | 20241011084920_a5RD5 | US002M | 2024-10-12T12:04:27.168Z | 2024-10-20T12:23:33.620Z |
5277562 | 5277562 | 20241011081551_L2cvO | US002M | 2024-10-12T12:03:43.561Z | 2024-10-20T12:23:29.437Z |
5277236 | 5277236 | 20241011065513_OakzT | US002M | 2024-10-12T12:02:55.329Z | 2024-10-20T12:23:23.433Z |
5275363 | 5275363 | 20241010015904_sSMml | US002M | 2024-10-11T12:15:44.711Z | 2024-10-18T12:22:16.699Z |
5269244 | 5269244 | 20241010045138_2xCjj | US002M | 2024-10-11T12:01:02.948Z | 2024-10-19T12:26:48.319Z |
5269081 | 5269081 | 20241010041259_5rbvb | US002M | 2024-10-11T12:00:27.247Z | 2024-10-19T12:26:46.640Z |
5256584 | 5256584 | 20241008072208_BZvIN | US002M | 2024-10-09T12:03:20.554Z | 2024-10-17T12:19:56.896Z |
5255337 | 5255337 | 20241008041026_rXJUI | US002M | 2024-10-09T12:01:02.443Z | 2024-10-17T12:19:51.776Z |
5254325 | 5254325 | 20241007020202_WsKZS | US002M | 2024-10-08T12:14:18.512Z | 2024-10-15T12:29:14.825Z |
5249924 | 5249924 | 20241007105348_lnpwI | US002M | 2024-10-08T12:06:06.615Z | 2024-10-16T12:21:06.378Z |
5248863 | 5248863 | 20241007065723_YLjDl | US002M | 2024-10-08T12:03:32.061Z | 2024-10-16T12:21:02.137Z |
5248058 | 5248058 | 20241007035133_3VfhB | US002M | 2024-10-08T12:01:28.821Z | 2024-10-16T12:20:58.037Z |
5241467 | 5241467 | 20241005105221_Cos8T | US002M | 2024-10-07T12:10:38.909Z | 2024-10-14T12:24:26.506Z |
5241463 | 5241463 | 20241005105142_05N9X | US002M | 2024-10-07T12:10:38.498Z | 2024-10-14T12:24:26.491Z |
5241305 | 5241305 | 20241005102358_XpZ2H | US002M | 2024-10-07T12:10:10.969Z | 2024-10-14T12:24:26.032Z |
5241023 | 5241023 | 20241005091757_RQ1Ed | US002M | 2024-10-07T12:09:39.382Z | 2024-10-14T12:24:25.222Z |
5229659 | 5229659 | 20241004101813_6n7L1 | US002M | 2024-10-06T12:06:58.872Z | 2024-10-13T12:26:14.599Z |
5221631 | 5221631 | 20241003104428_q8Js0 | US002M | 2024-10-05T12:14:08.818Z | 2024-10-12T12:25:02.173Z |
5220671 | 5220671 | 20241003072020_72A1x | US002M | 2024-10-05T12:11:45.293Z | 2024-10-12T12:24:58.863Z |
5207285 | 5207285 | 20241002080724_OmfEI | US002M | 2024-10-03T12:05:15.188Z | 2024-10-11T12:23:25.401Z |
5196319 | 5196319 | 20240930102720_76nEU | US002M | 2024-10-01T12:07:08.427Z | 2024-10-09T12:29:05.443Z |
5195756 | 5195756 | 20240930082849_Cjl2c | US002M | 2024-10-01T12:05:34.177Z | 2024-10-09T12:29:03.846Z |
5195630 | 5195630 | 20240930080433_arqEu | US002M | 2024-10-01T12:05:17.913Z | 2024-10-09T12:29:03.524Z |
5169281 | 5169281 | 20240927010330_c3ykO | US002M | 2024-09-28T12:01:59.608Z | 2024-10-05T12:28:29.887Z |
5012133 | 5012133 | 20240904084315_lFtf8 | US002M | 2024-09-09T12:10:22.868Z | 2024-09-12T12:19:34.877Z |
5011738 | 5011738 | 20240904074542_GS3Rg | US002M | 2024-09-09T12:09:59.794Z | 2024-09-12T12:19:33.336Z |
5011477 | 5011477 | 20240904064930_P5lzs | US002M | 2024-09-09T12:09:42.751Z | 2024-09-12T12:19:32.016Z |
5011191 | 5011191 | 20240904052928_rAhIC | US002M | 2024-09-09T12:09:28.988Z | 2024-09-12T12:19:30.708Z |
5010737 | 5010737 | 20240904033940_mig8U | US002M | 2024-09-09T12:08:59.077Z | 2024-09-12T12:19:28.846Z |
5010204 | 5010204 | 20240904024226_eT1P2 | US002M | 2024-09-09T12:08:27.666Z | 2024-09-12T12:19:26.327Z |
5002673 | 5002673 | 20240904103053_635EA | US002M | 2024-09-09T12:00:55.179Z | 2024-09-13T12:19:41.611Z |
5002382 | 5002382 | 20240904094338_uUOTX | US002M | 2024-09-09T12:00:32.203Z | 2024-09-13T12:19:40.694Z |
5002256 | 5002256 | 20240904092838_BBTlm | US002M | 2024-09-09T12:00:19.116Z | 2024-09-13T12:19:40.163Z |
5001842 | 5001842 | 20240902065427_ROSYZ | US002M | 2024-09-08T12:16:59.917Z | 2024-09-10T12:19:34.848Z |
5001829 | 5001829 | 20240902065044_rU2IQ | US002M | 2024-09-08T12:16:59.219Z | 2024-09-10T12:19:34.815Z |
5001543 | 5001543 | 20240902052221_vHPCT | US002M | 2024-09-08T12:16:34.016Z | 2024-09-10T12:19:33.367Z |
5001057 | 5001057 | 20240902032545_rUb3Z | US002M | 2024-09-08T12:16:07.807Z | 2024-09-10T12:19:31.358Z |
5000892 | 5000892 | 20240902025946_Mj4fJ | US002M | 2024-09-08T12:16:01.391Z | 2024-09-10T12:19:30.418Z |
5000285 | 5000285 | 20240902015826_sk5wG | US002M | 2024-09-08T12:15:18.559Z | 2024-09-10T12:19:26.558Z |
4998802 | 4998802 | 20240903040148_v8NEr | US002M | 2024-09-08T12:08:05.976Z | 2024-09-11T12:21:14.958Z |
4993226 | 4993226 | 20240902100326_b1BjM | US002M | 2024-09-08T12:01:19.379Z | 2024-09-11T12:20:21.237Z |
4992942 | 4992942 | 20240902091736_RB6P6 | US002M | 2024-09-08T12:01:01.722Z | 2024-09-11T12:20:18.704Z |
4992930 | 4992930 | 20240902091548_StgYc | US002M | 2024-09-08T12:01:01.035Z | 2024-09-11T12:20:18.606Z |
4992299 | 4992299 | 20240901065957_XaF5Q | US002M | 2024-09-07T12:13:11.598Z | 2024-09-09T12:27:58.784Z |
4992277 | 4992277 | 20240901065540_fJQpz | US002M | 2024-09-07T12:13:09.825Z | 2024-09-09T12:27:58.318Z |
4992232 | 4992232 | 20240901063845_IfvRt | US002M | 2024-09-07T12:13:05.533Z | 2024-09-09T12:27:57.026Z |
4992157 | 4992157 | 20240901060411_Idm3D | US002M | 2024-09-07T12:12:57.746Z | 2024-09-09T12:27:50.413Z |
4992018 | 4992018 | 20240901050009_WkawC | US002M | 2024-09-07T12:12:50.086Z | 2024-09-09T12:27:40.959Z |
4992004 | 4992004 | 20240901045150_NIMvh | US002M | 2024-09-07T12:12:47.666Z | 2024-09-09T12:27:39.700Z |
4991963 | 4991963 | 20240901041212_SSATh | US002M | 2024-09-07T12:12:43.444Z | 2024-09-09T12:27:36.135Z |
4991093 | 4991093 | 20240901015736_OMrlV | US002M | 2024-09-07T12:11:33.910Z | 2024-09-09T12:26:59.820Z |
4984278 | 4984278 | 20240901094026_RmJ0M | US002M | 2024-09-07T12:01:39.769Z | 2024-09-10T12:19:05.013Z |
4984196 | 4984196 | 20240901092440_WpYLA | US002M | 2024-09-07T12:01:33.206Z | 2024-09-10T12:19:04.758Z |
4984154 | 4984154 | 20240901091611_b3JyJ | US002M | 2024-09-07T12:01:28.201Z | 2024-09-10T12:19:04.590Z |
4984107 | 4984107 | 20240901090632_BMa0a | US002M | 2024-09-07T12:01:21.928Z | 2024-09-10T12:19:04.473Z |
4984094 | 4984094 | 20240901090257_Ycv3j | US002M | 2024-09-07T12:01:21.075Z | 2024-09-10T12:19:04.441Z |
4983685 | 4983685 | 20240901074101_DkFge | US002M | 2024-09-07T12:00:37.166Z | 2024-09-10T12:19:02.354Z |
4983627 | 4983627 | 20240901071758_43wXR | US002M | 2024-09-07T12:00:27.281Z | 2024-09-10T12:19:02.144Z |
4958203 | 4958203 | 20240811100344_bHLNT | US002M | 2024-09-03T12:22:13.822Z | 2024-09-06T12:31:55.595Z |
4957958 | 4957958 | 20240811094116_3rN5q | US002M | 2024-09-03T12:21:57.657Z | 2024-09-06T12:31:45.711Z |
4957951 | 4957951 | 20240811094011_QOCth | US002M | 2024-09-03T12:21:57.318Z | 2024-09-06T12:31:45.490Z |
4957949 | 4957949 | 20240811093924_yH3Te | US002M | 2024-09-03T12:21:56.993Z | 2024-09-06T12:31:45.312Z |
4957935 | 4957935 | 20240811093737_N5EC8 | US002M | 2024-09-03T12:21:55.741Z | 2024-09-06T12:31:44.642Z |
4957884 | 4957884 | 20240811093302_d2PgL | US002M | 2024-09-03T12:21:50.898Z | 2024-09-06T12:31:41.588Z |
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);