names

33 rows where place_id = 595803

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3621976 1874416 1874416 defendant Bek Thomas yeoman 595803 595803 Bek, Thomas, of Spyllesby, yeoman 0
3626339 1903096 1903096 defendant Bocher Thomas butcher 595803 595803 Bocher, Thomas, of Spyllesby, butcher 1
3719277 1932315 1932315 defendant Nelson Christopher butcher 595803 595803 Nelson, Christopher, of Spyllesby, butcher 0
3771525 1948787 1948787 defendant Taillour John husbandman 595803 595803 Taillour, John, of Spyllesby, husbandman 0
3843900 1971631 1971631 defendant Barnaby Thomas yeoman 595803 595803 Barnaby, Thomas, of Spyllesby, yeoman 2
3893082 1987932 1987932 defendant Tetney Thomas butcher 595803 595803 Tetney, Thomas, of Spyllesby, butcher 2
3927957 1999688 1999688 defendant Benne John mercer 595803 595803 Benne, John, of Spyllesby, mercer 0
3970828 2014380 2014380 defendant Blackborn Thomas gent 595803 595803 Blackborn, Thomas, of Spyllesby, gent 10
3990241 2021265 2021265 plaintiff Bernard Archibald gent 595803 595803 Bernard, Archibald, of Spyllesby, gent 0
4010334 2028461 2028461 defendant Sheppley or Shypley Christopher yeoman or carpenter 595803 595803 Sheppley or Shypley, Christopher, of Spyllesby, yeoman or carpenter 0
4010335 2028461 2028461 defendant Wryght John butcher 595803 595803 Wryght, John, of Spyllesby, butcher 1
4027407 2034449 2034449 defendant Shepley Christopher yeoman 595803 595803 Shepley, Christopher, of Spyllesby, yeoman 1
4027408 2034449 2034449 defendant Shepley Nicholas yeoman 595803 595803 Shepley, Nicholas, of Spyllesby, yeoman 2
4043005 2039973 2039973 defendant Wright Robert husbandman 595803 595803 Wright, Robert, of Spyllesby, or of Stepyng, husbandman 0
4056888 2044844 2044844 defendant Bell Ralph yeoman 595803 595803 Bell, Ralph, of Spyllesby, yeoman 2
4077100 2052092 2052092 defendant Deane Robert clerk 595803 595803 Deane, Robert, of Spyllesby, clerk 1
4120287 2067535 2067535 defendant Northell Robert yeoman 595803 595803 Northell, Robert, of Spyllesby, yeoman 0
4764037 2284740 2284740 defendant Attylburgh John   595803 595803 Attylburgh, John, of Spyllesby, mason 0
4935252 2337427 2337427 defendant Baylly Richard yeoman 595803 595803 Baylly, Richard, of Spyllesby, yeoman 3
4949789 2341924 2341924 defendant Kydnet John butcher 595803 595803 Kydnet, John, of Spyllesby, butcher 0
5023746 2363849 2363849 defendant Coke Richard butcher 595803 595803 Coke, Richard, of Spyllesby, butcher 0
5038196 2368058 2368058 defendant Coke Richard butcher 595803 595803 Coke, Richard, of Spyllesby, butcher 1
5103314 2387400 2387400 defendant Coke Richard butcher 595803 595803 Coke, Richard, of Spyllesby, butcher 0
5123113 2393192 2393192 defendant Merston John yeoman 595803 595803 Merston, John, of Spyllesby, yeoman 0
5124058 2393490 2393490 defendant Marston John yeoman 595803 595803 Marston, John, of Spyllesby, yeoman 1
5145382 2399795 2399795 defendant Cooke Richard, sen husbandman alias butcher 595803 595803 Cooke, Richard, sen, of Spyllesby, husbandman alias butcher 0
5165845 2405754 2405754 defendant Cooke Richard, sen husbandman & butcher 595803 595803 Cooke, Richard, sen, of Spyllesby, husbandman & butcher 0
5180410 2410012 2410012 defendant Cooke Richard, sen husbandman alias butcher 595803 595803 Cooke, Richard, sen, of Spyllesby, husbandman alias butcher 0
5262109 2433896 2433896 defendant Meryman William yeoman 595803 595803 Meryman, William, of Spyllesby, yeoman 0
5287907 2441478 2441478 defendant Boteler William yeoman 595803 595803 Boteler, William, of Spyllesby, yeoman 3
5335066 2455554 2455554 defendant Coteler William yeoman 595803 595803 Coteler, William, of Spyllesby, yeoman 0
5516947 2510126 2510126 defendant Ryk Robert yeoman 595803 595803 Ryk, Robert, of Spyllesby, yeoman 0
5593845 2533061 2533061 defendant Bocher Thomas butcher 595803 595803 Bocher, Thomas, of Spyllesby, butcher 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);