participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
358 rows where station_code = "US002E" 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 |
---|---|---|---|---|---|
5117881 | 5117881 | 20240915073548_Tfm5o | US002E | 2024-09-18T12:08:04.705Z | 2024-09-19T12:19:18.716Z |
5117566 | 5117566 | 20240915053249_0CG9R | US002E | 2024-09-18T12:07:47.393Z | 2024-09-19T12:19:16.052Z |
5117561 | 5117561 | 20240915053022_CQd8M | US002E | 2024-09-18T12:07:47.140Z | 2024-09-19T12:19:15.984Z |
5117558 | 5117558 | 20240915052826_UmByb | US002E | 2024-09-18T12:07:46.940Z | 2024-09-19T12:19:15.962Z |
5108753 | 5108753 | 20240913072308_vM838 | US002E | 2024-09-17T12:14:04.613Z | 2024-09-19T12:20:50.642Z |
5106058 | 5106058 | 20240913030741_YcrrH | US002E | 2024-09-17T12:12:39.846Z | 2024-09-19T12:20:45.402Z |
5095247 | 5095247 | 20240912065220_rguJb | US002E | 2024-09-16T12:15:27.843Z | 2024-09-19T12:21:17.750Z |
5095117 | 5095117 | 20240912060039_oeBjk | US002E | 2024-09-16T12:15:15.329Z | 2024-09-19T12:21:17.300Z |
5055164 | 5055164 | 20240908070954_Rmcex | US002E | 2024-09-13T12:17:06.866Z | 2024-09-16T12:21:18.102Z |
5055037 | 5055037 | 20240908061807_JsuR5 | US002E | 2024-09-13T12:17:03.989Z | 2024-09-16T12:21:17.766Z |
5054921 | 5054921 | 20240908051017_Up5Ax | US002E | 2024-09-13T12:16:59.278Z | 2024-09-16T12:21:17.222Z |
5054855 | 5054855 | 20240908043139_mlOik | US002E | 2024-09-13T12:16:57.170Z | 2024-09-16T12:21:17.016Z |
5048667 | 5048667 | 20240909085031_6jlI4 | US002E | 2024-09-13T12:11:08.883Z | 2024-09-17T12:19:07.877Z |
5048087 | 5048087 | 20240909070113_35B9d | US002E | 2024-09-13T12:10:14.439Z | 2024-09-17T12:19:05.605Z |
5047983 | 5047983 | 20240909064647_UN3d7 | US002E | 2024-09-13T12:10:08.057Z | 2024-09-17T12:19:05.163Z |
5047898 | 5047898 | 20240909062152_3JA5r | US002E | 2024-09-13T12:09:56.143Z | 2024-09-17T12:19:04.926Z |
5047719 | 5047719 | 20240909053010_pT4t2 | US002E | 2024-09-13T12:09:35.609Z | 2024-09-17T12:19:04.103Z |
5046929 | 5046929 | 20240909015023_Cu2vs | US002E | 2024-09-13T12:07:58.098Z | 2024-09-17T12:19:00.614Z |
5040482 | 5040482 | 20240906042336_2qZav | US002E | 2024-09-12T12:16:12.677Z | 2024-09-14T12:23:09.448Z |
5026719 | 5026719 | 20240905045635_aE4en | US002E | 2024-09-11T12:13:00.019Z | 2024-09-13T12:19:59.507Z |
5021179 | 5021179 | 20240905045635_63Ri7 | US002E | 2024-09-10T12:15:20.001Z | 2024-09-10T12:16:55.325Z |
5012390 | 5012390 | 20240903062912_M83tH | US002E | 2024-09-09T12:17:50.395Z | 2024-09-11T12:21:17.548Z |
5011984 | 5011984 | 20240904082321_OY6aA | US002E | 2024-09-09T12:10:13.110Z | 2024-09-12T12:19:34.445Z |
5011779 | 5011779 | 20240904075129_87VZH | US002E | 2024-09-09T12:10:01.372Z | 2024-09-12T12:19:33.400Z |
5011263 | 5011263 | 20240904055603_wAAwA | US002E | 2024-09-09T12:09:32.380Z | 2024-09-12T12:19:31.104Z |
5003654 | 5003654 | 20240903092918_dGi3P | US002E | 2024-09-09T12:01:56.308Z | 2024-09-12T12:18:58.351Z |
5001099 | 5001099 | 20240902033222_ZP4CU | US002E | 2024-09-08T12:16:09.988Z | 2024-09-10T12:19:31.704Z |
5000917 | 5000917 | 20240902030152_MJnh9 | US002E | 2024-09-08T12:16:02.171Z | 2024-09-10T12:19:30.663Z |
4999141 | 4999141 | 20240903053040_SZXNL | US002E | 2024-09-08T12:08:31.214Z | 2024-09-11T12:21:16.588Z |
4956993 | 4956993 | 20240811080636_0fLLb | US002E | 2024-09-03T12:20:46.021Z | 2024-09-06T12:30:57.381Z |
4955283 | 4955283 | 20240811042226_4y7hY | US002E | 2024-09-03T12:19:04.371Z | 2024-09-06T12:29:30.494Z |
4954941 | 4954941 | 20240811031756_HGqfU | US002E | 2024-09-03T12:18:29.928Z | 2024-09-06T12:29:12.785Z |
4930723 | 4930723 | 20240810085317_E2fRB | US002E | 2024-08-31T12:23:50.420Z | 2024-09-02T12:30:24.300Z |
4930402 | 4930402 | 20240810080744_QOgN0 | US002E | 2024-08-31T12:23:27.884Z | 2024-09-02T12:30:11.677Z |
4929820 | 4929820 | 20240810062546_rw9lA | US002E | 2024-08-31T12:22:42.316Z | 2024-09-02T12:29:47.711Z |
4847830 | 4847830 | 20240805061022_7XYU9 | US002E | 2024-08-16T12:21:13.568Z | 2024-08-17T12:33:17.427Z |
4847669 | 4847669 | 20240805051133_ugSUr | US002E | 2024-08-16T12:21:05.435Z | 2024-08-17T12:33:10.739Z |
4847632 | 4847632 | 20240805045831_zml3r | US002E | 2024-08-16T12:21:03.560Z | 2024-08-17T12:33:09.495Z |
4838042 | 4838042 | 20240805082231_m3Ffy | US002E | 2024-08-16T12:01:46.914Z | 2024-08-19T12:15:32.593Z |
4835517 | 4835517 | 20240805014216_r997G | US002E | 2024-08-15T12:15:26.950Z | 2024-08-17T12:32:10.180Z |
4787300 | 4787300 | 20240802055918_sZvds | US002E | 2024-08-11T12:01:35.471Z | 2024-08-13T12:15:25.429Z |
4772281 | 4772281 | 20240801063746_Z33pl | US002E | 2024-08-07T12:03:04.709Z | 2024-08-11T12:11:21.917Z |
4722582 | 4722582 | 20240728072137_KBu8b | US002E | 2024-07-31T12:08:32.133Z | 2024-08-05T12:20:07.615Z |
4721520 | 4721520 | 20240728034840_V3ett | US002E | 2024-07-31T12:06:47.319Z | 2024-08-05T12:19:57.831Z |
4707843 | 4707843 | 20240727074028_dkQ0g | US002E | 2024-07-29T12:08:18.803Z | 2024-08-04T12:19:27.946Z |
4668873 | 4668873 | 20240719045934_rTNOx | US002E | 2024-07-20T12:05:10.165Z | 2024-07-27T12:17:20.345Z |
4665146 | 4665146 | 20240717080857_Z4csL | US002E | 2024-07-19T12:09:29.913Z | 2024-07-25T12:14:13.238Z |
4659039 | 4659039 | 20240716075050_kbbG7 | US002E | 2024-07-18T12:10:23.105Z | 2024-07-24T12:17:30.259Z |
4621593 | 4621593 | 20240712080951_zOEoI | US002E | 2024-07-14T12:01:22.497Z | 2024-07-21T12:13:17.091Z |
4621556 | 4621556 | 20240712080441_OmcT8 | US002E | 2024-07-14T12:01:15.620Z | 2024-07-21T12:13:16.551Z |
4621217 | 4621217 | 20240712063626_OYt16 | US002E | 2024-07-14T12:00:38.673Z | 2024-07-21T12:13:14.662Z |
4605368 | 4605368 | 20240709075240_xWTnI | US002E | 2024-07-12T12:03:39.518Z | 2024-07-18T12:16:34.600Z |
4597911 | 4597911 | 20240708070607_v8dAz | US002E | 2024-07-11T12:03:41.739Z | 2024-07-16T12:09:14.224Z |
4597286 | 4597286 | 20240708033509_cbJnN | US002E | 2024-07-11T12:02:08.984Z | 2024-07-16T12:09:10.998Z |
4539360 | 4539360 | 20240703081135_Ag2P4 | US002E | 2024-07-04T12:03:32.080Z | 2024-07-11T12:14:42.035Z |
4538713 | 4538713 | 20240703040244_KuXN1 | US002E | 2024-07-04T12:02:45.310Z | 2024-07-11T12:14:40.140Z |
4535720 | 4535720 | 20240702075004_HekUM | US002E | 2024-07-03T12:03:42.210Z | 2024-07-10T12:15:31.219Z |
4535240 | 4535240 | 20240702052937_l5HJj | US002E | 2024-07-03T12:02:44.008Z | 2024-07-10T12:15:28.665Z |
4535206 | 4535206 | 20240702052017_hqTw6 | US002E | 2024-07-03T12:02:41.447Z | 2024-07-10T12:15:28.569Z |
4531980 | 4531980 | 20240701031033_d4AZv | US002E | 2024-07-02T12:03:47.892Z | 2024-07-09T12:08:06.262Z |
4501981 | 4501981 | 20240625072804_E3f9w | US002E | 2024-06-26T12:06:13.687Z | 2024-07-03T12:13:22.189Z |
4501791 | 4501791 | 20240625051129_mSQUK | US002E | 2024-06-26T12:05:44.923Z | 2024-07-03T12:13:20.369Z |
4501629 | 4501629 | 20240625020829_lensQ | US002E | 2024-06-26T12:05:30.399Z | 2024-07-03T12:13:19.432Z |
4485689 | 4485689 | 20240619032835_QSOdk | US002E | 2024-06-21T12:01:11.137Z | 2024-06-28T12:09:24.481Z |
4471781 | 4471781 | 20240616024846_m37dV | US002E | 2024-06-18T12:00:52.777Z | 2024-06-24T12:10:59.840Z |
4464826 | 4464826 | 20240615072749_BvrNZ | US002E | 2024-06-16T12:03:12.912Z | 2024-06-23T12:11:55.455Z |
4464614 | 4464614 | 20240615061437_ni9CO | US002E | 2024-06-16T12:02:46.105Z | 2024-06-23T12:11:51.798Z |
4460611 | 4460611 | 20240614033151_5ryXk | US002E | 2024-06-15T12:02:23.594Z | 2024-06-22T12:16:23.744Z |
4450102 | 4450102 | 20240612064015_62D8p | US002E | 2024-06-13T12:02:20.578Z | 2024-06-20T12:11:57.190Z |
4446638 | 4446638 | 20240611073053_CRErA | US002E | 2024-06-12T12:03:08.580Z | 2024-06-19T12:13:35.938Z |
4402974 | 4402974 | 20240601032048_ZPZ9k | US002E | 2024-06-03T12:10:40.882Z | 2024-06-09T12:06:02.222Z |
4402954 | 4402954 | 20240601023455_64hRg | US002E | 2024-06-03T12:10:38.413Z | 2024-06-09T12:06:02.104Z |
4384108 | 4384108 | 20240528071537_Kdajx | US002E | 2024-05-29T12:00:49.935Z | 2024-06-06T12:14:19.749Z |
4276014 | 4276014 | 20240503054724_VvVV3 | US002E | 2024-05-05T12:12:13.052Z | 2024-05-11T12:28:32.839Z |
4275886 | 4275886 | 20240503035735_7PEo1 | US002E | 2024-05-05T12:12:02.245Z | 2024-05-11T12:28:25.430Z |
4272032 | 4272032 | 20240502050930_K8Fs6 | US002E | 2024-05-04T12:13:27.817Z | 2024-05-10T12:23:59.577Z |
4258457 | 4258457 | 20240430073732_wfb2B | US002E | 2024-05-02T12:01:30.996Z | 2024-05-09T12:20:55.200Z |
4258441 | 4258441 | 20240430073517_T8u9u | US002E | 2024-05-02T12:01:26.323Z | 2024-05-09T12:20:55.120Z |
4113347 | 4113347 | 20240326064002_Riv3K | US002E | 2024-03-27T12:03:01.779Z | 2024-04-03T12:18:08.779Z |
4105417 | 4105417 | 20240322091103_qJCme | US002E | 2024-03-23T12:08:42.117Z | 2024-03-30T12:18:19.595Z |
4105308 | 4105308 | 20240322074752_vJSXS | US002E | 2024-03-23T12:08:22.330Z | 2024-03-30T12:18:14.725Z |
4094614 | 4094614 | 20240319042445_UI2Ug | US002E | 2024-03-21T12:10:02.951Z | 2024-03-27T12:19:19.145Z |
4078567 | 4078567 | 20240316081320_tqzlk | US002E | 2024-03-17T12:09:39.674Z | 2024-03-24T12:20:58.997Z |
4072385 | 4072385 | 20240314084028_UNsot | US002E | 2024-03-16T12:12:40.530Z | 2024-03-22T12:17:44.819Z |
4072366 | 4072366 | 20240314083346_ul2Dk | US002E | 2024-03-16T12:12:36.814Z | 2024-03-22T12:17:44.688Z |
4072063 | 4072063 | 20240314045942_v7SIa | US002E | 2024-03-16T12:11:53.658Z | 2024-03-22T12:17:40.026Z |
4026208 | 4026208 | 20240304033711_5GU6Z | US002E | 2024-03-05T14:08:01.317Z | 2024-03-12T12:15:30.860Z |
4013191 | 4013191 | 20240301030712_ij43I | US002E | 2024-03-02T14:08:25.070Z | 2024-03-09T14:17:47.394Z |
4012517 | 4012517 | 20240301010722_7reaq | US002E | 2024-03-02T14:07:29.632Z | 2024-03-09T14:17:44.993Z |
4002652 | 4002652 | 20240225094119_MyN8e | US002E | 2024-02-26T14:03:19.261Z | 2024-03-04T14:19:15.350Z |
3992383 | 3992383 | 20240220010034_wJo8d | US002E | 2024-02-21T14:06:08.462Z | 2024-02-28T14:14:28.724Z |
3986052 | 3986052 | 20240218043105_XLKt4 | US002E | 2024-02-19T14:07:23.777Z | 2024-02-26T14:17:12.615Z |
3976632 | 3976632 | 20240216073334_YJ7G9 | US002E | 2024-02-17T14:08:33.198Z | 2024-02-24T14:24:04.363Z |
3971866 | 3971866 | 20240215074131_i6gv3 | US002E | 2024-02-16T14:07:30.836Z | 2024-02-23T14:21:17.033Z |
3971744 | 3971744 | 20240215065817_mIlsO | US002E | 2024-02-16T14:07:17.985Z | 2024-02-23T14:21:14.607Z |
3927075 | 3927075 | 20240206080929_ZUQIc | US002E | 2024-02-07T14:06:15.650Z | 2024-02-14T14:19:52.046Z |
3923039 | 3923039 | 20240205094043_ShkHA | US002E | 2024-02-06T14:08:32.241Z | 2024-02-13T14:27:37.188Z |
3922294 | 3922294 | 20240205064157_TPUl5 | US002E | 2024-02-06T14:07:00.138Z | 2024-02-13T14:27:19.653Z |
3916760 | 3916760 | 20240204081129_bmkg6 | US002E | 2024-02-05T14:04:23.475Z | 2024-02-12T14:23:18.264Z |
3916542 | 3916542 | 20240204055226_QBop2 | US002E | 2024-02-05T14:03:46.982Z | 2024-02-12T14:23:14.517Z |
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);