names
77 rows where place_id = 670653
This data as json, CSV (advanced)
Suggested facets: forename, occupation, seq
| id ▼ | case_id | role | surname | forename | occupation | place_id | raw_segment | seq |
|---|---|---|---|---|---|---|---|---|
| 3701265 | 1926638 1926638 | defendant | Bythemore | Thomas | gent | 670653 670653 | Bythemore, Thomas, of London, Middle Temple, gent | 1 |
| 3814221 | 1962353 1962353 | defendant | Sunnyff | George | gent | 670653 670653 | Sunnyff, George, of London, Middle Temple, gent | 0 |
| 3964784 | 2012290 2012290 | defendant | Vavasor | Andrew | esq | 670653 670653 | Vavasor, Andrew, of London, Middle Temple, esq | 1 |
| 3997959 | 2024030 2024030 | defendant | Gyslyngham | Nicholas | gent | 670653 670653 | Gyslyngham, Nicholas, of London, Middle Temple, gent | 0 |
| 3998058 | 2024064 2024064 | defendant | Eaton | Ralph | gent | 670653 670653 | Eaton, Ralph, of London, of Middle Temple, gent | 0 |
| 4000876 | 2025085 2025085 | defendant | Tusser | William | gent | 670653 670653 | Tusser, William, of London, Middle Temple, gent | 0 |
| 4001896 | 2025453 2025453 | defendant | Stone | John | gent | 670653 670653 | Stone, John, of London, of Middle Temple, gent | 1 |
| 4003240 | 2025919 2025919 | defendant | Gifforde | John | gent | 670653 670653 | Gifforde, John, of London, Middle Temple, gent | 5 |
| 4003757 | 2026111 2026111 | defendant | Rogers | Andrew | gent | 670653 670653 | Rogers, Andrew, of London, of Middle Temple, gent | 0 |
| 4005176 | 2026629 2026629 | defendant | Bulbecke | John, junior | gent | 670653 670653 | Bulbecke, John, junior, of London, of Middle Temple, gent | 1 |
| 4006178 | 2026981 2026981 | defendant | Fenner | Edward | gent | 670653 670653 | Fenner, Edward, of London, of Middle Temple, gent | 1 |
| 4006528 | 2027115 2027115 | defendant | Fenner | Edward | gent | 670653 670653 | Fenner, Edward, of London, of Middle Temple, gent | 0 |
| 4007362 | 2027413 2027413 | defendant | Baylye or Bayllyffe | William | gent | 670653 670653 | Baylye or Bayllyffe, William, of London, of Middle Temple, gent | 0 |
| 4010914 | 2028681 2028681 | defendant | Gascoigne | Thomas | gent | 670653 670653 | Gascoigne, Thomas, of London, of Middle Temple, gent | 0 |
| 4011266 | 2028804 2028804 | defendant | Rogers | Andrew | gent | 670653 670653 | Rogers, Andrew, of London, of Middle Temple, gent | 0 |
| 4011434 | 2028865 2028865 | defendant | Boughton | William | gent | 670653 670653 | Boughton, William, of London, Middle Temple, gent | 0 |
| 4011435 | 2028865 2028865 | defendant | Chyshull | Lawrence | gent | 670653 670653 | Chyshull, Lawrence, of London, Middle Temple, gent | 1 |
| 4011436 | 2028865 2028865 | defendant | Sandford | Humphrey | gent | 670653 670653 | Sandford, Humphrey, of London, Middle Temple, gent | 2 |
| 4011437 | 2028865 2028865 | defendant | Luter | Thomas | gent | 670653 670653 | Luter, Thomas, of London, Middle Temple, gent | 3 |
| 4011438 | 2028865 2028865 | defendant | Berkley | Henry | gent | 670653 670653 | Berkley, Henry, of London, Middle Temple, gent | 4 |
| 4011439 | 2028865 2028865 | defendant | Sand | Anthony | gent | 670653 670653 | Sand, Anthony, of London, Middle Temple, gent | 5 |
| 4011440 | 2028865 2028865 | defendant | Clamppe | Richard | gent | 670653 670653 | Clamppe, Richard, of London, Middle Temple, gent | 6 |
| 4011441 | 2028865 2028865 | defendant | Halley | Gabriel | gent | 670653 670653 | Halley, Gabriel, of London, Middle Temple, gent | 7 |
| 4011442 | 2028865 2028865 | defendant | Houldforte | Gregory | gent | 670653 670653 | Houldforte, Gregory, of London, Middle Temple, gent | 8 |
| 4011443 | 2028865 2028865 | defendant | Mocket | Timpthy | gent | 670653 670653 | Mocket, Timpthy, of London, Middle Temple, gent | 9 |
| 4011444 | 2028865 2028865 | defendant | Tyrrell | Thomas | 670653 670653 | Tyrrell, Thomas, of London, Middle Temple, gent, son of Henry Tirrell, of Herne, Essex | 10 | |
| 4011445 | 2028865 2028865 | defendant | Coll or Coles | John | gent | 670653 670653 | Coll or Coles, John, of London, Middle Temple, gent | 11 |
| 4011446 | 2028865 2028865 | defendant | Tennaunt | Thomas | gent | 670653 670653 | Tennaunt, Thomas, of London, Middle Temple, gent | 12 |
| 4013015 | 2029386 2029386 | defendant | Tusser | William | gent | 670653 670653 | Tusser, William, of London, Middle Temple, gent | 0 |
| 4013176 | 2029445 2029445 | defendant | Eaton | Ralph | gent | 670653 670653 | Eaton, Ralph, of London, Middle Temple, gent | 1 |
| 4013179 | 2029446 2029446 | defendant | Eaton | Ralph | gent | 670653 670653 | Eaton, Ralph, of London, of Middle Temple, gent | 1 |
| 4013676 | 2029628 2029628 | defendant | Grymston | Edward | gent | 670653 670653 | Grymston, Edward, of London, of Middle Temple, gent | 3 |
| 4017006 | 2030784 2030784 | defendant | Stafford | Edward | gent | 670653 670653 | Stafford, Edward, of London, Middle Temple, gent | 0 |
| 4019606 | 2031739 2031739 | defendant | Felton | Edmund | gent | 670653 670653 | Felton, Edmund, of London, of Middle Temple, gent | 0 |
| 4020281 | 2031975 2031975 | defendant | Tusser | William | gent | 670653 670653 | Tusser, William, of London, Middle Temple, or of Esterford, Essex, gent | 0 |
| 4022870 | 2032904 2032904 | defendant | Grymesdyche | Thomas | gent | 670653 670653 | Grymesdyche, Thomas, of London, of Middle Temple, gent | 0 |
| 4023111 | 2032980 2032980 | defendant | Brunynge | Francis | gent | 670653 670653 | Brunynge, Francis, of London, of Middle Temple, gent | 0 |
| 4023114 | 2032981 2032981 | defendant | Gascoigne | Thomas | gent | 670653 670653 | Gascoigne, Thomas, of London, of Middle Temple, gent | 0 |
| 4023118 | 2032982 2032982 | defendant | Gascoigne | Thomas | gent | 670653 670653 | Gascoigne, Thomas, of London, of Middle Temple, gent | 0 |
| 4025920 | 2033920 2033920 | defendant | Cary | George | gent | 670653 670653 | Cary, George, of London, of Middle Temple, gent | 0 |
| 4028373 | 2034800 2034800 | defendant | Perye | Nicholas | gent | 670653 670653 | Perye, Nicholas, of London, of Middle Temple, gent | 1 |
| 4028376 | 2034801 2034801 | defendant | Perye | Nicholas | gent | 670653 670653 | Perye, Nicholas, of London, of Middle Temple, gent | 1 |
| 4030785 | 2035674 2035674 | defendant | Hyett | John | gent | 670653 670653 | Hyett, John, of London, of Middle Temple, gent | 0 |
| 4032464 | 2036255 2036255 | defendant | Dormer | Timothy | gent | 670653 670653 | Dormer, Timothy, of London, of Middle Temple, gent | 0 |
| 4033423 | 2036609 2036609 | defendant | Gascoigne | Thomas | esq | 670653 670653 | Gascoigne, Thomas, of London, of Middle Temple, esq | 0 |
| 4047672 | 2041615 2041615 | defendant | Symes | William | gent | 670653 670653 | Symes, William, of London, of Middle Temple, gent | 0 |
| 4051723 | 2043035 2043035 | defendant | Wasshe | Henry | gent | 670653 670653 | Wasshe, Henry, of London, of Middle Temple, gent | 0 |
| 4053986 | 2043803 2043803 | defendant | Webbe | Robert | gent | 670653 670653 | Webbe, Robert, of London, of Middle Temple, gent | 0 |
| 4058966 | 2045602 2045602 | defendant | Yowarde | Thomas | gent | 670653 670653 | Yowarde, Thomas, of London, of Middle Temple, gent | 0 |
| 4060686 | 2046226 2046226 | defendant | Northover | William | gent | 670653 670653 | Northover, William, of London, of Middle Temple, gent | 0 |
| 4062256 | 2046792 2046792 | defendant | Grenevile | George | gent | 670653 670653 | Grenevile, George, of London, of Middle Temple, gent | 0 |
| 4066194 | 2048202 2048202 | defendant | Tryce | Richard | gent | 670653 670653 | Tryce, Richard, of London, of Middle Temple, gent | 0 |
| 4067134 | 2048545 2048545 | defendant | Stampe | Edward | gent | 670653 670653 | Stampe, Edward, of London, of Middle Temple, gent | 0 |
| 4067159 | 2048553 2048553 | defendant | Harrys | Thomas | esq | 670653 670653 | Harrys, Thomas, of London, of Middle Temple, esq | 0 |
| 4067161 | 2048554 2048554 | defendant | Harrys | Thomas | esq | 670653 670653 | Harrys, Thomas, of London, of Middle Temple, esq | 0 |
| 4067276 | 2048596 2048596 | defendant | Fletewood | Thomas | gent | 670653 670653 | Fletewood, Thomas, of London, Middle Temple, gent | 0 |
| 4068754 | 2049114 2049114 | defendant | Harris | Thomas | gent | 670653 670653 | Harris, Thomas, of London, of Middle Temple, gent | 0 |
| 4068758 | 2049116 2049116 | defendant | Harrys | Thomas | gent | 670653 670653 | Harrys, Thomas, of London, of Middle Temple, gent | 0 |
| 4069435 | 2049350 2049350 | defendant | Barnebye | John | gent | 670653 670653 | Barnebye, John, of London, of Middle Temple, gent | 1 |
| 4070395 | 2049709 2049709 | defendant | Tusser | William | esq | 670653 670653 | Tusser, William, of London, of Middle Temple, esq | 0 |
| 4070397 | 2049710 2049710 | defendant | Tusser | William | esq | 670653 670653 | Tusser, William, of London, of Middle Temple, esq | 0 |
| 4070745 | 2049831 2049831 | defendant | Fenner | Edward | esq | 670653 670653 | Fenner, Edward, of London, of Middle Temple, esq | 1 |
| 4072371 | 2050421 2050421 | defendant | Webbe | Robert | gent | 670653 670653 | Webbe, Robert, of London, of Middle Temple, gent | 0 |
| 4072619 | 2050512 2050512 | defendant | Coocke | Richard | gent | 670653 670653 | Coocke, Richard, of London, of Middle Temple, gent | 0 |
| 4080542 | 2053354 2053354 | defendant | Rede | Thomas | gent | 670653 670653 | Rede, Thomas, of London, of Middle Temple, gent | 1 |
| 4093475 | 2057981 2057981 | defendant | Wolton | William | gent | 670653 670653 | Wolton, William, of London, of Middle Temple, gent | 0 |
| 4099560 | 2060172 2060172 | defendant | Stampe | Edward | gent | 670653 670653 | Stampe, Edward, of London, of Middle Temple, gent | 0 |
| 4103278 | 2061453 2061453 | defendant | Randolphe | John | gent | 670653 670653 | Randolphe, John, of London, of Middle Temple, gent | 2 |
| 4104971 | 2062052 2062052 | defendant | Jenkes | Francis | gent | 670653 670653 | Jenkes, Francis, of London, of Middle Temple, gent | 0 |
| 4152488 | 2078982 2078982 | defendant | Hord | George | esq | 670653 670653 | Hord, George, of London, of Middle Temple, esq | 2 |
| 4152767 | 2079076 2079076 | defendant | Ryvers | George | gent | 670653 670653 | Ryvers, George, of London, Middle Temple, gent | 2 |
| 4251542 | 2113498 2113498 | defendant | Fettiplace | Anthony | gent | 670653 670653 | Fettiplace, Anthony, of London, of Middle Temple, gent | 0 |
| 4351200 | 2147669 2147669 | defendant | Hochinson | Thomas | esq | 670653 670653 | Hochinson, Thomas, of London, of Middle Temple, esq | 0 |
| 4355971 | 2149306 2149306 | defendant | Calmadye | Josias | gent | 670653 670653 | Calmadye, Josias, of London, of Middle Temple, gent | 0 |
| 4358823 | 2150318 2150318 | defendant | Smythe | Richard | esq | 670653 670653 | Smythe, Richard, of London, of Middle Temple, esq | 0 |
| 4376215 | 2156559 2156559 | defendant | Hochinson | Thomas | esq | 670653 670653 | Hochinson, Thomas, of London, of Middle Temple, esq | 0 |
| 4380066 | 2157974 2157974 | defendant | Bertie | Francis, junior | gent | 670653 670653 | Bertie, Francis, junior, of London, of Middle Temple, gent | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);