names

33 rows where place_id = 783984

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4684837 2260857 2260857 defendant Mast William yeoman 783984 783984 Mast, William, of Wysbech, Cambs, yeoman 0
4846955 2310553 2310553 defendant Dylby Richard tanner 783984 783984 Dylby, Richard, of Wysbech, Cambs, tanner 4
4852905 2312328 2312328 defendant Kepe John yeoman 783984 783984 Kepe, John, of Wysbech, Cambs, yeoman 1
4915452 2331334 2331334 defendant Taillour William yeoman 783984 783984 Taillour, William, of Wysbech, Cambs, yeoman 7
4915640 2331392 2331392 defendant Keep John brewer 783984 783984 Keep, John, of Wysbech, Cambs, brewer 2
4916271 2331595 2331595 defendant Heydon John carpenter 783984 783984 Heydon, John, of Wysbech, Cambs, carpenter 0
4930352 2335893 2335893 defendant Everard John esq 783984 783984 (Everard, John, of Wysbech, Cambs, esq 1
4989334 2353744 2353744 defendant Prest Geoffrey husbandman 783984 783984 Prest, Geoffrey, of Wysbech, Cambs, husbandman 1
4991378 2354304 2354304 defendant Fox John gent 783984 783984 Fox, John, of Wysbech, Cambs, gent 0
4991382 2354305 2354305 defendant Fox John gent 783984 783984 Fox, John, of Wysbech, Cambs, gent 0
4993921 2355052 2355052 defendant Lufday Simon yeoman 783984 783984 Lufday, Simon, of Wysbech, Cambs, yeoman 1
4994586 2355241 2355241 plaintiff Fook John   783984 783984 Fook, John, of Wysbech, Cambs 0
5008525 2359390 2359390 defendant Paternoster Nicholas merchant 783984 783984 Paternoster, Nicholas, of Wysbech, Cambs, merchant 0
5008528 2359391 2359391 defendant Paternoster Nicholas merchant 783984 783984 Paternoster, Nicholas, of Wysbech, Cambs, merchant 0
5008532 2359392 2359392 defendant Paternoster Nicholas merchant 783984 783984 Paternoster, Nicholas, of Wysbech, Cambs, merchant 0
5043313 2369623 2369623 defendant Lomle Richard brewer 783984 783984 (Lomle, Richard, of Wysbech, Cambs, brewer 4
5049775 2371561 2371561 defendant Lambe Richard brewer 783984 783984 Lambe, Richard, of Wysbech, Cambs, brewer 0
5152220 2401782 2401782 defendant Bonyng John, sen butcher 783984 783984 Bonyng, John, sen, of Wysbech, Cambs, butcher 0
5170089 2406983 2406983 defendant Bonyng John, sen butcher 783984 783984 Bonyng, John, sen, of Wysbech, Cambs, butcher 0
5170090 2406983 2406983 defendant Ely Simon mercer 783984 783984 Ely, Simon, of Wysbech, Cambs, mercer 1
5187463 2412053 2412053 defendant Bonyng John butcher 783984 783984 Bonyng, John, of Wysbech, Cambs, butcher 0
5187464 2412053 2412053 defendant Ely Simon mercer 783984 783984 Ely, Simon, of Wysbech, Cambs, mercer 1
5190765 2413052 2413052 defendant Drake William husbandman 783984 783984 Drake, William, of Wysbech, Cambs, husbandman 1
5205110 2417253 2417253 defendant Janne Thomas (legal representative) 783984 783984 Janne, Thomas, of Wysbech, Cambs, husbandman, executors of 0
5207106 2417818 2417818 defendant Drake William husbandman 783984 783984 Drake, William, of Wysbech, Cambs, husbandman 3
5376688 2468304 2468304 defendant Morley Thomas dyer of fabrics 783984 783984 Morley, Thomas, of Wysbech, Cambs, dyer of fabrics 0
5386364 2471167 2471167 defendant Pate Christopher yeoman 783984 783984 Pate, Christopher, of Wysbech, Cambs, yeoman 0
5387414 2471471 2471471 defendant Pygge Robert husbandman 783984 783984 Pygge, Robert, of Wysbech, Cambs, husbandman 0
5393406 2473172 2473172 defendant Bateman Robert husbandman 783984 783984 Bateman, Robert, of Wysbech, Cambs, husbandman 2
5398603 2474662 2474662 defendant Pate Christopher yeoman 783984 783984 Pate, Christopher, of Wysbech, Cambs, yeoman 1
5398604 2474662 2474662 defendant Powedych John   783984 783984 Powedych, John, of Wysbech, Cambs, inn holder 2
5457711 2492203 2492203 defendant Inggram John glover 783984 783984 Inggram, John, of Wysbech, Cambs, glover 4
5468478 2495514 2495514 defendant Orell David gent 783984 783984 Orell, David, of Wysbech, Cambs, gent 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);