names

27 rows where place_id = 586746

✎ 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
3589517 1864358 1864358 defendant Wever John innholder 586746 586746 Wever, John, of Northlache, innholder 2
3726741 1934628 1934628 defendant Kyng William husbandman 586746 586746 Kyng, William, of Northlache, husbandman 0
3841567 1970946 1970946 defendant Kyng William husbandman 586746 586746 Kyng, William, of Northlache, husbandman 0
3853280 1974646 1974646 defendant Busshe John merchant of the staple 586746 586746 Busshe, John, of Northlache, merchant of the staple 0
3873968 1981517 1981517 defendant Forde John butcher 586746 586746 Forde, John, of Northlache, butcher 0
3952367 2007899 2007899 defendant Kyrkham Richard glover 586746 586746 Kyrkham, Richard, of Northlache, glover 0
3988178 2020519 2020519 defendant Parker Jane widow 586746 586746 (Parker, Jane, of Northlache, widow 1
3988179 2020519 2020519 defendant Parker Thomas gent 586746 586746 Parker, Thomas, of Northlache, gent 2
3988180 2020519 2020519 defendant Parker Michael gent 586746 586746 Parker, Michael, of Northlache, gent 3
4045404 2040810 2040810 defendant Gregory James ironmonger 586746 586746 Gregory, James, of Northlache, ironmonger 1
4045407 2040811 2040811 defendant Gregory James ironmonger 586746 586746 Gregory, James, of Northlache, ironmonger 1
4232110 2106732 2106732 defendant Parker Thomas gent 586746 586746 Parker, Thomas, of Northlache, gent 0
4282696 2123852 2123852 defendant Knollis Thomas clerk 586746 586746 Knollis, Thomas, of Northlache, or of Cattistoke, Dorset, clerk 0
4304880 2131844 2131844 defendant Hames or Haines or Hawmes or Hawines John slater 586746 586746 Hames or Haines or Hawmes or Hawines, John, of Northlache, slater 0
4315327 2135471 2135471 defendant Mall Thomas tailor 586746 586746 Mall, Thomas, of Northlache, tailor 0
4369703 2154222 2154222 defendant Allen Hugh butcher 586746 586746 Allen, Hugh, of Northlache, butcher 0
4380183 2158015 2158015 defendant Homes John slater 586746 586746 Homes, John, of Northlache, slater 0
4380184 2158015 2158015 defendant Brodehurste Ralph innholder 586746 586746 Brodehurste, Ralph, of Northlache, innholder 1
4381714 2158561 2158561 defendant Churche Thomas mercer 586746 586746 Churche, Thomas, of Northlache, mercer 1
4390169 2161334 2161334 defendant Free Thomas baker 586746 586746 Free, Thomas, of Northlache, baker 0
5260232 2433327 2433327 plaintiff Kynge William   586746 586746 Kynge, William, of Northlache 0
5260234 2433328 2433328 plaintiff Kynge William   586746 586746 Kynge, William, of Northlache 0
5507690 2507308 2507308 defendant Lavender Richard yeoman 586746 586746 Lavender, Richard, of Northlache, yeoman 1
5532898 2514830 2514830 defendant Ocley William husbandman 586746 586746 Ocley, William, of Northlache, husbandman 1
5542524 2517785 2517785 plaintiff Midewyntur William   586746 586746 Midewyntur, William, of Northlache, wool merchant, executrix iof 0
5553214 2520979 2520979 defendant Mydwynter Robert merchant 586746 586746 Mydwynter, Robert, of Northlache, merchant 0
5559246 2522669 2522669 defendant Bygnell Thomas husbandman 586746 586746 Bygnell, Thomas, of Northlache, husbandman 2

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