names

58 rows where place_id = 589834

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3598936 1867295 1867295 defendant Rokewode Alice widow 589834 589834 (Rokewode, Alice, of Wyssyngsete, widow 3
3598937 1867295 1867295 defendant Godynowe Roger clerk 589834 589834 Godynowe, Roger, of Wyssyngsete, clerk 4
3601867 1868238 1868238 defendant Godynowe William   589834 589834 Godynowe, William, of Wyssyngsete, wax chandler 0
3601868 1868238 1868238 defendant Godynowe Roger clerk 589834 589834 Godynowe, Roger, of Wyssyngsete, clerk 1
4441395 2182249 2182249 plaintiff Boson John   589834 589834 Boson, John, of Wyssyngsete 0
4552877 2216843 2216843 plaintiff Frary Thomas   589834 589834 Frary, Thomas, of Wyssyngsete 0
4552879 2216844 2216844 plaintiff Frary Thomas   589834 589834 Frary, Thomas, of Wyssyngsete, parson 0
4637353 2242480 2242480 plaintiff Bosyn John   589834 589834 Bosyn, John, of Wyssyngsete 0
4845514 2310109 2310109 defendant Roo John yeoman 589834 589834 Roo, John, of Wyssyngsete, yeoman 2
4847699 2310774 2310774 defendant Bocher Philip butcher 589834 589834 Bocher, Philip, of Wyssyngsete, butcher 2
4897919 2326007 2326007 defendant Barker William barker 589834 589834 Barker, William, of Wyssyngsete, barker 0
4908574 2329237 2329237 defendant Whytemay John reper 589834 589834 Whytemay, John, of Wyssyngsete, reper 1
4922912 2333584 2333584 defendant Barker William yeoman 589834 589834 Barker, William, of Wyssyngsete, yeoman 0
4936849 2337903 2337903 defendant Roo John husbandman 589834 589834 Roo, John, of Wyssyngsete, husbandman 3
4943923 2340066 2340066 defendant Grigges William smith 589834 589834 Grigges, William, of Wyssyngsete, smith 0
4946002 2340738 2340738 defendant Barker John yeoman 589834 589834 Barker, John, of Wyssyngsete, yeoman 1
4950596 2342149 2342149 defendant Barker William husbandman 589834 589834 Barker, William, of Wyssyngsete, husbandman 0
4950597 2342149 2342149 defendant Roo John husbandman 589834 589834 Roo, John, of Wyssyngsete, husbandman 1
4970705 2348179 2348179 defendant Barette Philip butcher 589834 589834 Barette, Philip, of Wyssyngsete, butcher 1
4974613 2349374 2349374 defendant Barker William barker 589834 589834 Barker, William, of Wyssyngsete, barker 1
4976555 2349948 2349948 defendant Roo Nicholas husbandman 589834 589834 Roo, Nicholas, of Wyssyngsete, husbandman 2
5006386 2358767 2358767 defendant Barkere William yeoman 589834 589834 Barkere, William, of Wyssyngsete, yeoman 0
5015317 2361362 2361362 plaintiff Bosum Richard   589834 589834 Bosum, Richard, of Wyssyngsete 0
5048748 2371263 2371263 defendant Candeler or Caudeler John husbandman 589834 589834 Candeler or Caudeler, John, of Wyssyngsete, husbandman 1
5054731 2372993 2372993 defendant Bradlee alias Lynge John husbandman 589834 589834 Bradlee alias Lynge, John, of Wyssyngsete, husbandman 0
5062309 2375288 2375288 defendant Boson William gent 589834 589834 Boson, William, of Wyssyngsete, gent 2
5062313 2375288 2375288 defendant Lynge John yeoman 589834 589834 Lynge, John, of Wyssyngsete, yeoman 6
5067602 2376807 2376807 defendant Lyng John husbandman 589834 589834 Lyng, John, of Wyssyngsete, husbandman 1
5069786 2377456 2377456 defendant Baret Philip butcher 589834 589834 Baret, Philip, of Wyssyngsete, butcher 0
5069788 2377456 2377456 defendant Baret Robert butcher 589834 589834 Baret, Robert, of Wyssyngsete, butcher 2
5075497 2379167 2379167 defendant Lyng John yeoman 589834 589834 Lyng, John, of Wyssyngsete, yeoman 0
5076111 2379356 2379356 defendant Baret Philip butcher 589834 589834 Baret, Philip, of Wyssyngsete, butcher 0
5106703 2388386 2388386 defendant Bylmyn John smith 589834 589834 Bylmyn, John, of Wyssyngsete, smith 2
5128354 2394770 2394770 defendant Lynge John husbandman 589834 589834 Lynge, John, of Wyssyngsete, husbandman 2
5137000 2397337 2397337 defendant Bylmyn John smith 589834 589834 Bylmyn, John, of Wyssyngsete, smith 1
5144102 2399426 2399426 defendant Baret Robert butcher 589834 589834 Baret, Robert, of Wyssyngsete, butcher 1
5144163 2399445 2399445 plaintiff Bylmyn John   589834 589834 Bylmyn, John, of Wyssyngsete 4
5144169 2399446 2399446 plaintiff Bilmyn John   589834 589834 Bilmyn, John, of Wyssyngsete 4
5147442 2400399 2400399 defendant Lenge John husbandman 589834 589834 Lenge, John, of Wyssyngsete, husbandman 2
5179347 2409698 2409698 plaintiff Bylmyn John   589834 589834 Bylmyn, John, of Wyssyngsete 4
5201859 2416310 2416310 plaintiff Bylmyn John   589834 589834 Bylmyn, John, of Wyssyngsete 4
5202952 2416625 2416625 defendant Bosun William esq 589834 589834 Bosun, William, of Wyssyngsete, esq 2
5213045 2419552 2419552 plaintiff Bylmyn John   589834 589834 Bylmyn, John, of Wyssyngsete 4
5213051 2419553 2419553 plaintiff Bylmyn John   589834 589834 Bylmyn, John, of Wyssyngsete 4
5265968 2435110 2435110 defendant Philip Robert butcher 589834 589834 Philip, Robert, of Wyssyngsete, butcher 3
5295156 2443572 2443572 defendant Cheteryng William yeoman 589834 589834 Cheteryng, William, of Wyssyngsete, yeoman 2
5304111 2446238 2446238 defendant Bilmyn Thomas yeoman 589834 589834 Bilmyn, Thomas, of Wyssyngsete, yeoman 1
5304696 2446400 2446400 defendant Phelipp Robert husbandman 589834 589834 Phelipp, Robert, of Wyssyngsete, husbandman 1
5319625 2450965 2450965 defendant Bokenham William yeoman 589834 589834 Bokenham, William, of Wyssyngsete, yeoman 1
5327269 2453227 2453227 defendant Cheteryng William husbandman 589834 589834 Cheteryng, William, of Wyssyngsete, husbandman 3
5347832 2459472 2459472 defendant Fayre William smith 589834 589834 Fayre, William, of Wyssyngsete, smith 4
5488805 2501528 2501528 plaintiff Soweter Edmund   589834 589834 Soweter, Edmund, of Wyssyngsete 1
5494963 2503390 2503390 defendant Fayre William smith 589834 589834 Fayre, William, of Wyssyngsete, smith 6
5495160 2503448 2503448 defendant Rokewode Alice widow 589834 589834 Rokewode, Alice, of Wyssyngsete, or of Warham, widow 0
5496015 2503702 2503702 defendant Grygge John smith 589834 589834 Grygge, John, of Wyssyngsete, smith 5
5502340 2505655 2505655 defendant Bosom John esq 589834 589834 Bosom, John, of Wyssyngsete, esq 0
5625338 2551864 2551864 plaintiff Lyng John   589834 589834 Lyng, John, of Wyssyngsete 0
5625339 2551864 2551864 defendant Knout William   589834 589834 Knout, William, of Wyssyngsete 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);