names

89 rows where place_id = 586824

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589744 1864431 1864431 defendant Lowthe Thomas esq 586824 586824 Lowthe, Thomas, of Cretyngham, esq 0
3602596 1868472 1868472 defendant Lowthe Thomas   586824 586824 Lowthe, Thomas, of Cretyngham 3
3606641 1869750 1869750 defendant Elyet Robert husbandman 586824 586824 Elyet, Robert, of Cretyngham, husbandman 0
3607055 1869872 1869872 defendant Kene Thomas yeoman 586824 586824 Kene, Thomas, of Cretyngham, yeoman 0
3633328 1905239 1905239 defendant Jenour Robert laborer 586824 586824 Jenour, Robert, of Cretyngham, laborer 0
3633330 1905240 1905240 defendant Jenour Robert laborer 586824 586824 Jenour, Robert, of Cretyngham, laborer 0
3633343 1905243 1905243 defendant Flewet Richard husbandman 586824 586824 Flewet, Richard, of Cretyngham, husbandman 2
3633344 1905243 1905243 defendant Sekylmer John (legal representative) 586824 586824 Sekylmer, John, of Cretyngham, executor of 3
3644428 1908676 1908676 defendant Reydon John husbandman 586824 586824 Reydon, John, of Cretyngham, husbandman 0
3657780 1912684 1912684 defendant Reydon John yeoman 586824 586824 Reydon, John, of Cretyngham, yeoman 2
3657782 1912685 1912685 defendant Reydon John yeoman 586824 586824 Reydon, John, of Cretyngham, yeoman 0
3659329 1913179 1913179 defendant Reydon John yeoman 586824 586824 Reydon, John, of Cretyngham, yeoman 1
3671679 1917128 1917128 defendant Reydon Robert laborer 586824 586824 Reydon, Robert, of Cretyngham, laborer 3
3672216 1917310 1917310 defendant Roydon John husbandman 586824 586824 Roydon, John, of Cretyngham, husbandman 0
3672217 1917310 1917310 defendant Roydon Robert husbandman 586824 586824 Roydon, Robert, of Cretyngham, husbandman 1
3674423 1918045 1918045 defendant Reydon John yeoman 586824 586824 Reydon, John, of Cretyngham, yeoman 0
3676011 1918535 1918535 defendant Justyce Anne widow 586824 586824 Justyce, Anne, of Cretyngham, widow 0
3678470 1919321 1919321 defendant Roydon Robert, senior yeoman 586824 586824 Roydon, Robert, senior, of Cretyngham, yeoman 1
3678471 1919321 1919321 defendant Roydon John yeoman 586824 586824 Roydon, John, of Cretyngham, yeoman 2
3688238 1922472 1922472 defendant Roydon John husbandman 586824 586824 Roydon, John, of Cretyngham, husbandman 0
3688311 1922499 1922499 defendant Reydon John husbandman 586824 586824 Reydon, John, of Cretyngham, husbandman 0
3688313 1922500 1922500 defendant Reydon John husbandman 586824 586824 Reydon, John, of Cretyngham, husbandman 0
3689302 1922818 1922818 defendant Warde John glover 586824 586824 Warde, John, of Cretyngham, glover 1
3689304 1922819 1922819 defendant Warde John glover 586824 586824 Warde, John, of Cretyngham, glover 0
3690387 1923156 1923156 defendant Reydon Robert husbandman 586824 586824 Reydon, Robert, of Cretyngham, husbandman 1
3690446 1923179 1923179 defendant Reydon John yeoman 586824 586824 Reydon, John, of Cretyngham, yeoman 0
3697848 1925548 1925548 defendant Roydon John yeoman 586824 586824 Roydon, John, of Cretyngham, yeoman 0
3698572 1925772 1925772 defendant Reydon John husbandman 586824 586824 Reydon, John, of Cretyngham, husbandman 0
3703074 1927236 1927236 defendant Reydon John, senior yeoman 586824 586824 Reydon, John, senior, of Cretyngham, yeoman 0
3703075 1927236 1927236 defendant Reydon John, junior yeoman 586824 586824 Reydon, John, junior, of Cretyngham, yeoman 1
3704888 1927822 1927822 defendant Reydon John yeoman 586824 586824 Reydon, John, of Cretyngham, yeoman 0
3705625 1928042 1928042 defendant Roydon John husbandman 586824 586824 Roydon, John, of Cretyngham, husbandman 0
3708371 1928912 1928912 defendant Roydon John husbandman 586824 586824 Roydon, John, of Cretyngham, husbandman 0
3712262 1930148 1930148 defendant Reydon John yeoman 586824 586824 Reydon, John, of Cretyngham, yeoman 1
3732200 1936308 1936308 defendant Bekett Lionel tailor 586824 586824 Bekett, Lionel, of Cretyngham, tailor 0
3732201 1936308 1936308 defendant Shyrwyn John   586824 586824 Shyrwyn, John, of Cretyngham, mason 1
3732690 1936456 1936456 defendant Reydon Robert husbandman 586824 586824 Reydon, Robert, of Cretyngham, husbandman, son of Reydon, John, of Cretyngham, husbandman 0
3736364 1937616 1937616 defendant Raydon John husbandman 586824 586824 Raydon, John, of Cretyngham, husbandman 2
3744804 1940274 1940274 defendant Stamperd Thomas husbandman 586824 586824 Stamperd, Thomas, of Cretyngham, husbandman 0
3746561 1940839 1940839 defendant Roydon Robert husbandman 586824 586824 Roydon, Robert, of Cretyngham, husbandman 1
3746759 1940901 1940901 defendant Roydon John yeoman 586824 586824 Roydon, John, of Cretyngham, yeoman 0
3751824 1942489 1942489 defendant Warde John glover 586824 586824 Warde, John, of Cretyngham, glover 1
3762493 1945912 1945912 defendant Stamper Thomas husbandman 586824 586824 Stamper, Thomas, of Cretyngham, husbandman 0
3783847 1952719 1952719 defendant Sympson Nicholas husbandman 586824 586824 Sympson, Nicholas, of Cretyngham, husbandman 3
3791599 1955212 1955212 defendant Samppard Thomas husbandman 586824 586824 Samppard, Thomas, of Cretyngham, husbandman 1
3793482 1955825 1955825 defendant Ward John glover 586824 586824 Ward, John, of Cretyngham, glover 2
3860744 1977085 1977085 defendant Tompson Robert tanner 586824 586824 Tompson, Robert, of Cretyngham, tanner 0
3897967 1989527 1989527 defendant Nycholl John husbandman 586824 586824 Nycholl, John, of Cretyngham, husbandman 0
4457404 2187328 2187328 defendant Rogges John   586824 586824 Rogges, John, of Cretyngham 4
4744455 2278899 2278899 defendant Maryot John yeoman 586824 586824 Maryot, John, of Cretyngham, yeoman 1
4775448 2288318 2288318 defendant Man John yeoman 586824 586824 Man, John, of Cretyngham, yeoman 0
4862942 2315391 2315391 defendant Kene John yeoman 586824 586824 Kene, John, of Cretyngham, yeoman 6
4862943 2315391 2315391 defendant Skeyton John yeoman 586824 586824 Skeyton, John, of Cretyngham, yeoman 7
4911069 2329973 2329973 defendant Broke Simon yeoman 586824 586824 Broke, Simon, of Cretyngham, yeoman 1
4911070 2329973 2329973 defendant Wryght John yeoman 586824 586824 Wryght, John, of Cretyngham, yeoman 2
5102994 2387297 2387297 defendant Mariot William husbandman 586824 586824 Mariot, William, of Cretyngham, husbandman 1
5142862 2399041 2399041 defendant Kene Robert yeoman 586824 586824 Kene, Robert, of Cretyngham, yeoman 0
5164218 2405272 2405272 defendant Kene Robert yeoman 586824 586824 Kene, Robert, of Cretyngham, yeoman 0
5216614 2420588 2420588 defendant Reydon William yeoman 586824 586824 Reydon, William, of Cretyngham, yeoman 2
5288989 2441786 2441786 defendant Reydon William yeoman 586824 586824 Reydon, William, of Cretyngham, yeoman 0
5341648 2457583 2457583 defendant Downe Robert gent 586824 586824 Downe, Robert, of Cretyngham, gent 0
5356822 2462198 2462198 defendant Holm John (legal representative) 586824 586824 Holm, John, of Cretyngham, gent, executors of 2
5356823 2462198 2462198 defendant Holm William yeoman 586824 586824 (Holm, William, of Cretyngham, yeoman 3
5356830 2462198 2462198 defendant Reydon William yeoman 586824 586824 Reydon, William, of Cretyngham, yeoman 10
5358116 2462602 2462602 defendant Crakenell Thomas yeoman 586824 586824 Crakenell, Thomas, of Cretyngham, yeoman 2
5359307 2462947 2462947 defendant Downe Robert gent 586824 586824 Downe, Robert, of Cretyngham, gent 0
5384961 2470771 2470771 defendant Gardener John husbandman 586824 586824 Gardener, John, of Cretyngham, husbandman 0
5384962 2470772 2470772 plaintiff Brook Robert   586824 586824 Brook, Robert, of Cretyngham 0
5384966 2470773 2470773 plaintiff Brook Robert   586824 586824 Brook, Robert, of Cretyngham 0
5384967 2470773 2470773 defendant Mariot William husbandman 586824 586824 Mariot, William, of Cretyngham, husbandman 0
5386470 2471202 2471202 defendant Peverell Alexander husbandman 586824 586824 Peverell, Alexander, of Cretyngham, husbandman 2
5397022 2474228 2474228 plaintiff Brook Robert   586824 586824 Brook, Robert, of Cretyngham 0
5410216 2478007 2478007 plaintiff Brock Robert   586824 586824 Brock, Robert, of Cretyngham 0
5411870 2478503 2478503 defendant Peverell Alexander husbandman 586824 586824 Peverell, Alexander, of Cretyngham, husbandman 1
5420181 2480954 2480954 defendant Peverell Alexander husbandman 586824 586824 Peverell, Alexander, of Cretyngham, husbandman 1
5424025 2482137 2482137 plaintiff Brook Robert   586824 586824 Brook, Robert, of Cretyngham 0
5443079 2487839 2487839 plaintiff Brook Robert   586824 586824 Brook, Robert, of Cretyngham 0
5455788 2491632 2491632 plaintiff Brook Robert   586824 586824 Brook, Robert, of Cretyngham 0
5467629 2495246 2495246 plaintiff Brook Robert   586824 586824 Brook, Robert, of Cretyngham 0
5474333 2497302 2497302 defendant Downe Robert gent 586824 586824 Downe, Robert, of Cretyngham, gent 0
5493663 2503018 2503018 defendant Maryot William husbandman 586824 586824 Maryot, William, of Cretyngham, husbandman 1
5500005 2504955 2504955 plaintiff Reydon William   586824 586824 Reydon, William, of Cretyngham 0
5500006 2504955 2504955 defendant Dene Robert husbandman 586824 586824 Dene, Robert, of Cretyngham, husbandman 0
5500294 2505037 2505037 defendant Reydon William yeoman 586824 586824 Reydon, William, of Cretyngham, yeoman 0
5506412 2506915 2506915 defendant Lowthe Thomas esq 586824 586824 Lowthe, Thomas, of Cretyngham, esq 1
5508655 2507571 2507571 defendant Maryot William husbandman 586824 586824 Maryot, William, of Cretyngham, husbandman 0
5513984 2509220 2509220 defendant Fox John yeoman 586824 586824 Fox, John, of Cretyngham, yeoman 0
5515486 2509685 2509685 defendant Fox John yeoman 586824 586824 Fox, John, of Cretyngham, yeoman 0
5528830 2513538 2513538 defendant Elyot Robert husbandman 586824 586824 Elyot, Robert, of Cretyngham, husbandman 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);