names

67 rows where place_id = 589224

✎ 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
3596948 1866677 1866677 defendant Dalby Richard husbandman 589224 589224 Dalby, Richard, of Dalby, husbandman 3
3627394 1903422 1903422 defendant Sneyth Thomas gent 589224 589224 Sneyth, Thomas, of Dalby, gent 0
3649695 1910277 1910277 defendant Chamber William yeoman 589224 589224 Chamber, William, of Dalby, yeoman 0
3674882 1918173 1918173 defendant Marlyng John gent 589224 589224 Marlyng, John, of Dalby, gent 0
3674884 1918174 1918174 defendant Marlyng John gent 589224 589224 Marlyng, John, of Dalby, gent 0
3674886 1918175 1918175 defendant Marlyng John gent 589224 589224 Marlyng, John, of Dalby, gent 0
3674887 1918175 1918175 defendant Sotherby John laborer 589224 589224 Sotherby, John, of Dalby, laborer 1
3677881 1919135 1919135 defendant Crosse Thomas laborer 589224 589224 Crosse, Thomas, of Dalby, laborer 0
3677882 1919135 1919135 defendant Gonne John husbandman 589224 589224 Gonne, John, of Dalby, husbandman 1
3677884 1919136 1919136 defendant Gonne John husbandman 589224 589224 Gonne, John, of Dalby, husbandman 0
3677885 1919136 1919136 defendant Crosse Thomas laborer 589224 589224 Crosse, Thomas, of Dalby, laborer 1
3712804 1930321 1930321 defendant Dyk Thomas yeoman 589224 589224 Dyk, Thomas, of Dalby, yeoman 0
3743492 1939840 1939840 defendant Dykes or Dylkes Thomas yeoman 589224 589224 Dykes or Dylkes, Thomas, of Dalby, yeoman 0
3743494 1939841 1939841 defendant Dykes or Dylkes Thomas yeoman 589224 589224 Dykes or Dylkes, Thomas, of Dalby, yeoman 0
3760139 1945167 1945167 defendant Tomson Thomas laborer 589224 589224 Tomson, Thomas, of Dalby, laborer 0
3801830 1958466 1958466 defendant Wilkynson John husbandman 589224 589224 Wilkynson, John, of Dalby, husbandman 0
3815157 1962662 1962662 plaintiff Gun John   589224 589224 Gun, John, of Dalby 0
3825433 1965807 1965807 defendant Gune John husbandman 589224 589224 Gune, John, of Dalby, husbandman 0
3825434 1965807 1965807 defendant Tomson Thomas laborer 589224 589224 Tomson, Thomas, of Dalby, laborer 1
3925725 1998920 1998920 defendant Cardon Richard husbandman 589224 589224 Cardon, Richard, of Dalby, husbandman 0
4041745 2039528 2039528 defendant Wolmer John gent 589224 589224 Wolmer, John, of Dalby, gent 0
4050969 2042790 2042790 plaintiff Whalley Thomas   589224 589224 Whalley, Thomas, of Dalby 0
4464161 2189461 2189461 plaintiff Walssh Thomas   589224 589224 Walssh, Thomas, of Dalby 0
4492931 2198492 2198492 defendant Dalby Henry   589224 589224 Dalby, Henry, of Dalby 0
4499141 2200374 2200374 defendant Freman Thomas   589224 589224 Freman, Thomas, of Dalby 0
4564620 2220491 2220491 defendant Dalby William   589224 589224 Dalby, William, of Dalby 0
4569363 2222008 2222008 defendant Dalby William   589224 589224 Dalby, William, of Dalby 0
4594049 2229401 2229401 defendant Lodys William   589224 589224 Lodys, William, of Dalby, bailiff 2
4601989 2231842 2231842 plaintiff Warde Roger   589224 589224 Warde, Roger, of Dalby, vicar 0
4627255 2239472 2239472 defendant Sheperd John   589224 589224 Sheperd, John, of Dalby 3
4637661 2242563 2242563 defendant Bolt Henry   589224 589224 Bolt, Henry, of Dalby 1
4778736 2289324 2289324 defendant Bigge Robert husbandman 589224 589224 Bigge, Robert, of Dalby, husbandman 0
4781370 2290183 2290183 defendant Dalby John   589224 589224 Dalby, John, of Dalby, franklin 1
4847078 2310587 2310587 defendant Dalby John husbandman 589224 589224 Dalby, John, of Dalby, husbandman 3
4944136 2340134 2340134 defendant Dalby John gent 589224 589224 Dalby, John, of Dalby, gent 0
4965849 2346715 2346715 defendant Tetteney Robert husbandman 589224 589224 Tetteney, Robert, of Dalby, husbandman 2
4966641 2346957 2346957 defendant Tetteney Robert husbandman 589224 589224 Tetteney, Robert, of Dalby, husbandman 2
4979455 2350811 2350811 defendant Dalby John gent 589224 589224 Dalby, John, of Dalby, gent 0
4996310 2355755 2355755 defendant Dalby John husbandman 589224 589224 Dalby, John, of Dalby, husbandman 1
5003826 2358011 2358011 defendant Dalby Richard husbandman 589224 589224 Dalby, Richard, of Dalby, husbandman 0
5013252 2360710 2360710 defendant Tetney Robert husbandman 589224 589224 Tetney, Robert, of Dalby, husbandman 0
5058474 2374086 2374086 defendant Tetney Robert husbandman 589224 589224 Tetney, Robert, of Dalby, husbandman 1
5058476 2374087 2374087 defendant Tetney Robert husbandman 589224 589224 Tetney, Robert, of Dalby, husbandman 0
5082891 2381386 2381386 defendant Coke John husbandman 589224 589224 Coke, John, of Dalby, husbandman 1
5122388 2392974 2392974 defendant Dalby John husbandman 589224 589224 Dalby, John, of Dalby, husbandman 0
5134420 2396561 2396561 defendant Watkyn Ralph husbandman 589224 589224 Watkyn, Ralph, of Dalby, husbandman 1
5151988 2401717 2401717 defendant Tetnay Robert husbandman 589224 589224 Tetnay, Robert, of Dalby, husbandman 1
5178939 2409569 2409569 defendant Dalby John husbandman 589224 589224 Dalby, John, of Dalby, husbandman 1
5178943 2409570 2409570 defendant Kalby John husbandman 589224 589224 Kalby, John, of Dalby, husbandman 1
5201682 2416260 2416260 defendant Dalby John husbandman 589224 589224 Dalby, John, of Dalby, husbandman 1
5229908 2424364 2424364 defendant Fenne William husbandman 589224 589224 Fenne, William, of Dalby, husbandman 0
5260183 2433312 2433312 defendant Tetnay Richard husbandman 589224 589224 Tetnay, Richard, of Dalby, husbandman 0
5289239 2441856 2441856 defendant Joce William barker 589224 589224 Joce, William, of Dalby, barker 2
5316488 2450013 2450013 defendant Tetnay Robert husbandman 589224 589224 Tetnay, Robert, of Dalby, husbandman 0
5364586 2464585 2464585 defendant Brygge Thomas husbandman 589224 589224 Brygge, Thomas, of Dalby, husbandman 0
5364587 2464585 2464585 defendant Brigge Constantine husbandman 589224 589224 Brigge, Constantine, of Dalby, husbandman 1
5364588 2464585 2464585 defendant Freman William laborer 589224 589224 Freman, William, of Dalby, laborer 2
5379426 2469156 2469156 defendant Brigge Thomas husbandman 589224 589224 Brigge, Thomas, of Dalby, husbandman 0
5379427 2469156 2469156 defendant Brigge Constantine husbandman 589224 589224 Brigge, Constantine, of Dalby, husbandman 1
5379428 2469156 2469156 defendant Freman William husbandman 589224 589224 Freman, William, of Dalby, husbandman 2
5383618 2470397 2470397 defendant Bryge Thomas husbandman 589224 589224 Bryge, Thomas, of Dalby, husbandman 0
5389860 2472162 2472162 defendant Cardon William husbandman 589224 589224 Cardon, William, of Dalby, husbandman 0
5402665 2475837 2475837 defendant Cardon William husbandman 589224 589224 Cardon, William, of Dalby, husbandman 0
5488490 2501445 2501445 defendant Kyngston Robert gent 589224 589224 Kyngston, Robert, of Dalby, gent 1
5520473 2511222 2511222 plaintiff Brygge Thomas   589224 589224 Brygge, Thomas, of Dalby 0
5549821 2519981 2519981 plaintiff Brigge Thomas   589224 589224 Brigge, Thomas, of Dalby 0
5577752 2528112 2528112 defendant Dalby Richard husbandman 589224 589224 Dalby, Richard, of Dalby, husbandman 1

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