names

62 rows where place_id = 620903

✎ 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
3738331 1938204 1938204 defendant Lewelyn Robert clerk 620903 620903 Lewelyn, Robert, of Derham, clerk 3
3738332 1938204 1938204 defendant Were William yeoman 620903 620903 Were, William, of Derham, yeoman 4
3741754 1939282 1939282 defendant Clerke John gent 620903 620903 (Clerke, John, of Derham, gent 1
3749284 1941706 1941706 defendant Whelewright William husbandman 620903 620903 Whelewright, William, of Derham, husbandman 1
3749285 1941706 1941706 defendant Martyndale Simon husbandman 620903 620903 Martyndale, Simon, of Derham, husbandman 2
3749286 1941706 1941706 defendant Falshed Henry husbandman 620903 620903 Falshed, Henry, of Derham, husbandman 3
3749287 1941706 1941706 defendant Parke John husbandman 620903 620903 Parke, John, of Derham, husbandman 4
3749288 1941706 1941706 defendant Tempe John husbandman 620903 620903 Tempe, John, of Derham, husbandman 5
3758235 1944568 1944568 defendant Peynter William mercer 620903 620903 Peynter, William, of Derham, mercer 0
3951559 2007600 2007600 defendant Walter Robert carpenter 620903 620903 Walter, Robert, of Derham, carpenter 0
3965429 2012520 2012520 defendant Walker Thomas hatter 620903 620903 Walker, Thomas, of Derham, hatter 2
3985305 2019501 2019501 defendant Byrcham Francis husbandman 620903 620903 Byrcham, Francis, of Derham, husbandman 1
4000045 2024780 2024780 defendant Flode Richard hatter 620903 620903 Flode, Richard, of Derham, hatter 2
4112818 2064849 2064849 defendant Best William yeoman 620903 620903 Best, William, of Derham, yeoman 0
4365655 2152774 2152774 defendant Simple Gawin yeoman 620903 620903 Simple, Gawin, of Derham, yeoman 1
4421737 2171680 2171680 defendant Skynnere Thomas   620903 620903 Skynnere, Thomas, of Derham 2
4446602 2183852 2183852 defendant Vicarson Thomas   620903 620903 Vicarson, Thomas, of Derham 0
4490927 2197855 2197855 defendant Frere John   620903 620903 Frere, John, of Derham 0
4517857 2205969 2205969 defendant Ibry William   620903 620903 Ibry, William, of Derham 2
4517858 2205969 2205969 defendant Sharpe John smith 620903 620903 Sharpe, John, of Derham, smith 3
4560117 2219107 2219107 defendant Owyntyn Bartholomew dyer 620903 620903 Owyntyn, Bartholomew, of Derham, dyer 1
4571644 2222707 2222707 defendant Welles William   620903 620903 Welles, William, of Derham 0
4594206 2229454 2229454 defendant Forster Robert   620903 620903 Forster, Robert, of Derham 0
4594211 2229455 2229455 defendant Forster Robert   620903 620903 Forster, Robert, of Derham 0
4602199 2231906 2231906 defendant Alpe Richard   620903 620903 (Alpe, Richard, of Derham 1
4614693 2235606 2235606 defendant Marshall Adam   620903 620903 Marshall, Adam, of Derham, vicar 1
4637535 2242528 2242528 defendant Goldsmyth John   620903 620903 Goldsmyth, John, of Derham 5
4648755 2245696 2245696 defendant Fordham Robert   620903 620903 Fordham, Robert, of Derham 2
4648763 2245697 2245697 defendant Fordham Robert   620903 620903 Fordham, Robert, of Derham 2
4651141 2246361 2246361 defendant Hakun Gawin gent 620903 620903 Hakun, Gawin, of Derham, gent 0
4687827 2261761 2261761 defendant Reper Nicholas yeoman 620903 620903 Reper, Nicholas, of Derham, yeoman 2
4702910 2266306 2266306 defendant Dyllyng Walter husbandman 620903 620903 Dyllyng, Walter, of Derham, husbandman 0
4702911 2266306 2266306 defendant Herward Walter husbandman 620903 620903 Herward, Walter, of Derham, husbandman 1
4702912 2266306 2266306 defendant Dyllyng Thomas husbandman 620903 620903 Dyllyng, Thomas, of Derham, husbandman 2
4702913 2266306 2266306 defendant Heyward John husbandman 620903 620903 Heyward, John, of Derham, husbandman 3
4711357 2268885 2268885 plaintiff White William   620903 620903 White, William, of Derham, parson & clerk 4
4721417 2272030 2272030 defendant Smyth John smith 620903 620903 Smyth, John, of Derham, formerly staying in Hardynham, smith 2
4752065 2281090 2281090 defendant Ropere Nicholas yeoman 620903 620903 Ropere, Nicholas, of Derham, yeoman 0
4753787 2281558 2281558 defendant Clerk Roger husbandman 620903 620903 Clerk, Roger, of Derham, husbandman 0
4763247 2284494 2284494 defendant Umfrey Thomas yeoman 620903 620903 Umfrey, Thomas, of Derham, yeoman 0
4810461 2299417 2299417 defendant Sharyngton Henry gent 620903 620903 Sharyngton, Henry, of Derham, bailiff of the Liberty of Ely, gent 0
4831216 2305793 2305793 defendant Prynce John chaplain 620903 620903 Prynce, John, of Derham, chaplain 6
4905121 2328205 2328205 defendant Egglysfeld Thomas gent 620903 620903 Egglysfeld, Thomas, of Derham, gent 0
4905123 2328205 2328205 defendant Belle William yeoman 620903 620903 Belle, William, of Derham, yeoman 2
4905124 2328205 2328205 defendant Whelewryght Robert yeoman 620903 620903 Whelewryght, Robert, of Derham, yeoman 3
4905125 2328205 2328205 defendant Mason William yeoman 620903 620903 Mason, William, of Derham, yeoman 4
4931502 2336234 2336234 defendant Brykesworth John husbandman 620903 620903 Brykesworth, John, of Derham, husbandman 0
4942269 2339575 2339575 plaintiff Fonham alias Barkere Reginald   620903 620903 Fonham alias Barkere, Reginald, of Derham 0
4955017 2343455 2343455 defendant Oysell John yeoman 620903 620903 Oysell, John, of Derham, yeoman 0
4991290 2354281 2354281 defendant Hauker John   620903 620903 Hauker, John, of Derham, parson 0
5047144 2370767 2370767 defendant Thomson John husbandman 620903 620903 Thomson, John, of Derham, husbandman 0
5217059 2420730 2420730 defendant Wynder William gent 620903 620903 Wynder, William, of Derham, gent 0
5226673 2423465 2423465 defendant Cok John husbandman 620903 620903 Cok, John, of Derham, husbandman 1
5262043 2433878 2433878 defendant Weste Thomas husbandman 620903 620903 Weste, Thomas, of Derham, husbandman 1
5354529 2461491 2461491 defendant Fryce John gent 620903 620903 Fryce, John, of Derham, gent 1
5396454 2474081 2474081 defendant Kydman Robert husbandman 620903 620903 Kydman, Robert, of Derham, husbandman 1
5399405 2474906 2474906 defendant Kydman Robert husbandman 620903 620903 Kydman, Robert, of Derham, husbandman 1
5420419 2481032 2481032 defendant Lane Richard husbandman 620903 620903 Lane, Richard, of Derham, husbandman 1
5504023 2506174 2506174 defendant Davys Walter esq 620903 620903 Davys, Walter, of Derham, esq 0
5587161 2531012 2531012 defendant Tylour Thomas draper 620903 620903 Tylour, Thomas, of Derham, draper 4
5616451 2548944 2548944 defendant Kerre John   620903 620903 Kerre, John, of Derham 2
5631574 2553887 2553887 defendant Ropere Nicholas yeoman 620903 620903 Ropere, Nicholas, of Derham, yeoman 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);