home / lesson_6

loan_performance

5,828 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: is_timely, date (date), approved_date (date), due_date (date), paid_date (date)

Link rowid ▼ user_id date credit_score is_approved approved_date due_date is_timely paid_date
1 1 47902 2020-02-07 00:00:00 773.5483815836553 1 2020-02-10 00:00:00 2020-03-11 00:00:00 0  
2 2 21172 2020-01-15 00:00:00 531.8884034668349 1 2020-01-17 00:00:00 2020-02-16 00:00:00 1 2020-02-16 00:00:00
3 3 89520 2020-02-21 00:00:00 764.0846873499006 1 2020-02-24 00:00:00 2020-03-25 00:00:00 0  
4 4 89903 2020-03-30 00:00:00 782.7727469632855 1 2020-04-01 00:00:00 2020-05-01 00:00:00 0  
5 5 1481 2020-03-25 00:00:00 659.5875826076604 1 2020-03-27 00:00:00 2020-04-26 00:00:00 1 2020-04-26 00:00:00
6 6 9017 2020-03-09 00:00:00 586.1829923500993 1 2020-03-10 00:00:00 2020-04-09 00:00:00 1 2020-04-09 00:00:00
7 7 38078 2020-03-07 00:00:00 661.617810155441 1 2020-03-08 00:00:00 2020-04-07 00:00:00 1 2020-04-07 00:00:00
8 8 40700 2020-02-22 00:00:00 702.1996821995108 1 2020-02-24 00:00:00 2020-03-25 00:00:00 0  
9 9 4209 2020-02-01 00:00:00 589.1576369078003 1 2020-02-04 00:00:00 2020-03-05 00:00:00 0 2020-03-13 00:00:00
10 10 96358 2020-03-30 00:00:00 611.9942386881241 1 2020-04-02 00:00:00 2020-05-02 00:00:00 0  
11 11 87421 2020-01-12 00:00:00 794.0555221326135 1 2020-01-14 00:00:00 2020-02-13 00:00:00 0 2020-02-22 00:00:00
12 12 42616 2020-01-13 00:00:00 586.533887340296 1 2020-01-15 00:00:00 2020-02-14 00:00:00 0 2020-02-19 00:00:00
13 13 67404 2020-03-04 00:00:00 548.068567186616 1 2020-03-07 00:00:00 2020-04-06 00:00:00 0  
14 14 29479 2020-02-28 00:00:00 591.5954267041675 1 2020-03-02 00:00:00 2020-04-01 00:00:00 0  
15 15 77213 2020-01-26 00:00:00 570.6708160301523 1 2020-01-27 00:00:00 2020-02-26 00:00:00 0  
16 16 87265 2020-03-20 00:00:00 665.3323424694925 1 2020-03-22 00:00:00 2020-04-21 00:00:00 1 2020-04-21 00:00:00
17 17 39330 2020-03-31 00:00:00 659.8654164424496 1 2020-04-03 00:00:00 2020-05-03 00:00:00 0 2020-05-11 00:00:00
18 18 75060 2020-03-07 00:00:00 500.4523336531536 1 2020-03-09 00:00:00 2020-04-08 00:00:00 1 2020-04-08 00:00:00
19 19 70049 2020-01-20 00:00:00 822.7353233642953 1 2020-01-23 00:00:00 2020-02-22 00:00:00 0  
20 20 95428 2020-01-31 00:00:00 818.965589696827 1 2020-02-01 00:00:00 2020-03-02 00:00:00 0 2020-03-13 00:00:00
21 21 43812 2020-01-12 00:00:00 689.6628758131038 1 2020-01-13 00:00:00 2020-02-12 00:00:00 1 2020-02-12 00:00:00
22 22 67885 2020-03-21 00:00:00 670.1953060797223 1 2020-03-22 00:00:00 2020-04-21 00:00:00 0  
23 23 76463 2020-01-04 00:00:00 575.3967334995037 1 2020-01-06 00:00:00 2020-02-05 00:00:00 0  
24 24 69934 2020-01-24 00:00:00 619.4973463656103 1 2020-01-26 00:00:00 2020-02-25 00:00:00 0  
25 25 33794 2020-01-16 00:00:00 634.7388761909851 1 2020-01-17 00:00:00 2020-02-16 00:00:00 0  
26 26 84288 2020-02-12 00:00:00 662.9143710356386 1 2020-02-15 00:00:00 2020-03-16 00:00:00 1 2020-03-16 00:00:00
27 27 5771 2020-01-13 00:00:00 730.5112442971335 1 2020-01-14 00:00:00 2020-02-13 00:00:00 1 2020-02-13 00:00:00
28 28 18027 2020-01-06 00:00:00 672.5189092872474 1 2020-01-09 00:00:00 2020-02-08 00:00:00 1 2020-02-08 00:00:00
29 29 39729 2020-03-10 00:00:00 678.6021629156062 1 2020-03-13 00:00:00 2020-04-12 00:00:00 0 2020-04-19 00:00:00
30 30 4525 2020-01-25 00:00:00 714.4149373622754 1 2020-01-26 00:00:00 2020-02-25 00:00:00 0 2020-03-07 00:00:00
31 31 50102 2020-01-28 00:00:00 677.593450041586 1 2020-01-30 00:00:00 2020-02-29 00:00:00 1 2020-02-29 00:00:00
32 32 32754 2020-02-28 00:00:00 747.8282335492122 1 2020-02-29 00:00:00 2020-03-30 00:00:00 0  
33 33 72569 2020-03-06 00:00:00 718.5915511818131 1 2020-03-08 00:00:00 2020-04-07 00:00:00 1 2020-04-07 00:00:00
34 34 10330 2020-01-17 00:00:00 794.1717546636122 1 2020-01-18 00:00:00 2020-02-17 00:00:00 0 2020-02-26 00:00:00
35 35 48716 2020-01-31 00:00:00 635.3016428753108 1 2020-02-02 00:00:00 2020-03-03 00:00:00 0  
36 36 65428 2020-01-01 00:00:00 496.82519170385615 1 2020-01-02 00:00:00 2020-02-01 00:00:00 1 2020-02-01 00:00:00
37 37 9150 2020-03-18 00:00:00 844.6364942692305 1 2020-03-21 00:00:00 2020-04-20 00:00:00 0  
38 38 86676 2020-03-12 00:00:00 804.4560409353794 1 2020-03-15 00:00:00 2020-04-14 00:00:00 0 2020-04-19 00:00:00
39 39 83328 2020-01-01 00:00:00 604.037492508484 1 2020-01-04 00:00:00 2020-02-03 00:00:00 0 2020-02-13 00:00:00
40 40 78834 2020-01-17 00:00:00 798.5374436560564 1 2020-01-18 00:00:00 2020-02-17 00:00:00 0 2020-02-22 00:00:00
41 41 71649 2020-02-24 00:00:00 718.4747229369632 1 2020-02-26 00:00:00 2020-03-27 00:00:00 1 2020-03-27 00:00:00
42 42 61557 2020-01-03 00:00:00 672.6024158928899 1 2020-01-05 00:00:00 2020-02-04 00:00:00 0  
43 43 43076 2020-01-21 00:00:00 813.805682137368 1 2020-01-22 00:00:00 2020-02-21 00:00:00 0 2020-02-28 00:00:00
44 44 8825 2020-01-14 00:00:00 801.0436590156314 1 2020-01-17 00:00:00 2020-02-16 00:00:00 0  
45 45 18975 2020-02-06 00:00:00 712.1365744115111 1 2020-02-07 00:00:00 2020-03-08 00:00:00 0  
46 46 89569 2020-03-28 00:00:00 772.9003152889164 1 2020-03-31 00:00:00 2020-04-30 00:00:00 0 2020-05-11 00:00:00
47 47 97057 2020-02-13 00:00:00 617.1466671770731 1 2020-02-14 00:00:00 2020-03-15 00:00:00 0 2020-03-21 00:00:00
48 48 9037 2020-02-13 00:00:00 504.1631339507252 1 2020-02-15 00:00:00 2020-03-16 00:00:00 1 2020-03-16 00:00:00
49 49 68061 2020-02-15 00:00:00 540.0806619115757 1 2020-02-16 00:00:00 2020-03-17 00:00:00 0  
50 50 11381 2020-03-16 00:00:00 689.3597536065043 1 2020-03-19 00:00:00 2020-04-18 00:00:00 1 2020-04-18 00:00:00
51 51 36677 2020-03-01 00:00:00 739.345561020168 1 2020-03-02 00:00:00 2020-04-01 00:00:00 0  
52 52 21105 2020-02-28 00:00:00 787.645416668245 1 2020-02-29 00:00:00 2020-03-30 00:00:00 1 2020-03-30 00:00:00
53 53 26436 2020-02-26 00:00:00 794.0182974071047 1 2020-02-27 00:00:00 2020-03-28 00:00:00 1 2020-03-28 00:00:00
54 54 93529 2020-02-18 00:00:00 508.04436749204024 1 2020-02-21 00:00:00 2020-03-22 00:00:00 0  
55 55 45823 2020-01-30 00:00:00 722.9872886775231 1 2020-02-01 00:00:00 2020-03-02 00:00:00 0  
56 56 28126 2020-03-08 00:00:00 663.6295208939979 1 2020-03-11 00:00:00 2020-04-10 00:00:00 1 2020-04-10 00:00:00
57 57 97174 2020-02-18 00:00:00 739.3940269349031 1 2020-02-20 00:00:00 2020-03-21 00:00:00 0 2020-03-23 00:00:00
58 58 47140 2020-03-07 00:00:00 619.7542737646153 1 2020-03-10 00:00:00 2020-04-09 00:00:00 0  
59 59 36219 2020-02-14 00:00:00 729.7119670542088 1 2020-02-15 00:00:00 2020-03-16 00:00:00 0 2020-03-23 00:00:00
60 60 1315 2020-01-11 00:00:00 670.0895728264363 1 2020-01-14 00:00:00 2020-02-13 00:00:00 1 2020-02-13 00:00:00
61 61 74178 2020-01-21 00:00:00 677.3399869915943 1 2020-01-23 00:00:00 2020-02-22 00:00:00 0  
62 62 81428 2020-03-17 00:00:00 739.425223495268 1 2020-03-18 00:00:00 2020-04-17 00:00:00 0  
63 63 29801 2020-03-30 00:00:00 638.8332083253185 1 2020-04-02 00:00:00 2020-05-02 00:00:00 1 2020-05-02 00:00:00
64 64 1821 2020-01-05 00:00:00 714.7682628919918 1 2020-01-07 00:00:00 2020-02-06 00:00:00 0 2020-02-14 00:00:00
65 65 26825 2020-01-27 00:00:00 557.3010827550528 1 2020-01-29 00:00:00 2020-02-28 00:00:00 0 2020-03-02 00:00:00
66 66 77827 2020-03-15 00:00:00 793.559504995414 1 2020-03-18 00:00:00 2020-04-17 00:00:00 1 2020-04-17 00:00:00
67 67 41315 2020-02-11 00:00:00 612.3213301723011 1 2020-02-13 00:00:00 2020-03-14 00:00:00 0  
68 68 28417 2020-01-22 00:00:00 693.0883857601312 1 2020-01-25 00:00:00 2020-02-24 00:00:00 0 2020-02-28 00:00:00
69 69 71276 2020-01-12 00:00:00 646.0946668587184 1 2020-01-13 00:00:00 2020-02-12 00:00:00 0  
70 70 82214 2020-03-11 00:00:00 830.9100779305219 1 2020-03-13 00:00:00 2020-04-12 00:00:00 0 2020-04-19 00:00:00
71 71 10824 2020-02-17 00:00:00 621.0629522500085 1 2020-02-20 00:00:00 2020-03-21 00:00:00 0  
72 72 24581 2020-03-25 00:00:00 641.2876744885702 1 2020-03-27 00:00:00 2020-04-26 00:00:00 0  
73 73 53262 2020-01-08 00:00:00 762.4043276240517 1 2020-01-11 00:00:00 2020-02-10 00:00:00 1 2020-02-10 00:00:00
74 74 51454 2020-03-09 00:00:00 705.1748074240021 1 2020-03-12 00:00:00 2020-04-11 00:00:00 1 2020-04-11 00:00:00
75 75 34299 2020-02-27 00:00:00 582.4359865511653 1 2020-02-29 00:00:00 2020-03-30 00:00:00 1 2020-03-30 00:00:00
76 76 852 2020-01-09 00:00:00 578.8767525830397 1 2020-01-12 00:00:00 2020-02-11 00:00:00 1 2020-02-11 00:00:00
77 77 91883 2020-03-19 00:00:00 701.7240849244349 1 2020-03-21 00:00:00 2020-04-20 00:00:00 0  
78 78 48980 2020-02-26 00:00:00 696.4662759284987 1 2020-02-27 00:00:00 2020-03-28 00:00:00 0  
79 79 50261 2020-02-29 00:00:00 715.2946466756109 1 2020-03-03 00:00:00 2020-04-02 00:00:00 0  
80 80 71773 2020-01-03 00:00:00 788.6257424140601 1 2020-01-06 00:00:00 2020-02-05 00:00:00 1 2020-02-05 00:00:00
81 81 79052 2020-03-07 00:00:00 682.6528360210035 1 2020-03-09 00:00:00 2020-04-08 00:00:00 0 2020-04-18 00:00:00
82 82 39591 2020-01-21 00:00:00 616.0749226104153 1 2020-01-24 00:00:00 2020-02-23 00:00:00 0  
83 83 13597 2020-01-29 00:00:00 558.3813875774267 1 2020-01-31 00:00:00 2020-03-01 00:00:00 0  
84 84 48008 2020-02-02 00:00:00 689.7403268311882 1 2020-02-03 00:00:00 2020-03-04 00:00:00 1 2020-03-04 00:00:00
85 85 23966 2020-03-05 00:00:00 702.9790960924814 1 2020-03-06 00:00:00 2020-04-05 00:00:00 1 2020-04-05 00:00:00
86 86 52812 2020-03-28 00:00:00 736.9286280494615 1 2020-03-31 00:00:00 2020-04-30 00:00:00 0  
87 87 69014 2020-03-04 00:00:00 673.942706698589 1 2020-03-07 00:00:00 2020-04-06 00:00:00 0  
88 88 90843 2020-03-02 00:00:00 697.5698992029426 1 2020-03-05 00:00:00 2020-04-04 00:00:00 1 2020-04-04 00:00:00
89 89 34736 2020-02-21 00:00:00 701.3119218045292 1 2020-02-23 00:00:00 2020-03-24 00:00:00 0  
90 90 55233 2020-03-04 00:00:00 593.6203406951253 1 2020-03-05 00:00:00 2020-04-04 00:00:00 0 2020-04-06 00:00:00
91 91 7332 2020-03-19 00:00:00 740.0098972841694 1 2020-03-20 00:00:00 2020-04-19 00:00:00 1 2020-04-19 00:00:00
92 92 63114 2020-02-03 00:00:00 819.5152407908982 1 2020-02-05 00:00:00 2020-03-06 00:00:00 1 2020-03-06 00:00:00
93 93 63967 2020-03-22 00:00:00 834.3811582901177 1 2020-03-24 00:00:00 2020-04-23 00:00:00 0  
94 94 24948 2020-01-09 00:00:00 741.9082646260033 1 2020-01-12 00:00:00 2020-02-11 00:00:00 0 2020-02-15 00:00:00
95 95 19409 2020-01-21 00:00:00 608.6912182684206 1 2020-01-23 00:00:00 2020-02-22 00:00:00 1 2020-02-22 00:00:00
96 96 48224 2020-01-20 00:00:00 686.6610935092456 1 2020-01-23 00:00:00 2020-02-22 00:00:00 0  
97 97 83182 2020-03-20 00:00:00 764.0483660348939 1 2020-03-23 00:00:00 2020-04-22 00:00:00 1 2020-04-22 00:00:00
98 98 28752 2020-03-15 00:00:00 726.59029250302 1 2020-03-18 00:00:00 2020-04-17 00:00:00 0  
99 99 88199 2020-01-25 00:00:00 691.4026433099059 1 2020-01-28 00:00:00 2020-02-27 00:00:00 0  
100 100 83283 2020-03-02 00:00:00 639.8139745889889 1 2020-03-05 00:00:00 2020-04-04 00:00:00 1 2020-04-04 00:00:00

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "loan_performance" ("user_id" BIGINT, "date" TIMESTAMP_NS, "credit_score" DOUBLE, "is_approved" INTEGER, "approved_date" TIMESTAMP_NS, "due_date" TIMESTAMP_NS, "is_timely" INTEGER, "paid_date" TIMESTAMP_NS);
Powered by Datasette · Queries took 48.547ms