participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,179 rows where station_code = "UK008D" 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 |
---|---|---|---|---|---|
5124885 | 5124885 | 20240917223523_WW6Ik | UK008D | 2024-09-19T12:01:44.003Z | 2024-09-19T12:06:41.946Z |
5122031 | 5122031 | 20240914042820_mJEfX | UK008D | 2024-09-18T12:11:05.022Z | 2024-09-19T12:20:02.705Z |
5121894 | 5121894 | 20240914042027_UwaLG | UK008D | 2024-09-18T12:11:02.834Z | 2024-09-19T12:20:02.482Z |
5121205 | 5121205 | 20240914035523_kP3a1 | UK008D | 2024-09-18T12:10:52.371Z | 2024-09-19T12:20:01.491Z |
5121013 | 5121013 | 20240914034732_m2Oyn | UK008D | 2024-09-18T12:10:49.398Z | 2024-09-19T12:20:01.160Z |
5119966 | 5119966 | 20240914025452_2jk3k | UK008D | 2024-09-18T12:10:30.091Z | 2024-09-19T12:19:59.202Z |
5119872 | 5119872 | 20240914025122_ie63A | UK008D | 2024-09-18T12:10:28.275Z | 2024-09-19T12:19:59.033Z |
5117167 | 5117167 | 20240915040711_ETWrb | UK008D | 2024-09-18T12:07:34.310Z | 2024-09-19T12:19:13.674Z |
5115343 | 5115343 | 20240915023356_pxOrG | UK008D | 2024-09-18T12:06:11.611Z | 2024-09-19T12:19:04.061Z |
5114638 | 5114638 | 20240915015231_vgB4I | UK008D | 2024-09-18T12:05:26.189Z | 2024-09-19T12:18:59.091Z |
5107897 | 5107897 | 20240913041400_b8zTH | UK008D | 2024-09-17T12:13:25.507Z | 2024-09-19T12:20:47.630Z |
5107564 | 5107564 | 20240913040104_HZK8i | UK008D | 2024-09-17T12:13:17.040Z | 2024-09-19T12:20:47.222Z |
5107185 | 5107185 | 20240913034632_ZaTPh | UK008D | 2024-09-17T12:13:10.502Z | 2024-09-19T12:20:46.899Z |
5104731 | 5104731 | 20240913021954_cot1K | UK008D | 2024-09-17T12:11:43.630Z | 2024-09-19T12:20:42.836Z |
5100564 | 5100564 | 20240913233108_ZjsC2 | UK008D | 2024-09-17T12:04:38.941Z | 2024-09-19T12:19:48.124Z |
5100165 | 5100165 | 20240913225901_JMOgI | UK008D | 2024-09-17T12:04:05.388Z | 2024-09-19T12:19:47.061Z |
5099956 | 5099956 | 20240913222709_wt2pr | UK008D | 2024-09-17T12:03:46.124Z | 2024-09-19T12:19:46.608Z |
5097634 | 5097634 | 20240913005726_z907T | UK008D | 2024-09-16T12:17:13.813Z | 2024-09-19T12:20:38.855Z |
5097525 | 5097525 | 20240913005218_90IdC | UK008D | 2024-09-16T12:17:13.224Z | 2024-09-19T12:20:38.685Z |
5094274 | 5094274 | 20240912035448_IvS3R | UK008D | 2024-09-16T12:14:40.288Z | 2024-09-19T12:21:16.047Z |
5092349 | 5092349 | 20240912024219_cpqog | UK008D | 2024-09-16T12:13:49.020Z | 2024-09-19T12:21:13.891Z |
5092208 | 5092208 | 20240912024005_69ypU | UK008D | 2024-09-16T12:13:43.783Z | 2024-09-19T12:21:13.699Z |
5092030 | 5092030 | 20240912023519_8Kpq9 | UK008D | 2024-09-16T12:13:38.402Z | 2024-09-19T12:21:13.603Z |
5090483 | 5090483 | 20240912012733_SX3w8 | UK008D | 2024-09-16T12:12:21.535Z | 2024-09-19T12:21:11.339Z |
5088434 | 5088434 | 20240913001113_JxY7y | UK008D | 2024-09-16T12:08:00.234Z | 2024-09-19T12:20:36.860Z |
5087805 | 5087805 | 20240912234445_WPLRd | UK008D | 2024-09-16T12:07:28.300Z | 2024-09-19T12:20:35.679Z |
5076428 | 5076428 | 20240910233551_MCS2b | UK008D | 2024-09-15T12:13:34.266Z | 2024-09-19T12:21:37.208Z |
5073505 | 5073505 | 20240911212759_pF7K3 | UK008D | 2024-09-15T12:07:13.405Z | 2024-09-19T12:21:05.832Z |
5065264 | 5065264 | 20240910033101_2i4gq | UK008D | 2024-09-14T12:16:51.117Z | 2024-09-18T12:15:18.852Z |
5065231 | 5065231 | 20240910032358_Fqetm | UK008D | 2024-09-14T12:16:44.758Z | 2024-09-18T12:15:18.782Z |
5064845 | 5064845 | 20240910021541_FOdD4 | UK008D | 2024-09-14T12:16:05.890Z | 2024-09-18T12:15:17.504Z |
5064118 | 5064118 | 20240910000549_H7UPz | UK008D | 2024-09-14T12:14:56.844Z | 2024-09-18T12:15:15.551Z |
5063973 | 5063973 | 20240909231000_eYKXC | UK008D | 2024-09-14T12:14:34.624Z | 2024-09-18T12:15:15.009Z |
5063560 | 5063560 | 20240909214443_Khijd | UK008D | 2024-09-14T12:14:06.789Z | 2024-09-18T12:15:14.175Z |
5063535 | 5063535 | 20240909214018_1f5Mr | UK008D | 2024-09-14T12:14:05.555Z | 2024-09-18T12:15:14.144Z |
5019121 | 5019121 | 20240904215326_DzEbh | UK008D | 2024-09-10T12:12:08.938Z | 2024-09-13T12:19:50.599Z |
5009678 | 5009678 | 20240904014917_g2bf1 | UK008D | 2024-09-09T12:07:55.189Z | 2024-09-12T12:19:23.990Z |
5008629 | 5008629 | 20240904000400_11IGC | UK008D | 2024-09-09T12:06:56.124Z | 2024-09-12T12:19:18.474Z |
5008586 | 5008586 | 20240903235856_YyQe0 | UK008D | 2024-09-09T12:06:54.318Z | 2024-09-12T12:19:18.221Z |
4989859 | 4989859 | 20240831224733_LpuLh | UK008D | 2024-09-07T12:09:43.677Z | 2024-09-09T12:26:01.471Z |
4982411 | 4982411 | 20240812003325_nDtLD | UK008D | 2024-09-06T12:14:50.625Z | 2024-09-06T12:14:50.625Z |
4978367 | 4978367 | 20240811235019_8IXut | UK008D | 2024-09-06T12:12:32.989Z | 2024-09-06T12:12:32.989Z |
4977205 | 4977205 | 20240811233718_vtsNl | UK008D | 2024-09-06T12:12:06.964Z | 2024-09-06T12:12:06.964Z |
4977094 | 4977094 | 20240811233607_kn7Mk | UK008D | 2024-09-06T12:12:03.688Z | 2024-09-06T12:12:03.688Z |
4974400 | 4974400 | 20240811230647_7cLy8 | UK008D | 2024-09-05T12:11:24.098Z | 2024-09-06T12:10:26.326Z |
4973990 | 4973990 | 20240811230219_VoUDC | UK008D | 2024-09-05T12:11:15.762Z | 2024-09-06T12:10:14.318Z |
4971359 | 4971359 | 20240811223432_HuxF3 | UK008D | 2024-09-05T12:09:43.358Z | 2024-09-06T12:08:52.499Z |
4967828 | 4967828 | 20240811215037_QVULk | UK008D | 2024-09-05T12:07:51.590Z | 2024-09-06T12:07:11.976Z |
4967788 | 4967788 | 20240811214951_d6lrg | UK008D | 2024-09-05T12:07:48.637Z | 2024-09-06T12:07:09.057Z |
4929289 | 4929289 | 20240810032401_CkD9t | UK008D | 2024-08-31T12:21:58.280Z | 2024-09-02T12:29:30.886Z |
4928004 | 4928004 | 20240810022800_ZCdJe | UK008D | 2024-08-31T12:21:09.035Z | 2024-09-02T12:28:57.740Z |
4926675 | 4926675 | 20240810015444_dPcSI | UK008D | 2024-08-31T12:19:49.896Z | 2024-09-02T12:28:00.480Z |
4919844 | 4919844 | 20240810001947_CkBHB | UK008D | 2024-08-30T12:13:01.367Z | 2024-09-02T12:26:03.784Z |
4834638 | 4834638 | 20240805010806_a6ui1 | UK008D | 2024-08-15T12:14:49.854Z | 2024-08-17T12:31:59.946Z |
4833801 | 4833801 | 20240805003221_LF3Uh | UK008D | 2024-08-15T12:14:10.978Z | 2024-08-17T12:31:45.251Z |
4832687 | 4832687 | 20240804234705_Hi0JQ | UK008D | 2024-08-15T12:13:09.453Z | 2024-08-17T12:31:12.666Z |
4831778 | 4831778 | 20240804225802_ewWc7 | UK008D | 2024-08-15T12:12:07.614Z | 2024-08-17T12:30:43.441Z |
4796993 | 4796993 | 20240802024517_RWCIu | UK008D | 2024-08-11T12:16:16.242Z | 2024-08-11T12:16:16.242Z |
4796687 | 4796687 | 20240802022308_ZD4qP | UK008D | 2024-08-11T12:16:09.716Z | 2024-08-11T12:16:09.716Z |
4748377 | 4748377 | 20240729221528_L80On | UK008D | 2024-08-04T12:15:14.413Z | 2024-08-06T12:15:24.699Z |
4745826 | 4745826 | 20240730023704_9vDgI | UK008D | 2024-08-04T12:08:00.484Z | 2024-08-08T12:18:21.665Z |
4744909 | 4744909 | 20240730020350_qoQrD | UK008D | 2024-08-04T12:06:57.647Z | 2024-08-08T12:18:03.014Z |
4744277 | 4744277 | 20240730014332_u2v22 | UK008D | 2024-08-04T12:06:02.493Z | 2024-08-08T12:17:50.995Z |
4742037 | 4742037 | 20240730004258_U5WK1 | UK008D | 2024-08-04T12:02:29.568Z | 2024-08-08T12:16:54.619Z |
4741336 | 4741336 | 20240730002233_DymhI | UK008D | 2024-08-04T12:01:14.851Z | 2024-08-08T12:16:36.556Z |
4735571 | 4735571 | 20240729021943_p8jX2 | UK008D | 2024-08-01T12:05:11.135Z | 2024-08-06T12:14:52.948Z |
4731241 | 4731241 | 20240729002936_DE03f | UK008D | 2024-08-01T12:02:08.278Z | 2024-08-06T12:14:39.826Z |
4730943 | 4730943 | 20240729002402_22UBv | UK008D | 2024-08-01T12:01:57.420Z | 2024-08-06T12:14:39.076Z |
4730255 | 4730255 | 20240729000305_iyOtF | UK008D | 2024-08-01T12:01:08.627Z | 2024-08-06T12:14:35.970Z |
4721423 | 4721423 | 20240728031300_tcSx1 | UK008D | 2024-07-31T12:06:39.526Z | 2024-08-05T12:19:56.820Z |
4721021 | 4721021 | 20240728234414_hOVh9 | UK008D | 2024-07-31T12:01:58.353Z | 2024-08-06T12:14:34.323Z |
4717853 | 4717853 | 20240728021606_RHLsH | UK008D | 2024-07-30T12:08:56.198Z | 2024-08-05T12:19:53.740Z |
4716970 | 4716970 | 20240728015050_y4BgB | UK008D | 2024-07-30T12:08:13.797Z | 2024-08-05T12:19:50.861Z |
4716955 | 4716955 | 20240728015049_Ov6o9 | UK008D | 2024-07-30T12:08:13.584Z | 2024-08-05T12:19:50.840Z |
4705133 | 4705133 | 20240727224807_gWbai | UK008D | 2024-07-29T12:01:25.331Z | 2024-08-05T12:19:24.351Z |
4704545 | 4704545 | 20240727220907_JtPjd | UK008D | 2024-07-29T12:00:32.420Z | 2024-08-05T12:19:17.273Z |
4704355 | 4704355 | 20240727215918_rWX2O | UK008D | 2024-07-29T12:00:18.192Z | 2024-08-05T12:19:15.522Z |
4696192 | 4696192 | 20240726224816_qbydg | UK008D | 2024-07-28T12:02:30.792Z | 2024-08-04T12:19:09.125Z |
4691610 | 4691610 | 20240726021425_6ITIo | UK008D | 2024-07-27T12:05:53.457Z | 2024-08-03T12:21:22.363Z |
4689770 | 4689770 | 20240725222336_AxXyK | UK008D | 2024-07-27T12:01:39.505Z | 2024-08-03T12:21:03.768Z |
4680721 | 4680721 | 20240723235633_Ly2RN | UK008D | 2024-07-25T12:02:42.986Z | 2024-08-01T12:12:02.314Z |
4675701 | 4675701 | 20240722001717_JCXHQ | UK008D | 2024-07-23T12:01:35.357Z | 2024-07-30T12:18:07.690Z |
4675657 | 4675657 | 20240722001109_3DpoJ | UK008D | 2024-07-23T12:01:32.560Z | 2024-07-30T12:18:07.530Z |
4668265 | 4668265 | 20240719013720_0O4f3 | UK008D | 2024-07-20T12:04:25.667Z | 2024-07-27T12:17:16.535Z |
4668062 | 4668062 | 20240719012622_2mN6p | UK008D | 2024-07-20T12:04:15.314Z | 2024-07-27T12:17:14.302Z |
4667962 | 4667962 | 20240719011906_4teLa | UK008D | 2024-07-20T12:04:10.226Z | 2024-07-27T12:17:13.967Z |
4666361 | 4666361 | 20240718232957_c7dDX | UK008D | 2024-07-20T12:02:18.137Z | 2024-07-27T12:17:01.623Z |
4648449 | 4648449 | 20240714234837_13Sl3 | UK008D | 2024-07-17T12:07:57.967Z | 2024-07-23T12:08:42.949Z |
4648085 | 4648085 | 20240714232538_8rr5v | UK008D | 2024-07-17T12:07:39.305Z | 2024-07-23T12:08:42.245Z |
4646898 | 4646898 | 20240714215032_F6xUD | UK008D | 2024-07-17T12:06:16.349Z | 2024-07-23T12:08:39.643Z |
4635098 | 4635098 | 20240713002226_xYzE9 | UK008D | 2024-07-15T12:07:08.135Z | 2024-07-21T12:13:32.090Z |
4620511 | 4620511 | 20240711015910_TqMOy | UK008D | 2024-07-13T12:09:19.311Z | 2024-07-19T12:13:44.313Z |
4620211 | 4620211 | 20240711012956_AmtEm | UK008D | 2024-07-13T12:09:08.179Z | 2024-07-19T12:13:43.135Z |
4620177 | 4620177 | 20240711012835_lkcuu | UK008D | 2024-07-13T12:09:07.598Z | 2024-07-19T12:13:43.107Z |
4620028 | 4620028 | 20240711011652_AYK2r | UK008D | 2024-07-13T12:09:01.124Z | 2024-07-19T12:13:42.677Z |
4619614 | 4619614 | 20240711003438_Qlbs7 | UK008D | 2024-07-13T12:08:42.903Z | 2024-07-19T12:13:41.594Z |
4597068 | 4597068 | 20240708021056_uca3n | UK008D | 2024-07-11T12:01:49.757Z | 2024-07-16T12:09:10.258Z |
4596993 | 4596993 | 20240708020602_JckvU | UK008D | 2024-07-11T12:01:39.728Z | 2024-07-16T12:09:10.189Z |
4596862 | 4596862 | 20240708015523_eBF31 | UK008D | 2024-07-11T12:01:27.533Z | 2024-07-16T12:09:09.946Z |
4596242 | 4596242 | 20240708012430_M4mmn | UK008D | 2024-07-11T12:00:50.523Z | 2024-07-16T12:09:08.725Z |
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);