names

56 rows where place_id = 767813

✎ 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
4543347 2213807 2213807 defendant Gowedyng William   767813 767813 Gowedyng, William, of Hadlow 0
4543348 2213807 2213807 defendant Boweryng Robert   767813 767813 Boweryng, Robert, of Hadlow 1
4543351 2213807 2213807 defendant Sandherst William   767813 767813 Sandherst, William, of Hadlow 4
4567835 2221510 2221510 defendant Lenman John   767813 767813 Lenman, John, of Hadlow 1
4567837 2221510 2221510 defendant Fador Thomas   767813 767813 Fador, Thomas, of Hadlow 3
4589847 2228190 2228190 defendant Brodhet Richard   767813 767813 Brodhet, Richard, of Hadlow 1
4595591 2229884 2229884 defendant Brodhet Richard   767813 767813 Brodhet, Richard, of Hadlow 1
4596868 2230259 2230259 defendant Brodhet Richard   767813 767813 Brodhet, Richard, of Hadlow 0
4697627 2264747 2264747 defendant Bouryng Robert husbandman 767813 767813 Bouryng, Robert, of Hadlow, husbandman 1
4699213 2265220 2265220 defendant Bouryng Robert husbandman 767813 767813 Bouryng, Robert, of Hadlow, husbandman 0
4723162 2272556 2272556 defendant Burdon Richard farmer 767813 767813 Burdon, Richard, of Hadlow, farmer 0
4723674 2272711 2272711 defendant Bouryng Robert husbandman 767813 767813 Bouryng, Robert, of Hadlow, husbandman 0
4732341 2275292 2275292 defendant Burdon Richard husbandman 767813 767813 Burdon, Richard, of Hadlow, husbandman 1
4736861 2276658 2276658 defendant Burdon Richard husbandman 767813 767813 Burdon, Richard, of Hadlow, husbandman 0
4736862 2276658 2276658 defendant Burdon Thomas laborer 767813 767813 Burdon, Thomas, of Hadlow, laborer 1
4737786 2276923 2276923 defendant Lyes John   767813 767813 Lyes, John, of Hadlow, holy water clerk 0
4737789 2276924 2276924 defendant Burdon Richard farmer 767813 767813 Burdon, Richard, of Hadlow, farmer 1
4755641 2282146 2282146 defendant Froumond Nicholas   767813 767813 Froumond, Nicholas, of Hadlow 0
4767826 2285911 2285911 defendant Palmere Hugh carpenter 767813 767813 Palmere, Hugh, of Hadlow, carpenter 1
4770006 2286590 2286590 defendant Daunce John   767813 767813 Daunce, John, of Hadlow, bailiff 0
4773880 2287810 2287810 defendant Burdon Thomas laborer 767813 767813 Burdon, Thomas, of Hadlow, laborer 1
4831184 2305784 2305784 defendant Daunce John husbandman 767813 767813 Daunce, John, of Hadlow, husbandman 2
4847762 2310790 2310790 defendant Neweman Gilbert husbandman 767813 767813 Neweman, Gilbert, of Hadlow, husbandman 1
4912037 2330267 2330267 defendant Mayn Thomas husbandman 767813 767813 Mayn, Thomas, of Hadlow, husbandman 3
4988659 2353564 2353564 defendant Stoperfyld Nicholas husbandman 767813 767813 Stoperfyld, Nicholas, of Hadlow, husbandman 0
5007079 2358965 2358965 defendant Neweman Roger laborer 767813 767813 Neweman, Roger, of Hadlow, laborer 0
5007080 2358965 2358965 defendant Neweman John laborer 767813 767813 Neweman, John, of Hadlow, laborer 1
5007081 2358965 2358965 defendant Gerveys Thomas laborer 767813 767813 Gerveys, Thomas, of Hadlow, laborer 2
5130684 2395464 2395464 plaintiff Ferman Lawrence   767813 767813 Ferman, Lawrence, of Hadlow 0
5150128 2401178 2401178 plaintiff Ferman Lawrence   767813 767813 Ferman, Lawrence, of Hadlow 0
5159021 2403757 2403757 defendant Mayn John, sen fuller 767813 767813 Mayn, John, sen, of Hadlow, fuller 0
5159024 2403757 2403757 defendant Stere Richard smith 767813 767813 Stere, Richard, of Hadlow, smith 3
5168299 2406444 2406444 defendant Symond John husbandman 767813 767813 Symond, John, of Hadlow, husbandman 4
5168798 2406605 2406605 plaintiff Ferman Lawrence   767813 767813 Ferman, Lawrence, of Hadlow 0
5181806 2410422 2410422 defendant Knyght Thomas tailor 767813 767813 Knyght, Thomas, of Hadlow, tailor 0
5189265 2412593 2412593 defendant Stoperfeld Nicholas husbandman 767813 767813 Stoperfeld, Nicholas, of Hadlow, husbandman 0
5189266 2412593 2412593 defendant Fromond Gilbert husbandman 767813 767813 Fromond, Gilbert, of Hadlow, husbandman 1
5193752 2413897 2413897 defendant Godyng John husbandman 767813 767813 Godyng, John, of Hadlow, husbandman 0
5198802 2415401 2415401 defendant Burdon Thomas   767813 767813 Burdon, Thomas, of Hadlow, inland fish seller 3
5204201 2416983 2416983 defendant Symond John husbandman 767813 767813 Symond, John, of Hadlow, husbandman 4
5206455 2417619 2417619 defendant Stopersfeld Nicholas husbandman 767813 767813 Stopersfeld, Nicholas, of Hadlow, husbandman 0
5206456 2417619 2417619 defendant Fromond Gilbert husbandman 767813 767813 Fromond, Gilbert, of Hadlow, husbandman 1
5208333 2418165 2418165 defendant Godyng John husbandman 767813 767813 Godyng, John, of Hadlow, husbandman 0
5208388 2418178 2418178 defendant Andrewe William laborer 767813 767813 Andrewe, William, of Hadlow, laborer 0
5210783 2418885 2418885 defendant Burdon Thomas   767813 767813 Burdon, Thomas, of Hadlow, inland fish seller 3
5250576 2430290 2430290 defendant Andrew John husbandman 767813 767813 Andrew, John, of Hadlow, husbandman 2
5298777 2444620 2444620 defendant Bysschop John yeoman 767813 767813 Bysschop, John, of Hadlow, yeoman 0
5298778 2444620 2444620 defendant Fysschere Richard husbandman 767813 767813 Fysschere, Richard, of Hadlow, husbandman 1
5298779 2444620 2444620 defendant Fromond Gilbert husbandman 767813 767813 Fromond, Gilbert, of Hadlow, husbandman 2
5298780 2444620 2444620 defendant Stopersild Nicholas husbandman 767813 767813 Stopersild, Nicholas, of Hadlow, husbandman 3
5298781 2444620 2444620 defendant Stoperfild Thomas husbandman 767813 767813 Stoperfild, Thomas, of Hadlow, husbandman 4
5303175 2445942 2445942 defendant Fromond Richard yeoman 767813 767813 Fromond, Richard, of Hadlow, yeoman 0
5307525 2447263 2447263 defendant Godyng John yeoman 767813 767813 Godyng, John, of Hadlow, yeoman 0
5308516 2447583 2447583 defendant Codryng John yeoman 767813 767813 Codryng, John, of Hadlow, yeoman 0
5369438 2466033 2466033 defendant Bydynden John mercer 767813 767813 Bydynden, John, of Hadlow, mercer 2
5378498 2468860 2468860 defendant Hatcher Reginald husbandman 767813 767813 Hatcher, Reginald, of Hadlow, husbandman 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);