names

41 rows where place_id = 599331

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3613306 1871811 1871811 defendant Dryver William husbandman 599331 599331 Dryver, William, of Cretyng St Peter, husbandman 0
3636312 1906149 1906149 defendant Almot Thomas gent 599331 599331 Almot, Thomas, of Cretyng, gent 0
3636313 1906149 1906149 defendant Goode Robert husbandman 599331 599331 Goode, Robert, of Cretyng, husbandman 1
3645077 1908869 1908869 defendant Dryver Richard husbandman 599331 599331 Dryver, Richard, of Cretyng, husbandman 0
3649761 1910288 1910288 defendant Almot Thomas gent 599331 599331 Almot, Thomas, of Cretyng, gent 0
3657230 1912524 1912524 defendant Dryver Richard husbandman 599331 599331 Dryver, Richard, of Cretyng, husbandman 0
3659442 1913213 1913213 defendant Studde Thomas   599331 599331 Studde, Thomas, of Cretyng, lime burner 2
3693446 1924165 1924165 defendant Dryver Richard husbandman 599331 599331 Dryver, Richard, of Cretyng, husbandman 2
3693447 1924165 1924165 defendant Dryver John husbandman 599331 599331 Dryver, John, of Cretyng, husbandman 3
3704682 1927751 1927751 defendant Dryver Richard husbandman 599331 599331 Dryver, Richard, of Cretyng, husbandman 3
3724690 1934007 1934007 defendant Dryver Nicholas yeoman 599331 599331 Dryver, Nicholas, of Cretyng, yeoman 1
3857198 1975884 1975884 defendant Baldry Thomas husbandman 599331 599331 Baldry, Thomas, of Cretyng, husbandman 0
3918547 1996530 1996530 defendant Hyndys alias Hyng Robert yeoman 599331 599331 Hyndys alias Hyng, Robert, of Cretyng St Peter, yeoman 1
3939429 2003492 2003492 defendant Holland Lewis husbandman 599331 599331 Holland, Lewis, of Cretyng St Peter, husbandman 0
3949470 2006887 2006887 defendant Bude Edmund yeoman 599331 599331 Bude, Edmund, of Cretyng, yeoman 0
3952321 2007882 2007882 defendant Payne William husbandman 599331 599331 Payne, William, of Cretyng, husbandman 0
4084946 2054894 2054894 defendant Sympson Luke   599331 599331 Sympson, Luke, of Cretyng, minstrel or musician 2
4524763 2208083 2208083 defendant Merch John   599331 599331 Merch, John, of Cretyng 2
4720986 2271897 2271897 defendant Merssh Robert yeoman 599331 599331 Merssh, Robert, of Cretyng, yeoman 0
4742247 2278221 2278221 defendant Merssh Robert yeoman 599331 599331 Merssh, Robert, of Cretyng, yeoman 0
4751580 2280949 2280949 defendant Berton Richard clerk 599331 599331 Berton, Richard, of Cretyng, clerk 0
4787285 2292093 2292093 defendant Cooke John weaver 599331 599331 Cooke, John, of Cretyng St Peter, weaver 0
4887131 2322819 2322819 defendant Tyler William husbandman 599331 599331 Tyler, William, of Cretyng St Peter, husbandman 0
4894266 2324893 2324893 defendant Havel or Hanel Robert husbandman 599331 599331 Havel or Hanel, Robert, of Cretyng, husbandman 1
4912436 2330394 2330394 defendant Hanell Thomas husbandman 599331 599331 Hanell, Thomas, of Cretyng, husbandman 2
4965468 2346589 2346589 defendant Cook John yeoman 599331 599331 Cook, John, of Cretyng St Peter, yeoman 0
5024025 2363936 2363936 defendant Grene William gent 599331 599331 Grene, William, of Cretyng St Peter, gent 5
5038073 2368020 2368020 defendant Sweyn Thomas husbandman 599331 599331 Sweyn, Thomas, of Cretyng St Peter, husbandman 1
5041418 2369039 2369039 defendant Brene William gent 599331 599331 Brene, William, of Cretyng St Peter, gent 2
5181450 2410315 2410315 defendant Lyng John clerk 599331 599331 Lyng, John, of Cretyng, clerk 1
5194567 2414141 2414141 defendant Coke William yeoman 599331 599331 Coke, William, of Cretyng St peter, yeoman 0
5202933 2416621 2416621 defendant Lyng John clerk 599331 599331 Lyng, John, of Cretyng, clerk 1
5208796 2418299 2418299 defendant Berkewey Richard yeoman 599331 599331 Berkewey, Richard, of Cretyng St Peter, yeoman 0
5208797 2418299 2418299 defendant Berkewey Thomas yeoman 599331 599331 Berkewey, Thomas, of Cretyng St Peter, yeoman 1
5208798 2418299 2418299 defendant Berkewey John yeoman 599331 599331 Berkewey, John, of Cretyng St Peter, yeoman 2
5208805 2418301 2418301 defendant Coke William yeoman 599331 599331 Coke, William, of Cretyng St Peter, yeoman 0
5234628 2425716 2425716 defendant Grene William (legal representative) 599331 599331 Grene, William, of Cretyng St Peter, executors of 0
5234632 2425716 2425716 defendant Reydon Robert gent 599331 599331 Reydon, Robert, of Cretyng St Peter, gent 4
5234638 2425719 2425719 defendant Grene William (legal representative) 599331 599331 Grene, William, of Cretyng St Peter, executors of 0
5316261 2449950 2449950 defendant Grene William (legal representative) 599331 599331 Grene, William, of Cretyng St Peter, executors of 0
5583645 2529960 2529960 defendant Bacon Robert husbandman 599331 599331 Bacon, Robert, of Cretyng St Peter, husbandman 3

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