names

161 rows where place_id = 590944

✎ 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
3602790 1868540 1868540 defendant Coke John carpenter 590944 590944 Coke, John, of Clyve, carpenter 0
3624844 1875305 1875305 defendant Langford John gent 590944 590944 Langford, John, of Clyve, gent 0
3857658 1976032 1976032 defendant Sompner Thomas yeoman 590944 590944 Sompner, Thomas, of Clyve, yeoman 0
4419271 2170906 2170906 defendant Clerk Richard le   590944 590944 Clerk, Richard le, of Clyve, son of Richard 0
4422272 2171835 2171835 defendant Iryssh Richard le   590944 590944 Iryssh, Richard le, of Clyve 0
4422273 2171835 2171835 defendant Smart John   590944 590944 Smart, John, of Clyve 1
4429615 2174054 2174054 defendant Ploume John mariner 590944 590944 Ploume, John, of Clyve, mariner 0
4430109 2174199 2174199 defendant Maryny William le   590944 590944 Maryny, William le, of Clyve 0
4437667 2176539 2176539 plaintiff Wyndesore John de   590944 590944 Wyndesore, John de, of Clyve, parson 0
4444063 2183115 2183115 defendant Symon Richard   590944 590944 Symon, Richard, of Clyve 0
4446930 2183956 2183956 defendant Bocher Richard   590944 590944 Bocher, Richard, of Clyve 0
4455954 2186880 2186880 plaintiff Munde John   590944 590944 Munde, John, of Clyve 0
4462042 2188826 2188826 plaintiff Sudburia Thomas de master & doctor of Laws 590944 590944 Sudburia, Thomas de, of Clyve, parson, master & doctor of Laws 0
4470449 2191404 2191404 defendant Bery William   590944 590944 Bery, William, of Clyve 0
4470454 2191404 2191404 defendant Broune William   590944 590944 Broune, William, of Clyve 5
4471264 2191678 2191678 defendant Synyme William   590944 590944 Synyme, William, of Clyve 0
4482916 2195356 2195356 plaintiff Mowe Augustine (legal representative) 590944 590944 Mowe, Augustine, of Clyve, executors of 0
4515515 2205272 2205272 defendant Goldston Andrew farmer of the manor 590944 590944 Goldston, Andrew, of Clyve, farmer of the manor 0
4528694 2209254 2209254 defendant Plympton John   590944 590944 Plympton, John, of Clyve, abbot 0
4568732 2221803 2221803 defendant Munde John   590944 590944 Munde, John, of Clyve 0
4574400 2223525 2223525 plaintiff Beresworth William   590944 590944 Beresworth, William, of Clyve 0
4577369 2224436 2224436 defendant Bovere William   590944 590944 Bovere, William, of Clyve 0
4601346 2231657 2231657 defendant Tedbolt Thomas   590944 590944 Tedbolt, Thomas, of Clyve 0
4616656 2236212 2236212 defendant Dollyng John   590944 590944 Dollyng, John, of Clyve 0
4620852 2237502 2237502 defendant Cussheman Thomas butcher 590944 590944 Cussheman, Thomas, of Clyve, butcher 0
4633116 2241226 2241226 defendant Alnord John   590944 590944 Alnord, John, of Clyve 0
4637162 2242423 2242423 defendant Brewester Richard   590944 590944 Brewester, Richard, of Clyve 0
4637425 2242497 2242497 defendant Longe William   590944 590944 Longe, William, of Clyve 5
4649488 2245895 2245895 defendant Hore William   590944 590944 Hore, William, of Clyve 6
4651692 2246505 2246505 defendant Lyghtley Thomas yeoman 590944 590944 Lyghtley, Thomas, of Clyve, yeoman 0
4651693 2246505 2246505 defendant Kynot John husbandman 590944 590944 Kynot, John, of Clyve, husbandman 1
4655529 2247624 2247624 defendant Bery William yeoman 590944 590944 Bery, William, of Clyve, yeoman 2
4656877 2248048 2248048 plaintiff Chesse Thomas   590944 590944 Chesse, Thomas, of Clyve 0
4662843 2249841 2249841 plaintiff Fyssher William   590944 590944 Fyssher, William, of Clyve 0
4662845 2249842 2249842 plaintiff Fyssher William   590944 590944 Fyssher, William, of Clyve 0
4668416 2255834 2255834 defendant Horne John husbandman 590944 590944 Horne, John, of Clyve, husbandman 0
4670205 2256385 2256385 defendant Morton Thomas glover 590944 590944 Morton, Thomas, of Clyve, glover 1
4675954 2258090 2258090 defendant Basshe William husbandman 590944 590944 Basshe, William, of Clyve, husbandman 0
4709178 2268236 2268236 defendant Weston Edmund yeoman 590944 590944 Weston, Edmund, of Clyve, yeoman 2
4721219 2271964 2271964 defendant Sade Thomas   590944 590944 Sade, Thomas, of Clyve, shepherd 0
4724841 2273065 2273065 defendant Gy John yeoman 590944 590944 Gy, John, of Clyve, yeoman 0
4746645 2279508 2279508 defendant Cole Robert tailor 590944 590944 Cole, Robert, of Clyve, tailor 2
4755295 2282043 2282043 defendant Nakyngton John   590944 590944 Nakyngton, John, of Clyve, shoe maker 2
4795153 2294631 2294631 defendant Cutby John husbandman 590944 590944 Cutby, John, of Clyve, husbandman 1
4796705 2295123 2295123 defendant Merefeld Philip miller 590944 590944 Merefeld, Philip, of Clyve, miller 0
4811420 2299680 2299680 defendant Draper Thomas husbandman 590944 590944 (Draper, Thomas, of Clyve, husbandman 1
4870079 2317609 2317609 defendant Rychere John laborer 590944 590944 Rychere, John, of Clyve juxta Rochester, laborer 1
4870080 2317609 2317609 defendant Lpngge William skinner 590944 590944 Lpngge, William, of Clyve juxta Rochester, skinner 2
4871498 2318052 2318052 defendant Mepham William yeoman 590944 590944 Mepham, William, of Clyve juxta Rochester, yeoman 2
4871723 2318123 2318123 defendant Borgeys John yeoman 590944 590944 (Borgeys, John, of Clyve, yeoman 1
4889493 2323510 2323510 defendant Barton Robert husbandman 590944 590944 (Barton, Robert, of Clyve, husbandman 1
4890079 2323676 2323676 defendant Rede John yeoman 590944 590944 Rede, John, of Clyve, yeoman 1
4938366 2338378 2338378 defendant Cardon Thomas   590944 590944 Cardon, Thomas, of Clyve, franklin 0
4949247 2341750 2341750 defendant Chapman Richard (legal representative) 590944 590944 Chapman, Richard, of Clyve, executors of 0
4949248 2341750 2341750 defendant Burgeys Roger yeoman 590944 590944 (Burgeys, Roger, of Clyve, yeoman 1
4953978 2343154 2343154 defendant Posok Thomas husbandman 590944 590944 Posok, Thomas, of Clyve, husbandman 0
4953982 2343154 2343154 defendant Colyere Nicholas husbandman 590944 590944 Colyere, Nicholas, of Clyve, husbandman 4
4972962 2348839 2348839 defendant Steward John husbandman 590944 590944 Steward, John, of Clyve, husbandman 0
4972968 2348841 2348841 defendant Steward John husbandman 590944 590944 Steward, John, of Clyve, husbandman 1
4980355 2351067 2351067 defendant Mepham William husbandman 590944 590944 Mepham, William, of Clyve, husbandman 5
4985306 2352525 2352525 defendant Harry Thomas husbandman 590944 590944 Harry, Thomas, of Clyve, husbandman 1
5008301 2359316 2359316 defendant Draper Thomas yeoman 590944 590944 Draper, Thomas, of Clyve, yeoman 0
5028661 2365259 2365259 defendant Morys Nicholas husbandman 590944 590944 Morys, Nicholas, of Clyve, husbandman 0
5059499 2374411 2374411 defendant Pastour Thomas, junior husbandman 590944 590944 Pastour, Thomas, junior, of Clyve, husbandman 0
5059500 2374411 2374411 defendant Fluk Stephen husbandman 590944 590944 Fluk, Stephen, of Clyve, husbandman 1
5068562 2377086 2377086 defendant Pastour Thomas, senior mariner 590944 590944 Pastour, Thomas, senior, of Clyve, mariner 0
5068563 2377086 2377086 defendant Carter John husbandman 590944 590944 Carter, John, of Clyve, husbandman 1
5078756 2380133 2380133 defendant Catter Richard husbandman 590944 590944 Catter, Richard, of Clyve, husbandman 8
5080313 2380603 2380603 defendant Dunston John husbandman 590944 590944 Dunston, John, of Clyve, husbandman 0
5096651 2385455 2385455 defendant Bewelle John husbandman 590944 590944 Bewelle, John, of Clyve, husbandman 0
5101371 2386813 2386813 defendant Cardon Thomas yeoman 590944 590944 Cardon, Thomas, of Clyve, yeoman 0
5101372 2386813 2386813 defendant Colwyn Thomas husbandman 590944 590944 Colwyn, Thomas, of Clyve, husbandman 1
5103478 2387444 2387444 defendant Utteworth William gent 590944 590944 Utteworth, William, of Clyve, gent 0
5103480 2387445 2387445 defendant Utteworth William gent 590944 590944 Utteworth, William, of Clyve, gent 0
5103481 2387445 2387445 defendant Assh John yeoman 590944 590944 Assh, John, of Clyve, yeoman 1
5103482 2387445 2387445 defendant Utteworth Clement gent 590944 590944 Utteworth, Clement, of Clyve, gent 2
5109798 2389296 2389296 defendant Perder John husbandman 590944 590944 Perder, John, of Clyve, husbandman 2
5110174 2389385 2389385 defendant Catter Richard husbandman 590944 590944 Catter, Richard, of Clyve, husbandman 0
5141157 2398536 2398536 defendant Charlhelle John husbandman 590944 590944 Charlhelle, John, of Clyve, husbandman 1
5141159 2398536 2398536 defendant London William husbandman 590944 590944 London, William, of Clyve, husbandman 3
5162336 2404709 2404709 defendant London William husbandman 590944 590944 London, William, of Clyve, husbandman 2
5176434 2408792 2408792 defendant London William husbandman 590944 590944 London, William, of Clyve, husbandman 2
5193909 2413945 2413945 defendant Runham John yeoman 590944 590944 Runham, John, of Clyve, yeoman 0
5193910 2413945 2413945 defendant Catter Richard yeoman 590944 590944 Catter, Richard, of Clyve, yeoman 1
5193912 2413946 2413946 defendant Runham John yeoman 590944 590944 Runham, John, of Clyve, yeoman 0
5198489 2415311 2415311 defendant London William husbandman 590944 590944 London, William, of Clyve, husbandman 2
5213486 2419676 2419676 defendant Clyffe William clerk 590944 590944 Clyffe, William, of Clyve, clerk 0
5221131 2421883 2421883 defendant Elys Richard husbandman 590944 590944 Elys, Richard, of Clyve, husbandman 0
5221132 2421883 2421883 defendant Luton Thomas husbandman 590944 590944 Luton, Thomas, of Clyve, husbandman 1
5233489 2425386 2425386 defendant Soneman John gent 590944 590944 Soneman, John, of Clyve, gent 0
5242160 2427904 2427904 defendant Conton Anne widow 590944 590944 Conton, Anne, of Clyve, widow 3
5254183 2431429 2431429 defendant Mors William husbandman 590944 590944 Mors, William, of Clyve, husbandman 0
5255088 2431703 2431703 defendant Sompnour Robert laborer 590944 590944 Sompnour, Robert, of Clyve, laborer 2
5263049 2434187 2434187 plaintiff Poleyn John   590944 590944 Poleyn, John, of Clyve 0
5263053 2434187 2434187 defendant Elys Thomas laborer 590944 590944 Elys, Thomas, of Clyve, laborer 3
5291827 2442614 2442614 plaintiff Quykerell Robert   590944 590944 Quykerell, Robert, of Clyve 0
5292571 2442824 2442824 defendant Pastor Thomas husbandman 590944 590944 Pastor, Thomas, of Clyve, husbandman 0
5292573 2442824 2442824 defendant Roper Thomas roper 590944 590944 Roper, Thomas, of Clyve, roper 2
5292574 2442824 2442824 defendant Cawedere Richard husbandman 590944 590944 Cawedere, Richard, of Clyve, husbandman 3
5336873 2456094 2456094 defendant Gyell John butcher 590944 590944 Gyell, John, of Clyve, butcher 0

Next page

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