names

42 rows where place_id = 588774

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595537 1866240 1866240 defendant Willesthorp Miles   588774 588774 Willesthorp, Miles, of Willesthorp 0
3612611 1871581 1871581 defendant Spynk Thomas yeoman 588774 588774 Spynk, Thomas, of Willesthorp, yeoman 0
3612613 1871582 1871582 defendant Spynk Thomas yeoman 588774 588774 Spynk, Thomas, of Willesthorp, yeoman 0
3619436 1873653 1873653 defendant Willesthorp Miles esq 588774 588774 Willesthorp, Miles, of Willesthorp, esq 0
3619437 1873653 1873653 defendant Topham William walker 588774 588774 Topham, William, of Willesthorp, walker 1
3619438 1873653 1873653 defendant Laweson William yeoman 588774 588774 Laweson, William, of Willesthorp, yeoman 2
3619439 1873653 1873653 defendant Topham Robert yeoman 588774 588774 Topham, Robert, of Willesthorp, yeoman 3
3619440 1873653 1873653 defendant Spynke John laborer 588774 588774 Spynke, John, of Willesthorp, laborer 4
3619441 1873653 1873653 defendant Thurstane Robert fisher 588774 588774 Thurstane, Robert, of Willesthorp, fisher 5
3619442 1873653 1873653 defendant Johnson William yeoman 588774 588774 Johnson, William, of Willesthorp, yeoman 6
3619443 1873653 1873653 defendant Scott Anthony   588774 588774 Scott, Anthony, of Willesthorp, cook 7
3619444 1873653 1873653 defendant Nelson John laborer 588774 588774 Nelson, John, of Willesthorp, laborer 8
3619445 1873653 1873653 defendant Nelson Ralph laborer 588774 588774 Nelson, Ralph, of Willesthorp, laborer 9
3619446 1873653 1873653 defendant Spynke Thomas yeoman 588774 588774 Spynke, Thomas, of Willesthorp, yeoman 10
3619447 1873653 1873653 defendant Gibson William yeoman 588774 588774 Gibson, William, of Willesthorp, yeoman 11
3619448 1873653 1873653 defendant Beke Richard yeoman 588774 588774 Beke, Richard, of Willesthorp, yeoman 12
3619449 1873653 1873653 defendant Rychardson Brian tailor 588774 588774 Rychardson, Brian, of Willesthorp, tailor 13
3619450 1873653 1873653 defendant Topham Henry yeoman 588774 588774 Topham, Henry, of Willesthorp, yeoman 14
3619451 1873653 1873653 defendant Laweson Thomas yeoman 588774 588774 Laweson, Thomas, of Willesthorp, yeoman 15
3625416 1875486 1875486 plaintiff Willesthorp Miles esq 588774 588774 Willesthorp, Miles, of Willesthorp, esq 0
3729717 1935549 1935549 defendant Watson William yeoman 588774 588774 Watson, William, of Willesthorp, yeoman 0
3792989 1955665 1955665 defendant Watson William yeoman 588774 588774 Watson, William, of Willesthorp, yeoman 1
4492466 2198328 2198328 defendant Holand John   588774 588774 Holand, John, of Willesthorp 0
4532226 2210344 2210344 plaintiff Poucher John   588774 588774 Poucher, John, of Willesthorp 0
4719325 2271388 2271388 defendant Willesthorp Robert esq 588774 588774 Willesthorp, Robert, of Willesthorp, esq 0
4719329 2271389 2271389 defendant Willesthorp Robert esq 588774 588774 Willesthorp, Robert, of Willesthorp, esq 0
4742484 2278302 2278302 defendant Maughan John laborer 588774 588774 Maughan, John, of Willesthorp, laborer 1
4771861 2287176 2287176 defendant Mowegham John husbandman 588774 588774 Mowegham, John, of Willesthorp, husbandman 0
4820831 2302601 2302601 defendant Willesthorp John gent 588774 588774 Willesthorp, John, of Willesthorp, gent 2
4903215 2327614 2327614 defendant Wilson John husbandman 588774 588774 Wilson, John, of Willesthorp, husbandman 2
5013792 2360881 2360881 defendant Gilliam William yeoman 588774 588774 Gilliam, William, of Willesthorp, yeoman 0
5097083 2385579 2385579 defendant Sprot John husbandman 588774 588774 Sprot, John, of Willesthorp, husbandman 0
5122769 2393094 2393094 defendant Sprot John husbandman 588774 588774 Sprot, John, of Willesthorp, husbandman 0
5161999 2404619 2404619 defendant Estby Robert tailor 588774 588774 Estby, Robert, of Willesthorp, tailor 4
5176216 2408734 2408734 defendant Eseby Robert tailor 588774 588774 Eseby, Robert, of Willesthorp, tailor 4
5395210 2473702 2473702 defendant Spynk Thomas husbandman 588774 588774 Spynk, Thomas, of Willesthorp, husbandman 2
5407814 2477313 2477313 plaintiff Willesthorp Miles esq 588774 588774 Willesthorp, Miles, of Willesthorp, esq 0
5408456 2477499 2477499 defendant Spynk Thomas husbandman 588774 588774 Spynk, Thomas, of Willesthorp, husbandman 2
5441472 2487371 2487371 defendant Spynk Thomas husbandman 588774 588774 Spynk, Thomas, of Willesthorp, husbandman 2
5526401 2512832 2512832 defendant Willesthorp Miles esq 588774 588774 Willesthorp, Miles, of Willesthorp, esq 0
5530406 2514024 2514024 defendant Willesthorp Miles esq 588774 588774 Willesthorp, Miles, of Willesthorp, esq 0
5599104 2534602 2534602 defendant Willesthorp Guy esq 588774 588774 Willesthorp, Guy, of Willesthorp, esq 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);