participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,116 rows where station_code = "NZ0034" 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 |
---|---|---|---|---|---|
5109004 | 5109004 | 20240913082223_GAxKf | NZ0034 | 2024-09-17T12:14:24.828Z | 2024-09-18T12:13:20.783Z |
5096397 | 5096397 | 20240912104401_hW8Nw | NZ0034 | 2024-09-16T12:16:22.564Z | 2024-09-18T12:14:10.147Z |
5095819 | 5095819 | 20240912090855_4lC2y | NZ0034 | 2024-09-16T12:15:59.014Z | 2024-09-18T12:14:07.457Z |
5095738 | 5095738 | 20240912085052_kQ3vy | NZ0034 | 2024-09-16T12:15:55.326Z | 2024-09-18T12:14:07.134Z |
5095637 | 5095637 | 20240912083054_ws2un | NZ0034 | 2024-09-16T12:15:51.790Z | 2024-09-18T12:14:06.699Z |
5095548 | 5095548 | 20240912080200_rJn2s | NZ0034 | 2024-09-16T12:15:48.106Z | 2024-09-18T12:14:06.052Z |
5083550 | 5083550 | 20240911134705_K7AlT | NZ0034 | 2024-09-15T12:18:43.667Z | 2024-09-18T12:15:04.000Z |
5083511 | 5083511 | 20240911134004_CdvQH | NZ0034 | 2024-09-15T12:18:43.020Z | 2024-09-18T12:15:03.933Z |
5083490 | 5083490 | 20240911133150_AB6vw | NZ0034 | 2024-09-15T12:18:42.563Z | 2024-09-18T12:15:03.896Z |
5083482 | 5083482 | 20240911132906_xjoFJ | NZ0034 | 2024-09-15T12:18:42.466Z | 2024-09-18T12:15:03.873Z |
5083474 | 5083474 | 20240911132834_MzsC2 | NZ0034 | 2024-09-15T12:18:42.462Z | 2024-09-18T12:15:03.872Z |
5083414 | 5083414 | 20240911131335_ALqO2 | NZ0034 | 2024-09-15T12:18:41.690Z | 2024-09-18T12:15:03.755Z |
5083244 | 5083244 | 20240911123731_LlP9K | NZ0034 | 2024-09-15T12:18:37.552Z | 2024-09-18T12:15:02.898Z |
5083210 | 5083210 | 20240911122909_KZgZn | NZ0034 | 2024-09-15T12:18:37.018Z | 2024-09-18T12:15:02.798Z |
5083089 | 5083089 | 20240911115551_yq5dK | NZ0034 | 2024-09-15T12:18:35.243Z | 2024-09-18T12:15:02.427Z |
5082959 | 5082959 | 20240911113624_CbDIK | NZ0034 | 2024-09-15T12:18:31.762Z | 2024-09-18T12:15:01.910Z |
5082835 | 5082835 | 20240911111116_O71P6 | NZ0034 | 2024-09-15T12:18:26.996Z | 2024-09-18T12:15:01.256Z |
5082572 | 5082572 | 20240911102824_eOVIu | NZ0034 | 2024-09-15T12:18:20.317Z | 2024-09-18T12:14:59.750Z |
5082043 | 5082043 | 20240911091436_q7Kkp | NZ0034 | 2024-09-15T12:18:00.387Z | 2024-09-18T12:14:57.260Z |
5081550 | 5081550 | 20240911080015_Tuv96 | NZ0034 | 2024-09-15T12:17:37.686Z | 2024-09-18T12:14:54.293Z |
5081496 | 5081496 | 20240911075027_UN6fS | NZ0034 | 2024-09-15T12:17:35.853Z | 2024-09-18T12:14:53.971Z |
5071518 | 5071518 | 20240911171040_foMps | NZ0034 | 2024-09-15T12:02:46.646Z | 2024-09-18T12:13:39.039Z |
5071463 | 5071463 | 20240911165917_Vom0G | NZ0034 | 2024-09-15T12:02:37.806Z | 2024-09-18T12:13:38.935Z |
5071450 | 5071450 | 20240911165631_Hy6lg | NZ0034 | 2024-09-15T12:02:34.792Z | 2024-09-18T12:13:38.880Z |
5071444 | 5071444 | 20240911165630_LjdFW | NZ0034 | 2024-09-15T12:02:34.006Z | 2024-09-18T12:13:38.790Z |
5071403 | 5071403 | 20240911164607_7UQ5K | NZ0034 | 2024-09-15T12:02:28.239Z | 2024-09-18T12:13:38.702Z |
5071325 | 5071325 | 20240911163420_hWphc | NZ0034 | 2024-09-15T12:02:18.161Z | 2024-09-18T12:13:38.487Z |
5071314 | 5071314 | 20240911163231_cK4Yc | NZ0034 | 2024-09-15T12:02:16.811Z | 2024-09-18T12:13:38.418Z |
5071248 | 5071248 | 20240911162156_DYgfl | NZ0034 | 2024-09-15T12:02:00.888Z | 2024-09-18T12:13:38.265Z |
5071216 | 5071216 | 20240911161631_IHqUS | NZ0034 | 2024-09-15T12:01:56.001Z | 2024-09-18T12:13:38.134Z |
5071022 | 5071022 | 20240911154308_alCg1 | NZ0034 | 2024-09-15T12:01:22.949Z | 2024-09-18T12:13:37.323Z |
5070998 | 5070998 | 20240911154039_rRDJD | NZ0034 | 2024-09-15T12:01:20.000Z | 2024-09-18T12:13:37.208Z |
5070941 | 5070941 | 20240911153154_zgD2R | NZ0034 | 2024-09-15T12:01:12.031Z | 2024-09-18T12:13:37.000Z |
5070909 | 5070909 | 20240911152746_nohQ3 | NZ0034 | 2024-09-15T12:01:07.842Z | 2024-09-18T12:13:36.795Z |
5070871 | 5070871 | 20240911152132_3SP2E | NZ0034 | 2024-09-15T12:01:01.982Z | 2024-09-18T12:13:36.494Z |
5070826 | 5070826 | 20240911151413_8QFC6 | NZ0034 | 2024-09-15T12:00:57.699Z | 2024-09-18T12:13:36.270Z |
5070768 | 5070768 | 20240911150901_LCQib | NZ0034 | 2024-09-15T12:00:47.234Z | 2024-09-18T12:13:36.185Z |
5070649 | 5070649 | 20240911144601_7ro5l | NZ0034 | 2024-09-15T12:00:27.955Z | 2024-09-18T12:13:35.809Z |
5070643 | 5070643 | 20240911144545_j2d1Y | NZ0034 | 2024-09-15T12:00:27.633Z | 2024-09-18T12:13:35.807Z |
5070554 | 5070554 | 20240911143102_c3Yn2 | NZ0034 | 2024-09-15T12:00:17.834Z | 2024-09-18T12:13:35.571Z |
5069020 | 5069020 | 20240910132512_kXdwg | NZ0034 | 2024-09-14T12:19:24.098Z | 2024-09-18T12:15:27.011Z |
5068978 | 5068978 | 20240910131719_EAw3r | NZ0034 | 2024-09-14T12:19:23.443Z | 2024-09-18T12:15:26.942Z |
5068966 | 5068966 | 20240910131506_13zq8 | NZ0034 | 2024-09-14T12:19:23.387Z | 2024-09-18T12:15:26.919Z |
5068892 | 5068892 | 20240910125516_SFKTr | NZ0034 | 2024-09-14T12:19:22.599Z | 2024-09-18T12:15:26.785Z |
5068876 | 5068876 | 20240910125455_jIcVm | NZ0034 | 2024-09-14T12:19:22.542Z | 2024-09-18T12:15:26.781Z |
5068815 | 5068815 | 20240910123135_VxHJO | NZ0034 | 2024-09-14T12:19:21.714Z | 2024-09-18T12:15:26.707Z |
5068792 | 5068792 | 20240910122610_EI5rL | NZ0034 | 2024-09-14T12:19:21.520Z | 2024-09-18T12:15:26.683Z |
5068234 | 5068234 | 20240910111329_5lwcs | NZ0034 | 2024-09-14T12:19:11.131Z | 2024-09-18T12:15:25.786Z |
5067558 | 5067558 | 20240910094349_D7oW8 | NZ0034 | 2024-09-14T12:18:48.673Z | 2024-09-18T12:15:24.370Z |
5067156 | 5067156 | 20240910090038_2Q7mx | NZ0034 | 2024-09-14T12:18:33.970Z | 2024-09-18T12:15:23.494Z |
5067119 | 5067119 | 20240910085712_x3s7R | NZ0034 | 2024-09-14T12:18:32.691Z | 2024-09-18T12:15:23.446Z |
5066918 | 5066918 | 20240910083112_Q0eM8 | NZ0034 | 2024-09-14T12:18:19.287Z | 2024-09-18T12:15:22.974Z |
5066727 | 5066727 | 20240910081007_3k7D2 | NZ0034 | 2024-09-14T12:18:09.603Z | 2024-09-18T12:15:22.631Z |
5060987 | 5060987 | 20240909134150_0k2iL | NZ0034 | 2024-09-14T12:10:02.169Z | 2024-09-18T12:15:07.695Z |
5060975 | 5060975 | 20240909134035_cnsVD | NZ0034 | 2024-09-14T12:10:00.858Z | 2024-09-18T12:15:07.598Z |
5059006 | 5059006 | 20240910170733_rGGG4 | NZ0034 | 2024-09-14T12:05:05.744Z | 2024-09-18T12:14:31.043Z |
5058985 | 5058985 | 20240910170649_K38GN | NZ0034 | 2024-09-14T12:05:04.545Z | 2024-09-18T12:14:30.997Z |
5058959 | 5058959 | 20240910170356_wxc0N | NZ0034 | 2024-09-14T12:05:00.801Z | 2024-09-18T12:14:30.930Z |
5058741 | 5058741 | 20240910164034_t304T | NZ0034 | 2024-09-14T12:04:25.551Z | 2024-09-18T12:14:30.110Z |
5058481 | 5058481 | 20240910161512_8VgFO | NZ0034 | 2024-09-14T12:03:46.170Z | 2024-09-18T12:14:29.424Z |
5058341 | 5058341 | 20240910160539_Dfscx | NZ0034 | 2024-09-14T12:03:33.452Z | 2024-09-18T12:14:28.763Z |
5057945 | 5057945 | 20240910152853_lo4bu | NZ0034 | 2024-09-14T12:02:27.514Z | 2024-09-18T12:14:26.719Z |
5057800 | 5057800 | 20240910151523_YjHQH | NZ0034 | 2024-09-14T12:02:08.414Z | 2024-09-18T12:14:25.510Z |
5057666 | 5057666 | 20240910150205_oND23 | NZ0034 | 2024-09-14T12:01:41.400Z | 2024-09-18T12:14:24.343Z |
5057299 | 5057299 | 20240910141004_tSqgT | NZ0034 | 2024-09-14T12:00:47.316Z | 2024-09-18T12:14:21.793Z |
5057075 | 5057075 | 20240908120716_iG3ra | NZ0034 | 2024-09-13T12:17:44.428Z | 2024-09-16T12:21:28.736Z |
5057049 | 5057049 | 20240908120339_ny2w0 | NZ0034 | 2024-09-13T12:17:44.253Z | 2024-09-16T12:21:28.636Z |
5056947 | 5056947 | 20240908114456_2uKVm | NZ0034 | 2024-09-13T12:17:41.529Z | 2024-09-16T12:21:27.935Z |
5056905 | 5056905 | 20240908114023_5DLTz | NZ0034 | 2024-09-13T12:17:40.907Z | 2024-09-16T12:21:27.708Z |
5056777 | 5056777 | 20240908112316_yG2Do | NZ0034 | 2024-09-13T12:17:39.222Z | 2024-09-16T12:21:27.278Z |
5056286 | 5056286 | 20240908100701_jOhj2 | NZ0034 | 2024-09-13T12:17:29.574Z | 2024-09-16T12:21:24.181Z |
5056003 | 5056003 | 20240908093117_jQF04 | NZ0034 | 2024-09-13T12:17:26.560Z | 2024-09-16T12:21:22.999Z |
5055894 | 5055894 | 20240908091450_KtQA8 | NZ0034 | 2024-09-13T12:17:25.300Z | 2024-09-16T12:21:22.527Z |
5055747 | 5055747 | 20240908085303_toKsR | NZ0034 | 2024-09-13T12:17:21.318Z | 2024-09-16T12:21:21.842Z |
5055621 | 5055621 | 20240908082913_hoSV2 | NZ0034 | 2024-09-13T12:17:18.822Z | 2024-09-16T12:21:21.211Z |
5055201 | 5055201 | 20240908072053_a6J3i | NZ0034 | 2024-09-13T12:17:07.537Z | 2024-09-16T12:21:18.395Z |
5050005 | 5050005 | 20240909121837_z6sPA | NZ0034 | 2024-09-13T12:12:35.674Z | 2024-09-17T12:19:12.097Z |
5045620 | 5045620 | 20240908173214_a3Il3 | NZ0034 | 2024-09-13T12:04:27.578Z | 2024-09-17T12:18:56.871Z |
5045480 | 5045480 | 20240908171035_tork6 | NZ0034 | 2024-09-13T12:04:13.357Z | 2024-09-17T12:18:56.640Z |
5045141 | 5045141 | 20240908162521_jZlSi | NZ0034 | 2024-09-13T12:03:35.937Z | 2024-09-17T12:18:55.996Z |
5045108 | 5045108 | 20240908161945_aODSe | NZ0034 | 2024-09-13T12:03:33.499Z | 2024-09-17T12:18:55.917Z |
5045085 | 5045085 | 20240908161524_ZNumv | NZ0034 | 2024-09-13T12:03:31.933Z | 2024-09-17T12:18:55.905Z |
5045057 | 5045057 | 20240908161430_XEvyu | NZ0034 | 2024-09-13T12:03:29.528Z | 2024-09-17T12:18:55.747Z |
5045044 | 5045044 | 20240908161037_mw22C | NZ0034 | 2024-09-13T12:03:27.696Z | 2024-09-17T12:18:55.656Z |
5044981 | 5044981 | 20240908160059_2Dz69 | NZ0034 | 2024-09-13T12:03:21.316Z | 2024-09-17T12:18:55.574Z |
5044943 | 5044943 | 20240908155724_NgcjR | NZ0034 | 2024-09-13T12:03:14.830Z | 2024-09-17T12:18:55.454Z |
5044782 | 5044782 | 20240908154228_gIE25 | NZ0034 | 2024-09-13T12:02:55.853Z | 2024-09-17T12:18:55.016Z |
5044349 | 5044349 | 20240908144805_1nDnV | NZ0034 | 2024-09-13T12:02:01.310Z | 2024-09-17T12:18:54.122Z |
5044338 | 5044338 | 20240908144717_w4VYx | NZ0034 | 2024-09-13T12:01:58.917Z | 2024-09-17T12:18:54.113Z |
5044299 | 5044299 | 20240908144114_MGlbE | NZ0034 | 2024-09-13T12:01:52.936Z | 2024-09-17T12:18:54.033Z |
5043748 | 5043748 | 20240908125452_8fdSu | NZ0034 | 2024-09-13T12:00:32.711Z | 2024-09-17T12:18:52.798Z |
5043708 | 5043708 | 20240908124706_2HtbU | NZ0034 | 2024-09-13T12:00:28.129Z | 2024-09-17T12:18:52.714Z |
5043651 | 5043651 | 20240908123214_Zh52Z | NZ0034 | 2024-09-13T12:00:19.530Z | 2024-09-17T12:18:52.567Z |
5043628 | 5043628 | 20240908122720_FoHXp | NZ0034 | 2024-09-13T12:00:17.297Z | 2024-09-17T12:18:52.541Z |
5042189 | 5042189 | 20240906100850_gOwTC | NZ0034 | 2024-09-12T12:16:56.828Z | 2024-09-14T12:23:16.405Z |
5041794 | 5041794 | 20240906090621_vR3I3 | NZ0034 | 2024-09-12T12:16:48.589Z | 2024-09-14T12:23:14.572Z |
5041756 | 5041756 | 20240906085840_UW3vd | NZ0034 | 2024-09-12T12:16:48.064Z | 2024-09-14T12:23:14.475Z |
5041576 | 5041576 | 20240906083306_DRN89 | NZ0034 | 2024-09-12T12:16:44.587Z | 2024-09-14T12:23:13.958Z |
5041426 | 5041426 | 20240906081303_I4Y0c | NZ0034 | 2024-09-12T12:16:41.320Z | 2024-09-14T12:23:13.498Z |
5038089 | 5038089 | 20240905172243_UPpKH | NZ0034 | 2024-09-12T12:14:21.796Z | 2024-09-14T12:22:55.025Z |
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);