names

56 rows where place_id = 604444

✎ 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
3658005 1912756 1912756 defendant Coke Thomas laborer 604444 604444 Coke, Thomas, of Great Munden, laborer 1
3664694 1914909 1914909 defendant Warner Thomas husbandman 604444 604444 Warner, Thomas, of Great Munden, husbandman 0
3930134 2000423 2000423 defendant Browne Robert yeoman 604444 604444 Browne, Robert, of Great Munden, yeoman 0
3935613 2002226 2002226 defendant Andrew Simon husbandman 604444 604444 Andrew, Simon, of Great Munden, husbandman 0
4523982 2207833 2207833 plaintiff Hertford Thomas (legal representative) 604444 604444 Hertford, Thomas, of Great Munden, parson, executors of 0
4573669 2223278 2223278 defendant Wodbygger John   604444 604444 Wodbygger, John, of Great Munden 0
4733939 2275799 2275799 defendant Auncell John husbandman 604444 604444 Auncell, John, of Great Munden, husbandman 3
4734194 2275875 2275875 defendant Auncell John, sen husbandman 604444 604444 Auncell, John, sen, of Great Munden, husbandman 3
4749651 2280384 2280384 defendant Chief Walter   604444 604444 Chief, Walter, of Great Munden 0
4850554 2311635 2311635 defendant Malyns Philip yeoman 604444 604444 Malyns, Philip, of Great Munden, yeoman 0
4850555 2311635 2311635 defendant Beche John husbandman 604444 604444 Beche, John, of Great Munden, husbandman 1
4917553 2332005 2332005 defendant Lyncolne John   604444 604444 Lyncolne, John, of Great Munden 2
4985902 2352699 2352699 plaintiff Andrewe William   604444 604444 Andrewe, William, of Great Munden 0
4985904 2352699 2352699 defendant Freman John laborer 604444 604444 Freman, John, of Great Munden, laborer 1
4997222 2356022 2356022 defendant Borell William maltman 604444 604444 Borell, William, of Great Munden, maltman 0
5127484 2394516 2394516 defendant Andrewe William maltman 604444 604444 Andrewe, William, of Great Munden, maltman 1
5131034 2395563 2395563 defendant Brydde Thomas   604444 604444 Brydde, Thomas, of Great Munden, parson 0
5150538 2401297 2401297 defendant Bryde Thomas   604444 604444 Bryde, Thomas, of Great Munden, parson 0
5160549 2404176 2404176 defendant Burnard Robert maltman 604444 604444 Burnard, Robert, of Great Munden, maltman 0
5169044 2406678 2406678 defendant Byrdre Thomas   604444 604444 Byrdre, Thomas, of Great Munden, parson 0
5175317 2408472 2408472 defendant Gayler William maltman 604444 604444 Gayler, William, of Great Munden, maltman 1
5196215 2414643 2414643 defendant Andrewe William   604444 604444 Andrewe, William, of Great Munden, malt man 0
5196406 2414701 2414701 defendant Burnard Robert maltman 604444 604444 Burnard, Robert, of Great Munden, maltman 0
5196408 2414702 2414702 defendant Burnard Robert maltman 604444 604444 Burnard, Robert, of Great Munden, maltman 0
5201462 2416186 2416186 defendant Andrewe William maltman 604444 604444 Andrewe, William, of Great Munden, maltman 0
5204774 2417143 2417143 defendant Bryde Thomas   604444 604444 Bryde, Thomas, of Great Munden, parson 0
5209574 2418541 2418541 defendant Andrewe William maltman 604444 604444 Andrewe, William, of Great Munden, maltman 0
5271868 2436861 2436861 defendant Borell William husbandman 604444 604444 Borell, William, of Great Munden, husbandman 2
5271869 2436861 2436861 defendant Webbe Thomas husbandman 604444 604444 Webbe, Thomas, of Great Munden, husbandman 3
5301949 2445536 2445536 defendant Webbe Thomas husbandman 604444 604444 Webbe, Thomas, of Great Munden, husbandman 0
5364771 2464647 2464647 defendant Benne Thomas husbandman 604444 604444 Benne, Thomas, of Great Munden, husbandman 0
5370274 2466291 2466291 defendant Andrewe Willliam   604444 604444 Andrewe, Willliam, of Great Munden, malt man 3
5386413 2471185 2471185 defendant Baune John husbandman 604444 604444 Baune, John, of Great Munden, husbandman 1
5388605 2471795 2471795 defendant Colt John husbandman 604444 604444 Colt, John, of Great Munden, husbandman 2
5388951 2471898 2471898 defendant Lord John husbandman 604444 604444 Lord, John, of Great Munden, husbandman 11
5389674 2472108 2472108 defendant Wtottyng John maltman 604444 604444 Wtottyng, John, of Great Munden, maltman 3
5398671 2474686 2474686 defendant Benne Henry husbandman 604444 604444 Benne, Henry, of Great Munden, husbandman 1
5401231 2475411 2475411 defendant Colt John husbandman 604444 604444 Colt, John, of Great Munden, husbandman 2
5401371 2475457 2475457 defendant Colt John husbandman 604444 604444 Colt, John, of Great Munden, husbandman 2
5411774 2478476 2478476 defendant Benne Henry husbandman 604444 604444 Benne, Henry, of Great Munden, husbandman 1
5414244 2479193 2479193 defendant Colt John husbandman 604444 604444 Colt, John, of Great Munden, husbandman 2
5426258 2482808 2482808 defendant Benne Henry husbandman 604444 604444 Benne, Henry, of Great Munden, husbandman 1
5429913 2483885 2483885 defendant Colt John husbandman 604444 604444 Colt, John, of Great Munden, husbandman 2
5432692 2484742 2484742 defendant Benne Henry potter 604444 604444 Benne, Henry, of Great Munden, potter 0
5443535 2487980 2487980 defendant Benne Henry husbandman 604444 604444 Benne, Henry, of Great Munden, husbandman 0
5444833 2488347 2488347 defendant Benne Philip husbandman 604444 604444 Benne, Philip, of Great Munden, husbandman 1
5449899 2489857 2489857 defendant Benne Philip husbandman 604444 604444 Benne, Philip, of Great Munden, husbandman 0
5449900 2489857 2489857 defendant Wrottyng John husbandman 604444 604444 Wrottyng, John, of Great Munden, husbandman 1
5456282 2491795 2491795 defendant Benne Henry husbandman 604444 604444 Benne, Henry, of Great Munden, husbandman 0
5456284 2491796 2491796 defendant Denne Henry husbandman 604444 604444 Denne, Henry, of Great Munden, husbandman 0
5465585 2494614 2494614 defendant Brette John maltman 604444 604444 Brette, John, of Great Munden, maltman 1
5465589 2494615 2494615 defendant Brette John maltman 604444 604444 Brette, John, of Great Munden, maltman 1
5465944 2494740 2494740 defendant Duffeld John husbandman 604444 604444 Duffeld, John, of Great Munden, husbandman 1
5468114 2495406 2495406 defendant Benne Henry husbandman 604444 604444 Benne, Henry, of Great Munden, husbandman 0
5472717 2496807 2496807 defendant Duffeld John husbandman 604444 604444 Duffeld, John, of Great Munden, husbandman 1
5610339 2546941 2546941 defendant Caysho Henry   604444 604444 Caysho, Henry, of Great Munden 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);