participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
859 rows where station_code = "JP0001" 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 |
---|---|---|---|---|---|
5110376 | 5110376 | 20240913153948_V31Rk | JP0001 | 2024-09-17T12:15:07.728Z | 2024-09-19T12:20:56.923Z |
5110347 | 5110347 | 20240913152432_wfiC2 | JP0001 | 2024-09-17T12:15:06.265Z | 2024-09-19T12:20:56.771Z |
5110331 | 5110331 | 20240913151105_0W4jU | JP0001 | 2024-09-17T12:15:05.442Z | 2024-09-19T12:20:56.718Z |
5110317 | 5110317 | 20240913150037_A7OoZ | JP0001 | 2024-09-17T12:15:04.496Z | 2024-09-19T12:20:56.636Z |
5098319 | 5098319 | 20240913155330_gPwld | JP0001 | 2024-09-17T12:00:10.005Z | 2024-09-19T12:19:36.061Z |
5070593 | 5070593 | 20240911143650_iFEjA | JP0001 | 2024-09-15T12:00:22.484Z | 2024-09-19T12:20:59.354Z |
5062246 | 5062246 | 20240909170335_oZ8Sr | JP0001 | 2024-09-14T12:11:59.949Z | 2024-09-18T12:15:10.803Z |
5045758 | 5045758 | 20240908185925_a1zNf | JP0001 | 2024-09-13T12:04:53.233Z | 2024-09-17T12:18:57.231Z |
5045740 | 5045740 | 20240908184712_bs10H | JP0001 | 2024-09-13T12:04:50.386Z | 2024-09-17T12:18:57.190Z |
5045652 | 5045652 | 20240908173730_aYxSA | JP0001 | 2024-09-13T12:04:36.777Z | 2024-09-17T12:18:56.927Z |
5045181 | 5045181 | 20240908162903_T5ucW | JP0001 | 2024-09-13T12:03:38.100Z | 2024-09-17T12:18:56.019Z |
5038310 | 5038310 | 20240905191102_1H2fw | JP0001 | 2024-09-12T12:14:32.749Z | 2024-09-14T12:22:55.558Z |
5038093 | 5038093 | 20240905172246_5479Z | JP0001 | 2024-09-12T12:14:21.883Z | 2024-09-14T12:22:55.028Z |
5038074 | 5038074 | 20240905172129_ChqgE | JP0001 | 2024-09-12T12:14:21.322Z | 2024-09-14T12:22:55.011Z |
5037165 | 5037165 | 20240905151745_XT2rT | JP0001 | 2024-09-12T12:14:02.341Z | 2024-09-14T12:22:53.821Z |
5037142 | 5037142 | 20240905151446_6dMMD | JP0001 | 2024-09-12T12:14:01.654Z | 2024-09-14T12:22:53.800Z |
5036253 | 5036253 | 20240905130432_ot3bK | JP0001 | 2024-09-12T12:13:31.009Z | 2024-09-14T12:22:52.144Z |
5036104 | 5036104 | 20240905124217_CjgkV | JP0001 | 2024-09-12T12:13:23.831Z | 2024-09-14T12:22:51.879Z |
5024065 | 5024065 | 20240905191102_VgZ79 | JP0001 | 2024-09-11T12:02:30.370Z | 2024-09-11T12:16:31.918Z |
5023929 | 5023929 | 20240905172246_4rYJA | JP0001 | 2024-09-10T12:16:52.009Z | 2024-09-11T12:16:31.848Z |
5023911 | 5023911 | 20240905172129_ry0bz | JP0001 | 2024-09-10T12:16:51.644Z | 2024-09-11T12:16:31.840Z |
5023055 | 5023055 | 20240905151745_Eso57 | JP0001 | 2024-09-10T12:16:38.412Z | 2024-09-11T12:16:31.517Z |
5018625 | 5018625 | 20240904191424_eSxBE | JP0001 | 2024-09-10T12:11:00.941Z | 2024-09-13T12:19:48.356Z |
5016852 | 5016852 | 20240904150425_kKjMF | JP0001 | 2024-09-10T12:08:24.640Z | 2024-09-13T12:19:46.391Z |
5015427 | 5015427 | 20240905151446_dI4bp | JP0001 | 2024-09-10T12:05:16.440Z | 2024-09-11T12:16:31.505Z |
5014575 | 5014575 | 20240905130432_x9Ry3 | JP0001 | 2024-09-10T12:03:29.229Z | 2024-09-11T12:16:31.208Z |
5014424 | 5014424 | 20240905124217_2h4lt | JP0001 | 2024-09-10T12:03:07.247Z | 2024-09-11T12:16:31.153Z |
4659700 | 4659700 | 20240718162337_7Be3Q | JP0001 | 2024-07-19T12:00:35.844Z | 2024-07-27T12:16:47.926Z |
4610069 | 4610069 | 20240709171038_Yfth9 | JP0001 | 2024-07-12T12:06:11.965Z | 2024-07-18T12:16:49.882Z |
4601449 | 4601449 | 20240708173457_T7hFm | JP0001 | 2024-07-11T12:08:25.663Z | 2024-07-16T12:09:21.358Z |
4593477 | 4593477 | 20240707171520_Sx9MB | JP0001 | 2024-07-10T12:09:21.902Z | 2024-07-15T12:12:21.322Z |
4593378 | 4593378 | 20240707170638_VOqOB | JP0001 | 2024-07-10T12:09:17.040Z | 2024-07-15T12:12:21.273Z |
4592750 | 4592750 | 20240707161536_NilGt | JP0001 | 2024-07-10T12:09:02.746Z | 2024-07-15T12:12:20.791Z |
4592677 | 4592677 | 20240707160726_NFusb | JP0001 | 2024-07-10T12:08:58.721Z | 2024-07-15T12:12:20.754Z |
4493973 | 4493973 | 20240621180601_JyebX | JP0001 | 2024-06-23T12:02:08.516Z | 2024-06-30T12:09:37.321Z |
4484017 | 4484017 | 20240618182523_E1jFg | JP0001 | 2024-06-20T12:04:54.401Z | 2024-06-27T12:11:26.774Z |
4466349 | 4466349 | 20240614170158_YaJBv | JP0001 | 2024-06-16T12:07:01.500Z | 2024-06-22T12:16:35.148Z |
4466146 | 4466146 | 20240614155946_TPCN0 | JP0001 | 2024-06-16T12:06:41.683Z | 2024-06-22T12:16:34.080Z |
4465942 | 4465942 | 20240614145540_BdTTl | JP0001 | 2024-06-16T12:06:27.245Z | 2024-06-22T12:16:33.367Z |
4431472 | 4431472 | 20240607160532_jEqhU | JP0001 | 2024-06-09T12:00:37.133Z | 2024-06-16T12:13:53.222Z |
4339992 | 4339992 | 20240509180149_kBQz3 | JP0001 | 2024-05-19T12:06:08.153Z | 2024-05-21T12:09:01.443Z |
4339635 | 4339635 | 20240509174353_QQrz2 | JP0001 | 2024-05-19T12:05:50.022Z | 2024-05-21T12:08:48.096Z |
4339156 | 4339156 | 20240509172659_bPtyR | JP0001 | 2024-05-19T12:05:10.965Z | 2024-05-21T12:08:38.153Z |
4332261 | 4332261 | 20240509145338_vFFT1 | JP0001 | 2024-05-18T12:03:46.292Z | 2024-05-21T12:07:05.378Z |
4331025 | 4331025 | 20240509124812_SN9U1 | JP0001 | 2024-05-18T12:01:32.077Z | 2024-05-21T12:06:24.016Z |
4292903 | 4292903 | 20240504183210_cjNNp | JP0001 | 2024-05-08T12:06:33.337Z | 2024-05-13T12:10:30.689Z |
4292605 | 4292605 | 20240504175319_3BZFC | JP0001 | 2024-05-08T12:06:01.468Z | 2024-05-13T12:10:24.987Z |
4283052 | 4283052 | 20240503184735_ZABbH | JP0001 | 2024-05-06T12:11:13.669Z | 2024-05-12T12:18:50.337Z |
4282920 | 4282920 | 20240503183307_uYcfr | JP0001 | 2024-05-06T12:11:06.872Z | 2024-05-12T12:18:45.186Z |
4282784 | 4282784 | 20240503182053_bn7zs | JP0001 | 2024-05-06T12:10:55.538Z | 2024-05-12T12:18:39.137Z |
4198906 | 4198906 | 20240415173032_DZMJP | JP0001 | 2024-04-17T12:11:54.229Z | 2024-04-23T12:25:15.647Z |
4193337 | 4193337 | 20240414173034_YL2yB | JP0001 | 2024-04-16T12:12:44.648Z | 2024-04-22T12:22:58.972Z |
4173663 | 4173663 | 20240410160003_mkHMn | JP0001 | 2024-04-12T12:11:47.126Z | 2024-04-18T12:21:36.959Z |
4164810 | 4164810 | 20240409183141_suA14 | JP0001 | 2024-04-11T12:01:27.640Z | 2024-04-18T12:20:57.633Z |
4134700 | 4134700 | 20240401185142_hmDgQ | JP0001 | 2024-04-03T12:03:00.266Z | 2024-04-10T12:17:35.336Z |
4134361 | 4134361 | 20240401170616_hwkC6 | JP0001 | 2024-04-03T12:02:00.260Z | 2024-04-10T12:17:33.148Z |
4104376 | 4104376 | 20240321171554_Ld2l9 | JP0001 | 2024-03-23T12:05:32.692Z | 2024-03-30T12:17:51.176Z |
4104284 | 4104284 | 20240321165522_Ocuun | JP0001 | 2024-03-23T12:05:23.797Z | 2024-03-30T12:17:50.137Z |
4100012 | 4100012 | 20240320194458_hea5P | JP0001 | 2024-03-22T12:08:05.763Z | 2024-03-29T12:14:03.260Z |
4099969 | 4099969 | 20240320193709_htkD3 | JP0001 | 2024-03-22T12:07:58.583Z | 2024-03-29T12:14:02.212Z |
4099881 | 4099881 | 20240320190906_mPofJ | JP0001 | 2024-03-22T12:07:36.951Z | 2024-03-29T12:13:59.896Z |
4099642 | 4099642 | 20240320182300_2sQyV | JP0001 | 2024-03-22T12:07:17.439Z | 2024-03-29T12:13:54.586Z |
4099444 | 4099444 | 20240320173158_Mu4a2 | JP0001 | 2024-03-22T12:06:50.558Z | 2024-03-29T12:13:46.499Z |
4097998 | 4097998 | 20240320151155_GZSjo | JP0001 | 2024-03-22T12:04:06.930Z | 2024-03-29T12:12:46.597Z |
4097811 | 4097811 | 20240320145914_rtTUk | JP0001 | 2024-03-22T12:03:54.757Z | 2024-03-29T12:12:39.360Z |
4090269 | 4090269 | 20240318171618_NuK2P | JP0001 | 2024-03-20T12:04:59.859Z | 2024-03-27T12:19:04.066Z |
4089199 | 4089199 | 20240318133717_JAM7e | JP0001 | 2024-03-20T12:02:22.916Z | 2024-03-27T12:18:35.838Z |
4070635 | 4070635 | 20240314182541_Xuxto | JP0001 | 2024-03-16T12:04:57.878Z | 2024-03-23T12:25:34.716Z |
4069846 | 4069846 | 20240314145226_I4lmV | JP0001 | 2024-03-16T12:03:13.452Z | 2024-03-23T12:25:29.269Z |
4067363 | 4067363 | 20240313182450_teMNT | JP0001 | 2024-03-15T12:04:10.719Z | 2024-03-22T12:17:32.831Z |
4060509 | 4060509 | 20240310190920_qZbj5 | JP0001 | 2024-03-12T12:06:21.476Z | 2024-03-19T12:22:33.352Z |
4060476 | 4060476 | 20240310190310_9vmMP | JP0001 | 2024-03-12T12:06:18.502Z | 2024-03-19T12:22:32.957Z |
4060416 | 4060416 | 20240310183212_V3cwt | JP0001 | 2024-03-12T12:06:13.386Z | 2024-03-19T12:22:32.034Z |
4060175 | 4060175 | 20240310170121_Eyecl | JP0001 | 2024-03-12T12:05:35.547Z | 2024-03-19T12:22:29.436Z |
4060070 | 4060070 | 20240310162755_vFjm8 | JP0001 | 2024-03-12T12:05:24.783Z | 2024-03-19T12:22:28.292Z |
4060022 | 4060022 | 20240310161515_VWk01 | JP0001 | 2024-03-12T12:05:18.668Z | 2024-03-19T12:22:27.780Z |
4059752 | 4059752 | 20240310150244_Q8Kkd | JP0001 | 2024-03-12T12:04:37.238Z | 2024-03-19T12:22:24.684Z |
4059626 | 4059626 | 20240310142625_k3h3P | JP0001 | 2024-03-12T12:04:18.049Z | 2024-03-19T12:22:22.792Z |
4056342 | 4056342 | 20240309191508_sWB1X | JP0001 | 2024-03-11T12:07:59.985Z | 2024-03-18T12:19:53.320Z |
4055737 | 4055737 | 20240309173415_1ygea | JP0001 | 2024-03-11T12:07:01.979Z | 2024-03-18T12:19:48.666Z |
4055733 | 4055733 | 20240309173308_RRpei | JP0001 | 2024-03-11T12:07:01.454Z | 2024-03-18T12:19:48.589Z |
4054186 | 4054186 | 20240309152056_XWI1s | JP0001 | 2024-03-11T12:04:36.354Z | 2024-03-18T12:19:35.286Z |
4053985 | 4053985 | 20240309145405_FG1ZX | JP0001 | 2024-03-11T12:04:04.911Z | 2024-03-18T12:19:32.686Z |
4019239 | 4019239 | 20240303184643_LgWyo | JP0001 | 2024-03-04T14:03:08.173Z | 2024-03-12T12:15:12.659Z |
4019056 | 4019056 | 20240303164145_8W3k9 | JP0001 | 2024-03-04T14:02:48.425Z | 2024-03-12T12:15:11.828Z |
4016231 | 4016231 | 20240301191325_RuGDM | JP0001 | 2024-03-03T14:05:03.892Z | 2024-03-10T12:21:14.445Z |
4003694 | 4003694 | 20240227130021_EiEtZ | JP0001 | 2024-02-28T14:00:39.769Z | 2024-03-07T14:18:53.905Z |
4003671 | 4003671 | 20240227123452_alROq | JP0001 | 2024-02-28T14:00:33.142Z | 2024-03-07T14:18:53.677Z |
4003527 | 4003527 | 20240226102053_Nfo7g | JP0001 | 2024-02-27T14:03:06.983Z | 2024-03-05T14:18:55.945Z |
4002987 | 4002987 | 20240226184934_w9Suz | JP0001 | 2024-02-27T14:00:52.070Z | 2024-03-06T14:19:32.994Z |
4000666 | 4000666 | 20240223200208_c6U2c | JP0001 | 2024-02-25T14:01:29.832Z | 2024-03-03T14:17:22.676Z |
3964919 | 3964919 | 20240213194926_FaFnj | JP0001 | 2024-02-15T14:05:29.058Z | 2024-02-22T14:23:27.517Z |
3964824 | 3964824 | 20240213192122_1quBt | JP0001 | 2024-02-15T14:05:15.721Z | 2024-02-22T14:23:25.766Z |
3964785 | 3964785 | 20240213190612_5ts9a | JP0001 | 2024-02-15T14:05:03.937Z | 2024-02-22T14:23:24.318Z |
3964545 | 3964545 | 20240213180651_7kqUE | JP0001 | 2024-02-15T14:04:37.172Z | 2024-02-22T14:23:16.662Z |
3964361 | 3964361 | 20240213171927_XiMaX | JP0001 | 2024-02-15T14:04:03.687Z | 2024-02-22T14:23:10.977Z |
3961352 | 3961352 | 20240212124936_4uBrZ | JP0001 | 2024-02-14T14:14:48.228Z | 2024-02-20T14:26:45.309Z |
3957430 | 3957430 | 20240212195240_Op23C | JP0001 | 2024-02-14T14:05:29.900Z | 2024-02-21T14:20:23.296Z |
3957248 | 3957248 | 20240212192437_XJT4A | JP0001 | 2024-02-14T14:05:10.272Z | 2024-02-21T14:20:22.180Z |
3956786 | 3956786 | 20240212175523_2ELnW | JP0001 | 2024-02-14T14:04:04.812Z | 2024-02-21T14:20:18.532Z |
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);