names

73 rows where place_id = 614212

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3702473 1927036 1927036 defendant Catton Gilbert joiner 614212 614212 Catton, Gilbert, of St Martin in the Fields, joiner 1
3715724 1931208 1931208 defendant Catton Gilbert joiner 614212 614212 Catton, Gilbert, of St Martin in the Fields, joiner 0
3726147 1934442 1934442 defendant Sprynkell Henry miller 614212 614212 Sprynkell, Henry, of St Martin in the Fields, miller 0
3730568 1935797 1935797 defendant More John clerk of the Privy Seal 614212 614212 More, John, of St Martin in the Fields, gent, clerk of the Privy Seal 2
3731183 1935975 1935975 defendant Catton Gilbert joiner 614212 614212 Catton, Gilbert, of St Martin in the Fields, joiner 0
3753958 1943187 1943187 defendant Rawlyn John saddler 614212 614212 Rawlyn, John, of St Martin in the Fields, saddler 3
3800294 1958013 1958013 defendant Clerke William limeburner 614212 614212 Clerke, William, of St Martin in the Fields, limeburner 0
3810924 1961318 1961318 defendant Henham Robert butcher 614212 614212 Henham, Robert, of St Martin in the Fields, butcher 0
3853892 1974852 1974852 defendant Goffe John (legal representative) 614212 614212 Goffe, John, of St Martin in the Fields, pinner, executors of 2
3853893 1974852 1974852 defendant Calkerne Robert   614212 614212 (Calkerne, Robert, of St Martin in the Fields, mason 3
3871689 1980767 1980767 defendant Went Henry beer brewer 614212 614212 Went, Henry, of St Martin in the Fields, beer brewer 2
3876665 1982442 1982442 plaintiff Hale Richard (legal representative) 614212 614212 Hale, Richard, of St Martin in the Fields, executor of 0
3912479 1994503 1994503 defendant Wylson Robert pinner 614212 614212 Wylson, Robert, of St Martin in the Fields, pinner 0
3928923 2000011 2000011 defendant Urmestrong Robert glover 614212 614212 Urmestrong, Robert, of St Martin in the Fields, glover 1
3981842 2018263 2018263 plaintiff Robynson Richard   614212 614212 Robynson, Richard, of St Martin in the Fields 0
3987094 2020128 2020128 defendant Smyth Geoffrey yeoman 614212 614212 Smyth, Geoffrey, of St Martin in the Fields, yeoman 0
3996269 2023415 2023415 plaintiff Darlowe alias Dorley Richard innholder 614212 614212 Darlowe alias Dorley, Richard, of St Martin in the Fields, innholder 0
4008900 2027947 2027947 defendant Jones George haberdasher 614212 614212 Jones, George, of St Martin in the Fields, haberdasher 1
4018295 2031270 2031270 defendant Chapman Christopher (legal representative) 614212 614212 Chapman, Christopher, of St Martin in the Fields, bit maker, executrix of 0
4027461 2034470 2034470 defendant Best Robert yeoman 614212 614212 Best, Robert, of St Martin in the Fields, yeoman 1
4039763 2038835 2038835 defendant Powell David yeoman 614212 614212 Powell, David, of St Martin in the Fields, yeoman 0
4039834 2038864 2038864 plaintiff Martyn John beer brewer 614212 614212 Martyn, John, of St Martin in the Fields, beer brewer 0
4041841 2039563 2039563 defendant Lizarde Lewis painter 614212 614212 Lizarde, Lewis, of St Martin in the Fields, painter 2
4041845 2039564 2039564 defendant Lyxyard Lewis painter 614212 614212 Lyxyard, Lewis, of St Martin in the Fields, painter 2
4065623 2047995 2047995 plaintiff Helden Derrick beer brewer 614212 614212 Helden, Derrick, of St Martin in the Fields, beer brewer 0
4071380 2050063 2050063 defendant Frysse Roland (legal representative) 614212 614212 Frysse, Roland, of St Martin in the Fields, shoemaker, executors of 0
4092478 2057614 2057614 defendant Golyghtley Nicholas gent 614212 614212 Golyghtley, Nicholas, of St Martin in the Fields, ,gent 1
4095151 2058593 2058593 defendant Jasper William joyner 614212 614212 Jasper, William, of St Martin in the Fields, joyner 0
4127881 2070261 2070261 defendant Venner William gent 614212 614212 Venner, William, of St Martin in the Fields, gent 0
4148359 2077558 2077558 defendant Penderid Timothy scrivener 614212 614212 Penderid, Timothy, of St Martin in the Fields, scrivener 0
4161675 2082151 2082151 defendant Roweswall William victualer 614212 614212 Roweswall, William, of St Martin in the Fields, victualer 3
4166943 2083937 2083937 defendant Helden Derick beer brewer 614212 614212 Helden, Derick, of St Martin in the Fields, beer brewer 0
4166945 2083938 2083938 defendant Heldon Derrick beer brewer 614212 614212 Heldon, Derrick, of St Martin in the Fields, beer brewer 0
4173264 2086109 2086109 defendant Penderid Timothy scrivener 614212 614212 Penderid, Timothy, of St Martin in the Fields, scrivener 0
4175433 2086878 2086878 defendant Lewys Richard yeoman 614212 614212 Lewys, Richard, of St Martin in the Fields, yeoman 2
4176347 2087204 2087204 defendant Brodebottom James yeoman 614212 614212 Brodebottom, James, of St Martin in the Fields, yeoman 1
4191391 2092557 2092557 defendant Hutchinson George gent 614212 614212 Hutchinson, George, of St Martin in the Fields, or of Fulforde, Crediton, Devon, gent 0
4206145 2097698 2097698 defendant Dryhurst Thomas yeoman 614212 614212 Dryhurst, Thomas, of St Martin in the Fields, yeoman 0
4208695 2098592 2098592 defendant Spylman John goldsmith 614212 614212 Spylman, John, of St Martin in the Fields, goldsmith 0
4219202 2102212 2102212 defendant Runneger John Middx, yeoman 614212 614212 Runneger John, of St Martin in the Fields, Middx, yeoman 3
4220111 2102535 2102535 defendant Younge Mathew gent 614212 614212 Younge, Mathew, of St Martin in the Fields, gent 0
4226283 2104664 2104664 defendant Humble John millener 614212 614212 Humble, John, of St Martin in the Fields, millener 0
4256532 2115153 2115153 defendant Perry William gent 614212 614212 Perry, William, of St Martin in the Fields, or of Staple Inn, Middx, gent 3
4269049 2119242 2119242 defendant Bowland Martin   614212 614212 Bowland, Martin, of St Martin in the Fields, silk man 1
4274956 2121193 2121193 defendant Mowld John tailor 614212 614212 Mowld, John, of St Martin in the Fields, tailor 0
4300267 2130195 2130195 defendant Wylkynson John innholder 614212 614212 Wylkynson, John, of St Martin in the Fields, innholder 0
4324150 2138480 2138480 defendant Sheppye Richard   614212 614212 Sheppye, Richard, of St Martin in the Fields, gun maker 3
4340432 2143918 2143918 defendant Rowlandson Peter cordwainer 614212 614212 Rowlandson, Peter, of St Martin in the Fields, cordwainer 0
4342383 2144608 2144608 defendant Broune Thomas gent 614212 614212 Broune, Thomas, of St Martin in the Fields, or of London, gent 1
4348148 2146598 2146598 defendant Occleston Robert innkeeper 614212 614212 Occleston, Robert, of St Martin in the Fields, innkeeper 0
4372020 2155055 2155055 defendant Eccleston Robert innkeeper 614212 614212 Eccleston, Robert, of St Martin in the Fields, innkeeper 0
4390323 2161386 2161386 defendant Rowlanson Peter cordwainer 614212 614212 Rowlanson, Peter, of St Martin in the Fields, cordwainer 0
4397063 2163585 2163585 defendant Pulleson Michael gent 614212 614212 Pulleson, Michael, of St Martin in the Fields, gent 0
4809557 2299156 2299156 defendant Clerk Robert   614212 614212 Clerk, Robert, of St Martin in the Fields, holy water clerk 1
4993631 2354969 2354969 defendant Davy James brewer 614212 614212 Davy, James, of St Martin in the Fields, brewer 0
4993957 2355065 2355065 defendant Custe William smith 614212 614212 Custe, William, of St Martin in the Fields, near Westminster, smith 0
5152069 2401742 2401742 defendant Marchaunt John armourer 614212 614212 Marchaunt, John, of St Martin in the Fields, armourer 0
5230682 2424586 2424586 defendant Wyldgryce John weaver 614212 614212 Wyldgryce, John, of St Martin in the Fields, weaver 3
5328899 2453721 2453721 defendant Raulynson John laborer 614212 614212 Raulynson, John, of St Martin in the Fields, laborer 2
5335329 2455636 2455636 defendant Neville Katherine   614212 614212 Neville, Katherine, of St Martin in the Fields, widow, Duchess of Norfolk 1
5350987 2460421 2460421 defendant Dyer John dyer 614212 614212 Dyer, John, of St Martin in the Fields, dyer 2
5364330 2464503 2464503 defendant Cowelyng Stephen clerk 614212 614212 Cowelyng, Stephen, of St Martin in the Fields, clerk 1
5391091 2472524 2472524 defendant Salmon Thomas   614212 614212 Salmon, Thomas, of St Martin in the Fields, lime burner 1
5432979 2484830 2484830 defendant Warde Simon sheerman 614212 614212 Warde, Simon, of St Martin in the Fields, sheerman 0
5466234 2494839 2494839 defendant Bowlynge John clerk 614212 614212 Bowlynge, John, of St Martin in the fields, clerk 1
5495052 2503420 2503420 defendant Utur Walter   614212 614212 Utur, Walter, of St Martin in the Fields, hat maker 0
5523085 2512046 2512046 defendant Robynson Robert yeoman 614212 614212 Robynson, Robert, of St Martin in the Fields, yeoman 0
5573527 2526819 2526819 defendant Yong William yeoman 614212 614212 Yong, William, of St Martin in the Fields, yeoman 0
5582788 2529689 2529689 defendant Bancrofte William baker 614212 614212 Bancrofte, William, of St Martin in the Fields, baker 0
5583905 2530044 2530044 defendant Vaus or Vans Richard   614212 614212 Vaus or Vans, Richard, of St Martin in the Fields, clerk, chaplain of St Mary of Runcywall, Charyng Crosse 1
5603346 2535936 2535936 defendant Chamber Henry butcher 614212 614212 Chamber, Henry, of St Martin in the Fields, butcher 0
5603561 2535989 2535989 defendant Chamber Henry butcher 614212 614212 Chamber, Henry, of St Martin in the Fields, butcher 0
5609512 2537870 2537870 defendant Wemy-- Christine widow 614212 614212 Wemy--, Christine, of St Martin in the Fields, widow 2

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