names

44 rows where place_id = 590675

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3601956 1868267 1868267 defendant Chapell John gent 590675 590675 Chapell, John, of Weston Turvyle, gent 0
3717133 1931643 1931643 defendant Illyng John husbandman 590675 590675 Illyng, John, of Weston Turvyle, husbandman 0
3719544 1932377 1932377 defendant Eglyngton Geoffrey husbandman 590675 590675 (Eglyngton, Geoffrey, of Weston Turvyle, husbandman 1
3775020 1949921 1949921 defendant Long Robert gent 590675 590675 Long, Robert, of Weston Turvyle, gent 0
3849295 1973373 1973373 defendant Williams Nicholas   590675 590675 Williams, Nicholas, of Weston Turvyle, smith, bailiff of Newport Paynell 0
3859717 1976750 1976750 defendant Thorpe alias Taylour Richard husbandman 590675 590675 Thorpe alias Taylour, Richard, of Weston Turvyle, husbandman 0
3878472 1983044 1983044 defendant Eglyngton Geoffrey husbandman 590675 590675 (Eglyngton, Geoffrey, of Weston Turvyle, husbandman 1
3905730 1992195 1992195 defendant Kene Henry husbandman 590675 590675 Kene, Henry, of Weston Turvyle, husbandman 0
4445356 2183497 2183497 plaintiff Coyntrylle Henry   590675 590675 Coyntrylle, Henry, of Weston Turvyle 0
4607179 2233361 2233361 plaintiff Bedeford John (legal representative) 590675 590675 Bedeford, John, of Weston Turvyle, executors of 0
4607180 2233361 2233361 plaintiff Bedeford Margaret   590675 590675 (Bedeford, Margaret, of Weston Turvyle, formerly wife of John 1
4607181 2233361 2233361 plaintiff Bedeford William brother of John 590675 590675 Bedeford, William, of Weston Turvyle, brother of John 2
4638256 2242733 2242733 defendant Baily John   590675 590675 Baily, John, of Weston Turvyle 0
4653420 2247002 2247002 plaintiff Bedeford John (legal representative) 590675 590675 Bedeford, John, of Weston Turvyle, executors of 0
4653426 2247003 2247003 plaintiff Bedeford John (legal representative) 590675 590675 Bedeford, John, of Weston Turvyle, executors of 0
4668550 2255872 2255872 plaintiff Bedeford John (legal representative) 590675 590675 Bedeford, John, of Weston Turvyle, executors of 0
4680340 2259464 2259464 defendant Cochyn Brian husbandman 590675 590675 Cochyn, Brian, of Weston Turvyle, husbandman 0
4697852 2264824 2264824 defendant Wydmere John (legal representative) 590675 590675 Wydmere, John, of Weston Turvyle, executors of 0
4986879 2353016 2353016 defendant Parker John   590675 590675 Parker, John, of Weston Turvyle, parson & clerk 0
5104850 2387854 2387854 defendant Hartelyngton Robert husbandman 590675 590675 Hartelyngton, Robert, of Weston Turvyle, husbandman 1
5152013 2401725 2401725 defendant Materas Henry husbandman 590675 590675 Materas, Henry, of Weston Turvyle, husbandman 1
5152015 2401725 2401725 defendant Cochyn Geoffrey husbandman 590675 590675 Cochyn, Geoffrey, of Weston Turvyle, husbandman 3
5155964 2402902 2402902 defendant Revenyng William husbandman 590675 590675 Revenyng, William, of Weston Turvyle, husbandman 1
5155965 2402902 2402902 defendant Revenyng Richard husbandman 590675 590675 Revenyng, Richard, of Weston Turvyle, husbandman 2
5155966 2402902 2402902 defendant Revenyng John husbandman 590675 590675 Revenyng, John, of Weston Turvyle, husbandman 3
5166889 2406046 2406046 defendant Towersey John husbandman 590675 590675 Towersey, John, of Weston Turvyle, husbandman 1
5172275 2407615 2407615 defendant Revenyng William husbandman 590675 590675 Revenyng, William, of Weston Turvyle, husbandman 2
5172276 2407615 2407615 defendant Revenyng Richard husbandman 590675 590675 Revenyng, Richard, of Weston Turvyle, husbandman 3
5172277 2407615 2407615 defendant Revenyng John husbandman 590675 590675 Revenyng, John, of Weston Turvyle, husbandman 4
5182021 2410491 2410491 defendant Towersey John husbandman 590675 590675 Towersey, John, of Weston Turvyle, husbandman 0
5191534 2413266 2413266 defendant Revenyng William husbandman 590675 590675 Revenyng, William, of Weston Turvyle, husbandman 2
5191535 2413266 2413266 defendant Revenyng Richard husbandman 590675 590675 Revenyng, Richard, of Weston Turvyle, husbandman 3
5191536 2413266 2413266 defendant Revenyng John   590675 590675 Revenyng, John, of Weston Turvyle 4
5205339 2417316 2417316 defendant Herne Robert, sen husbandman 590675 590675 Herne, Robert, sen, of Weston Turvyle, husbandman 2
5205340 2417316 2417316 defendant Materas Henry husbandman 590675 590675 Materas, Henry, of Weston Turvyle, husbandman 3
5207457 2417921 2417921 defendant Revenyng Richard husbandman 590675 590675 Revenyng, Richard, of Weston Turvyle, husbandman 3
5238377 2426812 2426812 defendant Heron John husbandman 590675 590675 Heron, John, of Weston Turvyle, husbandman 0
5238378 2426812 2426812 defendant Heron Robert husbandman 590675 590675 Heron, Robert, of Weston Turvyle, husbandman 1
5254817 2431623 2431623 defendant Herne or Herve Robert, junior husbandman 590675 590675 Herne or Herve, Robert, junior, of Weston Turvyle, husbandman 2
5264360 2434607 2434607 defendant Herne Robert, junior husbandman 590675 590675 Herne, Robert, junior, of Weston Turvyle, husbandman 3
5271499 2436757 2436757 defendant Herne Robert, senior husbandman 590675 590675 Herne, Robert, senior, of Weston Turvyle, husbandman 3
5369549 2466062 2466062 defendant Fever or Fener John husbandman 590675 590675 Fever or Fener, John, of Weston Turvyle, husbandman 0
5369551 2466063 2466063 defendant Fever or Fener John husbandman 590675 590675 Fever or Fener, John, of Weston Turvyle, husbandman 0
5369552 2466063 2466063 defendant Whyte John husbandman 590675 590675 Whyte, John, of Weston turvyle, husbandman 1

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);