names

47 rows where place_id = 628987

✎ 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
3785633 1953294 1953294 defendant Foston Peter clerk 628987 628987 Foston, Peter, of Attilburgh, Norf, clerk 2
4524020 2207844 2207844 defendant Tatnello Roger   628987 628987 Tatnello, Roger, of Attilburgh, Norf 1
4675815 2258045 2258045 defendant Patgrys John   628987 628987 Patgrys, John, of Attilburgh, Norf, bailiff 0
4683510 2260444 2260444 defendant Maryon Thomas yeoman 628987 628987 Maryon, Thomas, of Attilburgh, Norf, yeoman 0
4691763 2262956 2262956 defendant Brampton William gent 628987 628987 Brampton, William, of Attilburgh, Norf, gent 2
4735847 2276361 2276361 defendant Brampton Thomas esq 628987 628987 Brampton, Thomas, of Attilburgh, Norf, esq 0
4735966 2276396 2276396 defendant Bocher Peter yeoman 628987 628987 Bocher, Peter, of Attilburgh, Norf, yeoman 1
4735972 2276397 2276397 defendant Bocher Peter yeoman 628987 628987 Bocher, Peter, of Attilburgh, Norf, yeoman 1
4741167 2277920 2277920 defendant Brampton William gent 628987 628987 Brampton, William, of Attilburgh, Norf, gent 0
4753743 2281545 2281545 defendant Brampton William gent 628987 628987 Brampton, William, of Attilburgh, Norf, gent 0
4770379 2286705 2286705 defendant Patgrys John husbandman 628987 628987 Patgrys, John, of Attilburgh, Norf, husbandman 0
4774470 2287999 2287999 defendant Patgrys John husbandman 628987 628987 Patgrys, John, of Attilburgh, Norf, husbandman 0
4787943 2292296 2292296 defendant Wederby John yeoman 628987 628987 Wederby, John, of Attilburgh, Norf, yeoman 0
4822068 2302977 2302977 defendant Brampton William gent 628987 628987 Brampton, William, of Attilburgh, Norf, gent 0
4843170 2309390 2309390 defendant Radclyf John   628987 628987 Radclyf, John, of Attilburgh, Norf, knight 3
4844870 2309919 2309919 defendant Brampton William gent 628987 628987 Brampton, William, of Attilburgh, Norf, gent 4
4845670 2310159 2310159 defendant Patgryse John, sen yeoman 628987 628987 Patgryse, John, sen, of Attilburgh, Norf, yeoman 1
4845735 2310178 2310178 defendant Pyrt Thomas yeoman 628987 628987 Pyrt, Thomas, of Attilburgh, Norf, yeoman 0
4851804 2312001 2312001 defendant Patgrys John yeoman 628987 628987 Patgrys, John, of Attilburgh, Norf, yeoman 0
4884470 2322045 2322045 defendant Warner Henry gent 628987 628987 (Warner, Henry, of Attilburgh, Norf, gent 1
4896319 2325513 2325513 defendant Brampton Thomas, junior (legal representative) 628987 628987 Brampton, Thomas, junior, of Attilburgh, Norf, gent, executor of 0
4897216 2325785 2325785 defendant Warner Henry gent 628987 628987 (Warner, Henry, of Attilburgh, Norf, gent 1
4946045 2340748 2340748 defendant Gravour Robert yeoman 628987 628987 Gravour, Robert, of Attilburgh, Norf, yeoman 3
4980376 2351073 2351073 defendant Grey Robeert engraver 628987 628987 Grey, Robeert, of Attilburgh, Norf, engraver 1
4981810 2351479 2351479 defendant Bret Richard turner 628987 628987 Bret, Richard, of Attilburgh, Norf, turner 0
4993325 2354875 2354875 defendant Symond John chapman 628987 628987 Symond, John, of Attilburgh, Norf, chapman 0
5012826 2360585 2360585 defendant Fyssher Richard clerk 628987 628987 Fyssher, Richard, of Attilburgh, Norf, clerk 0
5019625 2362629 2362629 plaintiff de Radclyff John (legal representative) 628987 628987 de Radclyff, John, of Attilburgh, Norf, knight, executors of 0
5045730 2370357 2370357 defendant Spylman Robert   628987 628987 Spylman, Robert, of Attilburgh, Norf, 3
5113934 2390463 2390463 defendant Leche John husbandman 628987 628987 Leche, John, of Attilburgh, Norf, husbandman 1
5135012 2396737 2396737 defendant Fayrclowe Thomas clerk 628987 628987 Fayrclowe, Thomas, of Attilburgh, Norf, clerk 3
5137964 2397615 2397615 defendant Hilton Agnes widow 628987 628987 Hilton, Agnes, of Attilburgh, Norf, widow 0
5156541 2403066 2403066 defendant Nettilworth Robert yeoman 628987 628987 Nettilworth, Robert, of Attilburgh, Norf, yeoman 5
5171847 2407482 2407482 defendant Fayrclowe Thomas clerk & parson 628987 628987 Fayrclowe, Thomas, of Attilburgh, Norf, clerk & parson 3
5172653 2407728 2407728 defendant Netilworth Robert yeoman 628987 628987 Netilworth, Robert, of Attilburgh, Norf, yeoman 5
5192310 2413488 2413488 defendant Nettileworth Robert yeoman 628987 628987 Nettileworth, Robert, of Attilburgh, Norf, yeoman 3
5208813 2418304 2418304 defendant Radclyff John esq 628987 628987 Radclyff, John, of Attilburgh, Norf, esq 0
5221023 2421848 2421848 defendant Spilman Robert husbandman 628987 628987 Spilman, Robert, of Attilburgh, Norf, husbandman 0
5232802 2425178 2425178 defendant Knyght Robert gent 628987 628987 Knyght, Robert, of Attilburgh, Norf, gent 6
5318521 2450635 2450635 defendant Radclyf Thomas gent 628987 628987 Radclyf, Thomas, of Attilburgh, Norf, gent 1
5346263 2458972 2458972 defendant Brampton Thomas gent 628987 628987 Brampton, Thomas, of Attilburgh, Norf, gent 0
5383737 2470432 2470432 defendant Warner Henry gent 628987 628987 Warner, Henry, of Attilburgh, Norf, gent 3
5430021 2483915 2483915 defendant Canne Bartholomew yeoman 628987 628987 Canne, Bartholomew, of Attilburgh, Norf, yeoman 1
5430029 2483916 2483916 defendant Canne Bartholomew yeoman 628987 628987 Canne, Bartholomew, of Attilburgh, Norf, yeoman 1
5625374 2551872 2551872 defendant Brampton Thomas, senior gent 628987 628987 Brampton, Thomas, senior, of Attilburgh, Norf, gent 0
5625376 2551873 2551873 defendant Brampton Thomas, senior gent 628987 628987 Brampton, Thomas, senior, of Attilburgh, Norf, gent 0
5635252 2554992 2554992 defendant Skeet Thomas   628987 628987 Skeet, Thomas, of Attilburgh, Norf, chopchurch 6

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