names

38 rows where place_id = 592596

✎ 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
3608208 1870224 1870224 defendant Powelyn William husbandman 592596 592596 Powelyn, William, of Kentford, husbandman 0
3632716 1905049 1905049 defendant Amore John husbandman 592596 592596 Amore, John, of Kentford, husbandman 4
3701075 1926583 1926583 defendant Mortlake Thomas smith 592596 592596 Mortlake, Thomas, of Kentford, smith 2
3797983 1957268 1957268 defendant Rumbylowe Robert husbandman 592596 592596 Rumbylowe, Robert, of kentford, husbandman 0
3819067 1963855 1963855 plaintiff Mortlake Robert smith 592596 592596 Mortlake, Robert, of Kentford, smith 0
4244415 2111108 2111108 defendant Ostler John blacksmith 592596 592596 Ostler, John, of Kentford, blacksmith 0
4359490 2150552 2150552 defendant Fyson John yeoman 592596 592596 Fyson, John, of Kentford, yeoman 0
4420443 2171299 2171299 defendant atte Brigge Robert   592596 592596 atte Brigge, Robert, of Kentford 1
4460273 2188267 2188267 defendant Derman John   592596 592596 Derman, John, of Kentford 0
4463371 2189234 2189234 defendant Deye Geoffrey   592596 592596 Deye, Geoffrey, of Kentford 0
4551144 2216301 2216301 defendant Costyn John   592596 592596 Costyn, John, of Kentford 0
4999449 2356705 2356705 defendant Wymbyssh John husbandman 592596 592596 Wymbyssh, John, of Kentford, husbandman 3
5008460 2359367 2359367 defendant Taillour Thomas tailor 592596 592596 Taillour, Thomas, of Kentford, tailor 0
5125421 2393919 2393919 defendant Tudenham John husbandman 592596 592596 Tudenham, John, of Kentford, husbandman 0
5125982 2394084 2394084 defendant (illegible) (illegible) butcher 592596 592596 --,--, of Kentford, butcher 4
5133287 2396223 2396223 defendant Costyn John laborer 592596 592596 Costyn, John, of Kentford, laborer 1
5144042 2399405 2399405 defendant Hadenham John husbandman 592596 592596 Hadenham, John, of Kentford, husbandman 0
5144583 2399575 2399575 defendant Geppes Geoffrey butcher 592596 592596 Geppes, Geoffrey, of Kentford, butcher 4
5165030 2405513 2405513 defendant Hadenham John husbandman 592596 592596 Hadenham, John, of Kentford, husbandman 0
5194814 2414224 2414224 defendant Jeppes Geoffrey butcher 592596 592596 Jeppes, Geoffrey, of Kentford, butcher 3
5208950 2418344 2418344 defendant Jeppes Geoffrey butcher 592596 592596 Jeppes, Geoffrey, of Kentford, butcher 3
5213316 2419626 2419626 defendant Couper William yeoman 592596 592596 Couper, William, of Kentford, yeoman 2
5371515 2466676 2466676 defendant Hadnam John husbandman 592596 592596 Hadnam, John, of Kentford, husbandman 0
5377959 2468687 2468687 plaintiff Tempell John   592596 592596 Tempell, John, of Kentford 0
5386592 2471229 2471229 defendant Tompell John pedder 592596 592596 Tompell, John, of Kentford, pedder 15
5390678 2472397 2472397 defendant Hadnam John husbandman 592596 592596 Hadnam, John, of Kentford, husbandman 0
5395305 2473732 2473732 defendant Cobbe John butcher 592596 592596 Cobbe, John, of Kentford, butcher 3
5408576 2477529 2477529 defendant Cobbe John butcher 592596 592596 Cobbe, John, of Kentford, butcher 2
5411981 2478535 2478535 defendant Tempell John   592596 592596 Tempell, John, of Kentford, pedlar 14
5426529 2482879 2482879 defendant Tempell John   592596 592596 Tempell, John, of Kentford, pedlar 12
5427460 2483162 2483162 defendant Goos Thomas husbandman 592596 592596 Goos, Thomas, of Kentford, husbandman 2
5452596 2490660 2490660 defendant Ware Robert husbandman 592596 592596 Ware, Robert, of Kentford, husbandman 1
5469875 2495913 2495913 defendant Aware Robert husbandman 592596 592596 Aware, Robert, of Kentford, husbandman 1
5479732 2498947 2498947 defendant Cobbe John butcher 592596 592596 Cobbe, John, of Kentford, butcher 4
5480092 2499033 2499033 defendant Ware Robert pulter 592596 592596 Ware, Robert, of Kentford, pulter 1
5516879 2510102 2510102 defendant Gose William maltman 592596 592596 Gose, William, of Kentford, maltman 1
5518623 2510655 2510655 defendant Stuntele John chaplain 592596 592596 Stuntele, John, of Kentford, chaplain 1
5528167 2513374 2513374 defendant Emson Thomas husbandman 592596 592596 Emson, Thomas, of Kentford, husbandman 3

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